net.sf.hibernate.exception.SQLGrammarException: Could not execute query

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Hibernate JIRA by Abhishek Khandelwal, 1 year ago
Could not execute query
via hibernate.org by Unknown author, 1 year ago
via xplanner by tvorup
, 1 year ago
Could not execute query
via GitHub by sgelabert-dgtic
, 1 year ago
Could not execute query
via Google Groups by Ben Ferguson, 6 months ago
via Google Groups by Jonathan, 6 months ago
Could not execute query
java.sql.SQLException: Column not found: LOWER1__1_.TOP in statement [select lower0_.id__ as id1_, lower0_.intprop as intprop2_, lower0_.other1 as other12_, lower0_.other3 as other32_, lower0_.foo as foo2_, lower0__1_.count_ as count_0_, lower0__1_.name as name0_, lower0__1_.address as address0_, lower0__1_.date_ as date_0_, lower0__1_.top as top0_ from leafsubclass lower0_ inner join rootclass lower0__1_ on lower0_.id__=lower0__1_.id1_, leafsubclass lower1_, rootclass top2_ where lower0__1_.id1_ is not null and top2_.id1_ is not null and ((lower(top2_.name)>'a' and lower0_.other3=lower1_.id__ and lower1__1_.top=top2_.id1_))]
at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source)
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:263)
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:236)
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:67)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:784)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554)
at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:69)
at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at net.sf.hibernate.impl.SessionImpl.convert(SessionImpl.java:4131)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1557)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1531)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1523)
at org.hibernate.test.MultiTableTest.testJoinOpenBug(MultiTableTest.java:64)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at org.hibernate.test.TestCase.runTest(TestCase.java:107)

Users with the same issue

You are the first who have seen this exception.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.