Database independent persistence

[cfly]

Hi,
I have some persistent entities that need to be run on two separate JBoss servers. One of which is connected to an oracle database and the other connected to a mssql database.

This causes problems with the database specific primary key generation and the only way I can find round it is to create separate bean instances for each server. Is there another way? Could I extend the @GeneratedValue class and provide fucntionality to check which database is used and then provide the correct implementation.

Thanks.

[vjtech20nn]

How about following parameters for @GeneratedValue annotations.

strategy = GenerationType.AUTO

http://www.jboss.org/community/wiki/GeneratedValue

http://docs.jboss.org/hibernate/stable/core/reference/en/html_single/#mapping-declaration-id-generator

How about two different mapping file for this Entity depending on environment ? downside is you have 2 create mapping configuration files.


If you come across a solution, please share.