Hi,

We are planning on using hibernate and spring on a new project. In our development environment we are planning on using hypersonic as
our database but in our production environment we will be using oracle.

In oracle we plan to use "sequence" as the generator for primary keys
and for hypersonic we plan to use "identity" (both options are not
supported by either database)

I can't see of a way of switching between the two without having to
change the hibernate mapping for every class. I was hoping to just
change the SQL driver, dialect etc when switching between development
and prod and not have to change any source code or mapping files. Has
anyone come across this problem before and have a more elegant way to
solve this problem.

thanks
Josh

Hi,

I can see two options here which would not require you to create multiple
mapping files, but they're not necessarily pretty:

1. You can write your own generator class, as per the Hibernate reference
section 6.1.4 and configure it using spring at runtime to do the appropriate thing.
2. Use XML include directives to include an XML fragment for the id generator
and use your build system to provide the correct include file based on
your development environment.

HTH.

There is no need to have multiple mapping document for this case.
Assumming your using XML, set the id generate as 'native' and include the sequence name and an argument just as you would for a sequence generator so all will be fine in Oracle - see manual. In the case of HSQL the sequence name argument is ignored since Hibernate will know its using an Identiy (rather than the sequence) generator via the selected dialect.