How to generate Primary Key(Data Type int) Auto generation in Oracle using Hibernate Annotation.
In My Sql is working fine using generatedType="AUTO"
But while running Oracle , sequence does not exist error is throwing.
If any body knows about this give me guide line to Auto Generation of Primary key in Oracle.

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

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:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html

Just create the sequence in oracle and everything will be fine!

I am not using Hibernate to generate my database in Oracle, because there were too many issues (can't specify constraint names, for example) that were a problem to the DBA. So, this is how I'm doing generated ids in Oracle:

1) Specify NUMBER(10) or NUMBER(21) as the datatype in Oracle.
2) Create a SEQUENCE in the database for that table.
3) Write a BEFORE INSERT trigger that references the SEQ.

4) Add the following code before the id getter/setter:

@Id
@GeneratedValue(strategy=GenerationType.SEQUENCE,generator="CHATITEM_SEQ_GEN")
@SequenceGenerator(name="CHATITEM_SEQ_GEN", sequenceName="CHATITEM_SEQ",initialValue=1,allocationSize=1)
@Column(name = "CHAT_ITEM_ID", insertable= false, updatable = false)

where CHATITEM_SEQ is the name of the SEQEUNCE in Oracle, CHATITEM_SEQ_GEN is the name of the generator in hibernate, and CHAT_ITEM_ID is the name of the column that will have the value generated.

When doing an insert, do not provide a value for the id column, and Oracle will generate one for you.
Hope this helps.
J

Um, maybe I'm missing something, but that seems awfully redundant. You either want Hibernate to populate the id (using the Oracle sequence) or you want Oracle to do it in the trigger (something I don't recommend).

And why NUMBER(10) or NUMBER(21)?
NUMBER(8) or, even better, just NUMBER would work just as well.

So:

Create the sequence in Oracle:

create sequence chatitem_seq_gen start with 1 nocycle;

And annotate the id getter as follows:

@Id
@GeneratedValue(strategy=GenerationType.SEQUENCE, generator="oracleSequence")
@SequenceGenerator(name="oracleSequence", sequenceName="CHATITEM_SEQ",allocationSize=1)
@Column(name="CHAT_ITEM_ID", insertable=false, updatable=false)

To make it more scalable, remove 'allocationSize=1'

Thanks, I will try that.

Regarding number, etc. I am just doing what our DBA says I must... should have mentioned that.

J