net.sf.hibernate.exception.SQLGrammarException

Could not execute query

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web147

  • via Unknown by Abhishek Khandelwal,
  • via oreports by juniriola
    ,
  • via oreports by juniriola
    ,
  • Stack trace

    • net.sf.hibernate.exception.SQLGrammarException: Could not execute query 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) Caused by: 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.<init>(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.prepareStatement(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) ... 11 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    4 more bugmates