suitable id generator to use?

acha114 · **Joined:** Thu Oct 14, 2004 10:53 pm **Posts:** 45

general question.

I'd like to know what ID generator is the best to use in this situation.

Consider this. I have to develop against both Oracle 10g and SQL Server 2000. So I would like to avoid using both Identity and Sequence at the same time. I don't want to use increment since it is not thread-safe, and I can't use the hilo ones since I have an app server running JTA. My id columns are long types so I cannot use the UUID generators. What options do I have?

Any assisstance appreciated

[b]Hibernate version:2.1.6[/b]

acha114 · **Joined:** Thu Oct 14, 2004 10:53 pm **Posts:** 45

btw, I probably cannot use native since my key columns aren't flagged as Identifier columns.

christian · **Posted:** Wed Nov 17, 2004 4:12 pm

"native"

christian · **Posted:** Wed Nov 17, 2004 4:13 pm

Implement your own IdentifierGenerator.

acha114 · **Joined:** Thu Oct 14, 2004 10:53 pm **Posts:** 45

can you show me some example code of a custom generator and how this can be invoked from the mapping file?

christian · **Posted:** Wed Nov 17, 2004 4:16 pm

Please have a look at the existing IdentifierGenerators in Hibernate.

acha114 · **Joined:** Thu Oct 14, 2004 10:53 pm **Posts:** 45

i noted a quote that hilo generators cant work with JTA. I spotted a link here http://www.hibernate.org/Documentation/ ... oGenerator

would this solve this problem? is this the only way to get hilo to work in an app server?