Auto Increment in hibernate using oracle

Question

I am new to hibernate and I want to insert primary number in my table for unique identification. I am using Oracle as my database so do I need to create sequence in oracle to get auto increment generation number ?

I am using below code but it is not working. I have not created any sequence yet.

 @Id
 @Column(name = "id" )
 @GeneratedValue ( strategy = GenerationType.TABLE)

I have used AUTO, SEQUENCE and IDENTITY but nothing works for me.

You should really only need to have @Id and @GeneratedValue, as the default for generated is auto increment. — Matsemann
– Matsemann, Commented Mar 10, 2014 at 13:10
What does it mean "nothing works"...AUTO will do it for you. — Not a bug
– Not a bug, Commented Mar 10, 2014 at 13:10
@KishanSarsechaGajjar brother i have already tried with it and it gives me this error."Hibernate: select hibernate_sequence.nextval from dual org.hibernate.exception.SQLGrammarException: could not get next sequence value" — Pratik Joshi
– Pratik Joshi, Commented Mar 10, 2014 at 13:21

seph · Accepted Answer · 2014-03-10 13:10:39Z

8

this is one way of using Oracle sequence in a JPA mapped entity:

@Id
@Column(name = "ID")
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQUENCE_NAME")
@SequenceGenerator(name = "SEQUENCE_NAME", sequenceName = "SEQUENCE_NAME", allocationSize = 1, initialValue = 1)

In this way your persist() method will ask for the next value of the sequence in order to use it as ID for your entry.

answered Mar 10, 2014 at 13:10

seph

1181 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Snæbjørn Over a year ago

This causes the following error "sometimes" > error performing isolated work; SQL [n/a]; constraint [SYSTEM.SYS_C0010941]; nested exception is org.hibernate.exception.ConstraintViolationException: error performing isolated work

Java_User · Accepted Answer · 2014-03-10 13:09:06Z

1

You can ue this @GeneratedValue(strategy=GenerationType.AUTO)

@Id
@Column(name = "id" )
@GeneratedValue(strategy=GenerationType.AUTO)

answered Mar 10, 2014 at 13:09

Java_User

1,3213 gold badges27 silver badges38 bronze badges

Comments

Not a bug · Accepted Answer · 2014-03-10 13:47:00Z

0

In GenerationType.TABLE option, ID value will be filled with the column of other table.

If you are using strategy=GenerationType.TABLE you will require to mention the Table from where your ID will be filled.

For example,

@GeneratedValue(strategy=GenerationType.TABLE, generator="course")
@TableGenerator(
    name="course",
    table="GENERATOR_TABLE",
    pkColumnName = "key",
    valueColumnName = "next",
    pkColumnValue="course",
    allocationSize=30
)

And for other option, you can use GenerationType.AUTO option, and let hibernate decide which option to choose according to databse.

 @Id
 @Column(name = "id" )
 @GeneratedValue (strategy = GenerationType.AUTO)

And make sure that you properly configured hibernate.cfg.xml file.

edited Mar 10, 2014 at 13:47

answered Mar 10, 2014 at 13:39

Not a bug

4,3342 gold badges43 silver badges82 bronze badges

Collectives™ on Stack Overflow

Auto Increment in hibernate using oracle

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related