hibernate exception SQLGrammarException could not fetch initial value for increment

[V Patil]

org.hibernate.exception.SQLGrammarException: could not fetch initial value for increment generator
this excepetion is shown in console
cannot increment the generator id.
I am getting this error when i am using Hibernate 3.0 and its working fine with Hibernate 2.0.
Please Help.

[Talha Kabakus]

same problem occurs to me too.. thanks for topic..
I hope that someone can help us.. I think we should do some changes in hbm.xml file.

[Shinelin Samuel]

It could be a syntax problem with the SQL query which is built during the runtime.

[Talha Kabakus]

Shinelin Samuel wrote:It could be a syntax problem with the SQL query which is built during the runtime.

first, thank you for your reply.. do you know how can we correct it? I use HQL's session.save(Object o) method.

[Shinelin Samuel]

Can you please send the full error trace and also the hbm.file

[Talha Kabakus]

Shinelin Samuel wrote:Can you please send the full error trace and also the hbm.file

of course, thanks for your interest.

hbm.xml file:

 <?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Mar 1, 2010 1:57:40 AM by Hibernate Tools 3.2.4.GA -->
<hibernate-mapping>
    <class name="model.Kisi" table="KISI">
        <id name="id" type="big_decimal">
            <column name="ID" precision="22" scale="0" />
            <generator class="increment" />	            
        </id>
        <property name="kisiId" type="big_decimal">
            <column name="KISI_ID" precision="22" scale="0" />
        </property>
        <property name="kisiAd" type="string">
            <column name="KISI_AD" length="50" />
        </property>
        <property name="kisiSoyad" type="string">
            <column name="KISI_SOYAD" length="50" />
        </property>
        <property name="kisiYas" type="big_decimal">
            <column name="KISI_YAS" precision="22" scale="0" />
        </property>
        <property name="kisiCinsiyet" type="string">
            <column name="KISI_CINSIYET" length="20" />
        </property>
        <property name="kisiMeslek" type="string">
            <column name="KISI_MESLEK" length="50" />
        </property>
    </class>
</hibernate-mapping>   

Full Error Trace:

 org.hibernate.exception.SQLGrammarException: could not fetch initial value
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:59)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at org.hibernate.id.IncrementGenerator.getNext(IncrementGenerator.java:107)
	at org.hibernate.id.IncrementGenerator.generate(IncrementGenerator.java:45)
	at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:85)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:184)
	at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:173)
	at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:69)
	at org.hibernate.impl.SessionImpl.save(SessionImpl.java:481)
	at org.hibernate.impl.SessionImpl.save(SessionImpl.java:476)
	at dao.KisiHelper.addKisi(KisiHelper.java:18)
	at servlets.AddKisi.doPost(AddKisi.java:61)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
	at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: ORA-00933: SQL command not properly ended

	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
	at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503)
	at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:965)
	at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1051)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984)
	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3026)
	at org.hibernate.id.IncrementGenerator.getNext(IncrementGenerator.java:89)
	... 25 more   

[Shinelin Samuel]

Caused by: java.sql.SQLException: ORA-00933: SQL command not properly ended

Seems like the SQL statement formed using generator increment class, has the issue,.

Have you turned on show-sql parameter in your hibernate config file, In such case I think it will log the SQL statement in your console.

Regards,
Shinelin

[Talha Kabakus]

Shinelin Samuel wrote:

Caused by: java.sql.SQLException: ORA-00933: SQL command not properly ended

Seems like the SQL statement formed using generator increment class, has the issue,.

Have you turned on show-sql parameter in your hibernate config file, In such case I think it will log the SQL statement in your console.

Regards,
Shinelin

OK, I added 'show-sql' parameter; but it gives exactly same exception report..

[Wolf Lee]

I got the same problem. From google I found this topic, but without solution.
but ,but finally
I solved it by removing the "username" and "password" in the config file of hibernate(hibernate.cfg.xml)
And I changed the generator type from "increment" to "identity".(My id type is "integer", not big-decimal, my db is derby)
this is my case, I think it may be helpful, so....
Not good English, sorry