using sequence generator for non primary-key fields

pashadd · **Joined:** Mon Aug 08, 2005 2:02 am **Posts:** 5

How can I insert sequntial long values into a non primary-key field using Hibernate?
Thanks

Hibernate version:
Hibernate 3.0.5
Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:
Oracle 9i
The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

d · **Joined:** Mon Jul 04, 2005 5:19 pm **Posts:** 720

Is there any reason why a database trigger can't be used?

pashadd · **Joined:** Mon Aug 08, 2005 2:02 am **Posts:** 5

A database independent solution is prefered, if possible.

ravisha · **Joined:** Wed Sep 14, 2005 9:28 am **Posts:** 3

Hi ,
I have the same kind of requirement , if you have the answer coild you please let me know,

Thanks and Regards,
Ravisha

max · **Posted:** Mon Sep 26, 2005 3:38 am

write a usertype.

pashadd · **Joined:** Mon Aug 08, 2005 2:02 am **Posts:** 5

pashadd wrote:

How can I insert sequential long values into a non primary-key field using Hibernate?
Thanks

Hibernate version:
Hibernate 3.0.5
Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:
Oracle 9i
The generated SQL (show_sql=true):

Debug level Hibernate log excerpt: