This week's book giveaway is in the OCPJP forum. We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line! See this thread for details.
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>
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
subject: Hibernate - SQLGrammarException : could not get next sequence value