org.hibernate.exception.SQLGrammarException: could not get next sequence value

Question

Am using Hibernate 3.6

Below is Employee class code.

public class Employee {

private int id;

public int getId() {
    return id;
}

public void setId(int id) {
    this.id = id;
}

Below is Employee.hbm.xml file,

<class name="com.testing.hibernate.Employee" table="HIB_EMPLOYEE">
      <meta attribute="class-description">
            This class contains the Employee details.
      </meta>
      <id name="id" type="int" column="id">
         <generator class="sequence"></generator>
      </id>
      <property name="firstName" column="first_name" type="string"></property>
      <property name="lastName" column="last_name" type="string"></property>
      <property name="salary" column="salary" type="int"></property>            
  </class>

I have created sequence in Database. Below SS for reference. How can I overcome the exception that am getting? enter image description here

Post your code for Query!

Siva
– Siva

2013-09-19 12:56:50 +00:00
Commented Sep 19, 2013 at 12:56 — Siva
– Siva, Commented Sep 19, 2013 at 12:56
what is the database you are using

samba
– samba

2013-09-19 12:59:36 +00:00
Commented Sep 19, 2013 at 12:59 — samba
– samba, Commented Sep 19, 2013 at 12:59
@samba Its Oracle 10g

user2488578
– user2488578

2013-09-19 13:13:39 +00:00
Commented Sep 19, 2013 at 13:13 — user2488578
– user2488578, Commented Sep 19, 2013 at 13:13

Abhijith Nagarajan · Accepted Answer · 2013-09-19 12:57:42Z

4

You have to give the reference of the sequence to hibernate.

<generator class="sequence">
     <param name="sequence">SEQUENCE_NAME</param>
</generator>

answered Sep 19, 2013 at 12:57

Abhijith Nagarajan

4,07021 silver badges24 bronze badges

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

Comments

Gonçalo · Accepted Answer · 2014-02-21 17:51:38Z

1

What annotation can i use to do this?

i've tried

@GeneratedValue(strategy=GenerationType.SEQUENCE , generator = <SEQUENCE_NAME>") without any success

edit:

it seams that the generator have to also be created

@SequenceGenerator(name="<GEN_NAME>", sequenceName="<SEQUENCE_NAME>")

edited Feb 21, 2014 at 17:51

answered Feb 21, 2014 at 16:39

Gonçalo

6486 silver badges17 bronze badges

1 Comment

g.annunziata Over a year ago

I think that first annotation must be with generator = "<GEN_NAME>" (NOT with sequence_name)

Collectives™ on Stack Overflow

org.hibernate.exception.SQLGrammarException: could not get next sequence value

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related