org.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 William F. DeMoss II, 1 year ago
could not execute query
via Hibernate JIRA by William F. DeMoss II, 1 year ago
could not execute query
via Hibernate JIRA by Hector Suarez Barenca, 1 year ago
could not execute query
via Hibernate JIRA by Sverker Abrahamsson, 1 year ago
could not execute query
via Hibernate JIRA by Sverker Abrahamsson, 1 year ago
could not execute query
via Hibernate JIRA by Hector Suarez Barenca, 1 year ago
could not execute query
java.sql.SQLException: Column not found: BB0_1_.FIELD3 in statement [select bb0_.BB as id, bb0_2_.commonProperty as commonPr2_0_, bb0_1_.field0 as field2_1_, bb0_1_.field1 as field3_1_, bb0_.field2 as field2_2_, bb0_.field3 as field3_2_ from BB bb0_ inner join BA bb0_1_ on bb0_.BB=bb0_1_.A inner join A bb0_2_ on bb0_.BB=bb0_2_.id where bb0_1_.field3='value5']
at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:383)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:321)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:86)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1125)
at org.hibernate.loader.Loader.doQuery(Loader.java:369)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:210)
at org.hibernate.loader.Loader.doList(Loader.java:1557)
at org.hibernate.loader.Loader.list(Loader.java:1540)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:791)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at eg.entitynames.InheritedDynamicComponentBugTest.testInherentenceFromDynamicParent(InheritedDynamicComponentBugTest.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 java.lang.reflect.Method.invoke(Method.java:585)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:474)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:342)

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.