This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Object Relational Mapping and the fly likes Hibernate - SQLGrammarException : could not get next sequence value Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Hibernate - SQLGrammarException : could not get next sequence value" Watch "Hibernate - SQLGrammarException : could not get next sequence value" New topic
Author

Hibernate - SQLGrammarException : could not get next sequence value

sanker san
Ranch Hand

Joined: Dec 17, 2004
Posts: 56
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

Joined: Dec 17, 2004
Posts: 56
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
 
Consider Paul's rocket mass heater.
 
subject: Hibernate - SQLGrammarException : could not get next sequence value
 
Similar Threads
Fetch only one column using hibernate 3.0
junk values for the id property
hibernate primary key mapping - sequence
Hibernate: using oracle sequence
Hibernate generating queries with duplicate columns