Hibernate Generator for Oracle 11g Sequence.

[Gaurav Pravin Dighe]

Hello All,

I am using Oracle 11g and Hibernate 3.6.10 in Java Application. I am at starting level of Hibernate.
I have a table name USERDETAILS

UserDetails
---------------------
userID-----------PK---Oracle 11g Sequence created
userName

Could you please uide me which generatot to be used

Below is the hibernate.cfg.xml

<id name="userID" column="USERID"> <generator class="" /> </id>

Could anyone let me know which generator class to be used?

[Pr Gupta]

You can use sequence generator class.

[Bill Gorder]

You could also look at a table generator. It is a little more portable.

See this blog
http://blog.eyallupu.com/2011/01/hibernatejpa-identity-generators.html

have a look here
http://docs.jboss.org/hibernate/orm/3.5/api/org/hibernate/id/enhanced/TableGenerator.html
and
http://docs.jboss.org/hibernate/orm/3.5/api/org/hibernate/id/MultipleHiLoPerTableGenerator.html

[tester anders]

http://codermanual.blogspot.com/2012/11/hibernate-custom-sequence-for-oracle.html

[Bill Gorder]

Manikandan Govindaraj,
Your post was moved to a new topic.