Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hibernate - SQLGrammarException : could not get next sequence value

 
sanker san
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I'm trying to use a sequence in the hibernate mapping. When I tried to insert a record into a table, it gave error while reading the value from sequence. The sequence exist in the database. The select query output by Hibernate is not correct. What am I doing wrong. The details of logs and mapping are given below:-

Logs:-
INFO: Echoing all SQL to stdout
Hibernate: select next value for slk_end_customer_id_seq from dual_slk_end_customer_id_seq
Error:-
exception occured..org.hibernate.exception.SQLGrammarException: could not get next sequence value
Mapping:-
<hibernate-mapping>
<class name="dao.Customer" table="SLK_END_CUSTOMER">
<id name="custid" column="END_CUSTOMER_ID">
<generator class="sequence">
<param name="sequence">slk_end_customer_id_seq</param>
</generator>
</id>

<property name="city" type="string" column="CITY"/>
</class>
</hibernate-mapping>

Thanks in advance
Sanker
 
sanker san
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It is resolved. I am using Oracle db and I had HSQLDialect instead of OracleDialect. I changed the following property and it worked.
Old
<property name="dialect">org.hibernate.dialect.HSQLDialect</property>
to New
<property name="dialect">org.hibernate.dialect.OracleDialect</property>

Thank you all
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic