Hibernate version:

2.x

Name and version of the database you are using:

SQL Server
HSQLDB
Oracle

My application is built to support multiple databases. To date I've used a TableHiLoGenerator to generate my keys. As I also need to be able to support bulk inserts this is becoming increasingly undesireable.

I'd switch to sequences but then sql server doesn't support them. I'd switch to an autoincrement column but oracle doesn't support those! Is there any alternative id generation technique that will work well for bulk inserts? Would it be possible to create a custom generate that swaps implementations depending on the dialect?

Regards,

Glen

hmmm ... i don't know if it helps you ...

But perhaps provide your own dialects and an own IdentifierGenerator could be a possibility?
In your Generator you could do something like


In your Generator you could use the built-in-hibernate-generators like used in "IdentifierGeneratorFactory.create".

Like i said ...don't know if it helps you, just a "fast idea" :)

gtx
curio (don't know really much about oracle but wondering that oracle doesn't support autoincrement-fields)

BTW.: For me, not really nice, but possible is to use a sequence and trigger to simulate "autoincrement fields".

Why not just use "native"??

I had it in my mind that native was something else entirely but that sounds like it would work just fine.

sorry!! i've forgotten the simplest way ... :(

In my situtation one db doesn't support neither "identitycoloums" nor "sequences" and "TableHiLo" shouldn't be used because connections are fetched from an application server datasource. Therefore i've simply forgot "native" ... sorry!

gtx
curio