Hi,

For id generation, I'd like to use sequences on Oracle, and identity on hsqldb. Using:

@GeneratedValue(strategy = GenerationType.AUTO)

works, but I need to use a different sequence name for each table (the default is a single, global sequence called 'hibernate_sequence'). Of course, I can use strategy=SEQUENCE so that I can control the sequence name, but then it doesn't work on hsqldb. Is there any way to use GenerationType.AUTO, and still control the name of the sequence for the cases where the database uses sequences?

Thanks,
Todd Klaus
Kepler Space Telescope
http://kepler.nasa.gov

To answer my own question, the following works. It uses identity on HSQLDB, and my named sequence on Oracle: