org.hibernate.exception.SQLGrammarException

could not execute query

Solutions on the web1402

  • via Coderanch by Emili Calonge, 7 months ago
    could not execute query
  • could not execute query
  • could not execute query
  • Stack trace

    • org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2147) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028) at org.hibernate.loader.Loader.list(Loader.java:2023) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at ru.nbch.quality.logic.ReportProcessor.main(ReportProcessor.java:66) 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 com.intellij.rt.execution.application.AppMain.main(AppMain.java:90) Caused by: com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: 10;select top ;. at com.ibm.db2.jcc.b.id.e(id.java:1640) at com.ibm.db2.jcc.b.id.a(id.java:1229) at com.ibm.db2.jcc.c.fb.h(fb.java:149) at com.ibm.db2.jcc.c.fb.a(fb.java:43) at com.ibm.db2.jcc.c.s.a(s.java:30) at com.ibm.db2.jcc.c.wb.g(wb.java:152) at com.ibm.db2.jcc.b.id.n(id.java:1209) at com.ibm.db2.jcc.b.jd.eb(jd.java:1779) at com.ibm.db2.jcc.b.jd.a(jd.java:2232) at com.ibm.db2.jcc.b.jd.V(jd.java:505) at com.ibm.db2.jcc.b.jd.executeQuery(jd.java:488) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1668) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2144) ... 13 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

    You are the first who have seen this exception. Write a tip to help other users and build your expert profile.