java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist while using default Generation Strategy in Hibernate with Oracle

Question

I am trying to save below entity in Oracle database.

import javax.persistence.Entity;
import javax.persistence.Id;


@Entity
public class Book {

@Id
@GeneratedValue
private int id;

private String name;

public String getName() {
    return name;
}

public void setName(String name) {
    this.name = name;
}
}



Book book1 = new Book();
book1.setName("Sample");
session.save(book1);

But Hibernate is generating below exception stack trace.

Caused by: java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)

Also I am seeing Hibernate is trying to run below query to fetch value from sequence, which is when the exception is getting generated.

Hibernate: select hibernate_sequence.nextval from dual

Table Schema:

CREATE TABLE BOOK(
    ID INTEGER,
    NAME VARCHAR2(50)
);

ALTER TABLE BOOK ADD PRIMARY KEY(ID);

Does the sequence exist? Which user are you using to run your query? Is it the same than the sequence? If not, have you created synonyms, given grants, ... ? — Aleksej
– Aleksej, Commented Jun 6, 2017 at 9:01
Can you add @GeneratedValue(strategy = GenerationType.IDENTITY) to your id member variable and try? Also, you should declare member variables in Entity class like private Integer id; rather private int id;. — harshavmb
– harshavmb, Commented Jun 6, 2017 at 9:07
Can you tell us to which table Book is mapped to ? Also, if you could post the table schema it would be helpful — harshavmb
– harshavmb, Commented Jun 6, 2017 at 9:14
The problem is clear, you aren't setting id so hibernate is complaining. — harshavmb
– harshavmb, Commented Jun 6, 2017 at 9:17

Aakash · Accepted Answer · 2017-06-10 10:58:33Z

1

I was able to run this program on another machine which I had been using for Hibernate programs for quite a few time. But the program failed to run on a new machine and the reason is apparent in the stack trace :

Hibernate: select hibernate_sequence.nextval from dual.

Hibernate is not able to find out the default hibernate_sequence in database. So instead of creating the sequence manually I added the property

<property name="hibernate.hbm2ddl.auto">create</property>

in hibernate.cfg.xml and the next time I ran the program, Hibernate created this sequence and added a new row in Book table.

answered Jun 10, 2017 at 10:58

Aakash

1,0293 gold badges16 silver badges29 bronze badges

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

1 Comment

Anu Over a year ago

Note: As @Sergio mentioned, Adding this line: <property name="hibernate.hbm2ddl.auto">create</property> to your Hibernate configuration will drop all your tables and recreate them empty. Please use this carefully

Sergio Millich · Accepted Answer · 2021-04-23 07:41:41Z

0

Adding this line: <property name="hibernate.hbm2ddl.auto">create</property> to your Hibernate configuration will drop all your tables and recreate them empty.

answered Apr 23, 2021 at 7:41

Sergio Millich

1

Collectives™ on Stack Overflow

java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist while using default Generation Strategy in Hibernate with Oracle

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related