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 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_, as foo2_, lower0__1_.count_ as count_0_, as name0_, lower0__1_.address as address0_, lower0__1_.date_ as date_0_, 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(>'a' and lower0_.other3=lower1_.id__ and]
at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source)
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(
at net.sf.hibernate.loader.Loader.prepareQueryStatement(
at net.sf.hibernate.loader.Loader.doQuery(
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(
at net.sf.hibernate.loader.Loader.doList(
at net.sf.hibernate.loader.Loader.list(
at net.sf.hibernate.hql.QueryTranslator.list(
at net.sf.hibernate.impl.SessionImpl.find(
at net.sf.hibernate.exception.ErrorCodeConverter.convert(
at net.sf.hibernate.exception.JDBCExceptionHelper.convert(
at net.sf.hibernate.impl.SessionImpl.convert(
at net.sf.hibernate.impl.SessionImpl.find(
at net.sf.hibernate.impl.SessionImpl.find(
at net.sf.hibernate.impl.SessionImpl.find(
at org.hibernate.test.MultiTableTest.testJoinOpenBug(
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
at org.hibernate.test.TestCase.runTest(

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.