Hibernate Community • View topic - SQLGrammarException error when building the query string

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

SQLGrammarException error when building the query string

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

aksnafu

Post subject: SQLGrammarException error when building the query string

Posted: Tue Aug 26, 2008 7:22 pm

Newbie

Joined: Tue Aug 26, 2008 5:53 pm
Posts: 2

The following SQL create this error "SQL Error: -201, SQLState: 42000"

select echomessag0_.id as id0_0_, echomessag0_.msg as msg0_0_ from pfd.dba.echo_message echomessag0_ where echomessag0_.id=?

This was a manual change that was run in the HQL editor and worked. the only change I made was replacing a "." with ":" in the string "pfd.dba.echo_message" to "pfd:dba.echo_message. below is the corrected string that worked

select echomessag0_.id as id0_0_, echomessag0_.msg as msg0_0_ from pfd:dba.echo_message echomessag0_ where echomessag0_.id=?

can you tell me where to correct hibernate to build the string correctly.

I just started to use hibernate and dont know how to provide some of the following information.

Hibernate version: 3.2

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using: Informix 10

The generated SQL (show_sql=true):

took it from the debug field sql

select echomessag0_.id as id0_0_, echomessag0_.msg as msg0_0_ from pfd.dba.echo_message echomessag0_ where echomessag0_.id=?

Debug level Hibernate log excerpt:

13:59:27,910 WARN JDBCExceptionReporter:77 - SQL Error: -201, SQLState: 42000
13:59:27,910 ERROR JDBCExceptionReporter:78 - A syntax error has occurred.
13:59:27,910 WARN JDBCExceptionReporter:54 - SQL Warning: 0, SQLState: 01I01
13:59:27,910 WARN JDBCExceptionReporter:55 - Database has transactions
13:59:27,910 WARN JDBCExceptionReporter:54 - SQL Warning: 0, SQLState: 01I04
13:59:27,910 WARN JDBCExceptionReporter:55 - Database selected
13:59:27,910 ERROR EchoMessageDAO:56 - get failed
org.hibernate.exception.SQLGrammarException: could not load an entity: [com.genuitec.hibernate.EchoMessage#1]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1874)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3044)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)
at com.genuitec.hibernate.EchoMessageDAO.findById(EchoMessageDAO.java:52)
at com.genuitec.hibernate.HibernateReadTest.main(HibernateReadTest.java:13)
Caused by: java.sql.SQLException: A syntax error has occurred.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:355)
at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3086)
at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3396)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2259)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2179)
at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1082)
at com.informix.jdbc.IfxResultSet.executePrepare(IfxResultSet.java:182)
at com.informix.jdbc.IfxPreparedStatement.setupExecutePrepare(IfxPreparedStatement.java:197)
at com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java:175)
at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:1907)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:423)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
at org.hibernate.loader.Loader.doQuery(Loader.java:673)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1860)
... 12 more
Entity retrieval failed.
org.hibernate.exception.SQLGrammarException: could not load an entity: [com.genuitec.hibernate.EchoMessage#1]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1874)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3044)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)
at com.genuitec.hibernate.EchoMessageDAO.findById(EchoMessageDAO.java:52)
at com.genuitec.hibernate.HibernateReadTest.main(HibernateReadTest.java:13)
Caused by: java.sql.SQLException: A syntax error has occurred.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:355)
at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3086)
at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3396)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2259)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2179)
at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1082)
at com.informix.jdbc.IfxResultSet.executePrepare(IfxResultSet.java:182)
at com.informix.jdbc.IfxPreparedStatement.setupExecutePrepare(IfxPreparedStatement.java:197)
at com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java:175)
at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:1907)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:423)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
at org.hibernate.loader.Loader.doQuery(Loader.java:673)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1860)
... 12 more

Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html

Top

aksnafu

Post subject: problem resolved

Posted: Thu Aug 28, 2008 9:14 pm