org.hibernate.exception.GenericJDBCException: could not load an entity: [org.hibernate.test.legacy.Top#1]

Hibernate JIRA | Strong Liu | 7 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    testMultiTable(org.hibernate.test.legacy.MultiTableTest) testMultiTableGeneratedId(org.hibernate.test.legacy.MultiTableTest) ------------------------- 20:37:55,892 WARN JDBCExceptionReporter:100 - SQL Error: 2925, SQLState: 5000A 20:37:55,893 ERROR JDBCExceptionReporter:101 - SELECT: FOR UPDATE clause found in non-updatable SELECT statement. May not use set function, GROUP, HAVING, DISTINCT, UNION, ORDER or more than one variable in the FROM clause, at the outermost query level. 20:37:55,895 INFO DefaultLoadEventListener:160 - Error performing load command org.hibernate.exception.GenericJDBCException: could not load an entity: [org.hibernate.test.legacy.Top#1] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:132) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:120) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.loadEntity(Loader.java:1921) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:71) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:65) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3212) at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496) at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227) at org.hibernate.event.def.DefaultLoadEventListener.lockAndLoad(DefaultLoadEventListener.java:403) at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:155) at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1080) at org.hibernate.impl.SessionImpl.load(SessionImpl.java:1045) at org.hibernate.impl.SessionImpl.load(SessionImpl.java:1036) at org.hibernate.test.legacy.MultiTableTest.testMultiTable(MultiTableTest.java:343) 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 org.hibernate.junit.functional.FunctionalTestCase.runTest(FunctionalTestCase.java:125) at junit.framework.TestCase.runBare(TestCase.java:127) at org.hibernate.junit.UnitTestCase.runBare(UnitTestCase.java:63) 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 org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197) Caused by: com.ingres.gcf.util.SqlEx: SELECT: FOR UPDATE clause found in non-updatable SELECT statement. May not use set function, GROUP, HAVING, DISTINCT, UNION, ORDER or more than one variable in the FROM clause, at the outermost query level. at com.ingres.gcf.jdbc.DrvObj.readError(Unknown Source) at com.ingres.gcf.jdbc.JdbcStmt.readError(Unknown Source) at com.ingres.gcf.jdbc.DrvObj.readResults(Unknown Source) at com.ingres.gcf.jdbc.JdbcStmt.readResults(Unknown Source) at com.ingres.gcf.jdbc.JdbcStmt.readResults(Unknown Source) at com.ingres.gcf.jdbc.JdbcPrep.exec(Unknown Source) at com.ingres.gcf.jdbc.JdbcPrep.executeQuery(Unknown Source) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1832) at org.hibernate.loader.Loader.doQuery(Loader.java:719) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:271) at org.hibernate.loader.Loader.loadEntity(Loader.java:1907) ... 30 more

    Hibernate JIRA | 7 years ago | Strong Liu
    org.hibernate.exception.GenericJDBCException: could not load an entity: [org.hibernate.test.legacy.Top#1]
  2. 0

    testMultiTable(org.hibernate.test.legacy.MultiTableTest) testMultiTableGeneratedId(org.hibernate.test.legacy.MultiTableTest) ------------------------- 20:37:55,892 WARN JDBCExceptionReporter:100 - SQL Error: 2925, SQLState: 5000A 20:37:55,893 ERROR JDBCExceptionReporter:101 - SELECT: FOR UPDATE clause found in non-updatable SELECT statement. May not use set function, GROUP, HAVING, DISTINCT, UNION, ORDER or more than one variable in the FROM clause, at the outermost query level. 20:37:55,895 INFO DefaultLoadEventListener:160 - Error performing load command org.hibernate.exception.GenericJDBCException: could not load an entity: [org.hibernate.test.legacy.Top#1] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:132) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:120) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.loadEntity(Loader.java:1921) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:71) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:65) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3212) at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496) at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227) at org.hibernate.event.def.DefaultLoadEventListener.lockAndLoad(DefaultLoadEventListener.java:403) at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:155) at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1080) at org.hibernate.impl.SessionImpl.load(SessionImpl.java:1045) at org.hibernate.impl.SessionImpl.load(SessionImpl.java:1036) at org.hibernate.test.legacy.MultiTableTest.testMultiTable(MultiTableTest.java:343) 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 org.hibernate.junit.functional.FunctionalTestCase.runTest(FunctionalTestCase.java:125) at junit.framework.TestCase.runBare(TestCase.java:127) at org.hibernate.junit.UnitTestCase.runBare(UnitTestCase.java:63) 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 org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197) Caused by: com.ingres.gcf.util.SqlEx: SELECT: FOR UPDATE clause found in non-updatable SELECT statement. May not use set function, GROUP, HAVING, DISTINCT, UNION, ORDER or more than one variable in the FROM clause, at the outermost query level. at com.ingres.gcf.jdbc.DrvObj.readError(Unknown Source) at com.ingres.gcf.jdbc.JdbcStmt.readError(Unknown Source) at com.ingres.gcf.jdbc.DrvObj.readResults(Unknown Source) at com.ingres.gcf.jdbc.JdbcStmt.readResults(Unknown Source) at com.ingres.gcf.jdbc.JdbcStmt.readResults(Unknown Source) at com.ingres.gcf.jdbc.JdbcPrep.exec(Unknown Source) at com.ingres.gcf.jdbc.JdbcPrep.executeQuery(Unknown Source) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1832) at org.hibernate.loader.Loader.doQuery(Loader.java:719) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:271) at org.hibernate.loader.Loader.loadEntity(Loader.java:1907) ... 30 more

    Hibernate JIRA | 7 years ago | Strong Liu
    org.hibernate.exception.GenericJDBCException: could not load an entity: [org.hibernate.test.legacy.Top#1]

    Root Cause Analysis

    1. com.ingres.gcf.util.SqlEx

      SELECT: FOR UPDATE clause found in non-updatable SELECT statement. May not use set function, GROUP, HAVING, DISTINCT, UNION, ORDER or more than one variable in the FROM clause, at the outermost query level.

      at com.ingres.gcf.jdbc.DrvObj.readError()
    2. com.ingres.gcf
      JdbcPrep.executeQuery
      1. com.ingres.gcf.jdbc.DrvObj.readError(Unknown Source)
      2. com.ingres.gcf.jdbc.JdbcStmt.readError(Unknown Source)
      3. com.ingres.gcf.jdbc.DrvObj.readResults(Unknown Source)
      4. com.ingres.gcf.jdbc.JdbcStmt.readResults(Unknown Source)
      5. com.ingres.gcf.jdbc.JdbcStmt.readResults(Unknown Source)
      6. com.ingres.gcf.jdbc.JdbcPrep.exec(Unknown Source)
      7. com.ingres.gcf.jdbc.JdbcPrep.executeQuery(Unknown Source)
      7 frames
    3. Hibernate
      AbstractEntityPersister.load
      1. org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
      2. org.hibernate.loader.Loader.getResultSet(Loader.java:1832)
      3. org.hibernate.loader.Loader.doQuery(Loader.java:719)
      4. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:271)
      5. org.hibernate.loader.Loader.loadEntity(Loader.java:1907)
      6. org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:71)
      7. org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:65)
      8. org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3212)
      8 frames
    4. Hibernate
      SessionImpl.load
      1. org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)
      2. org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)
      3. org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)
      4. org.hibernate.event.def.DefaultLoadEventListener.lockAndLoad(DefaultLoadEventListener.java:403)
      5. org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:155)
      6. org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1080)
      7. org.hibernate.impl.SessionImpl.load(SessionImpl.java:1045)
      8. org.hibernate.impl.SessionImpl.load(SessionImpl.java:1036)
      8 frames
    5. org.hibernate.test
      MultiTableTest.testMultiTable
      1. org.hibernate.test.legacy.MultiTableTest.testMultiTable(MultiTableTest.java:343)
      1 frame
    6. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:585)
      4 frames
    7. JUnit
      TestCase.runTest
      1. junit.framework.TestCase.runTest(TestCase.java:154)
      1 frame
    8. org.hibernate.junit
      FunctionalTestCase.runTest
      1. org.hibernate.junit.functional.FunctionalTestCase.runTest(FunctionalTestCase.java:125)
      1 frame
    9. JUnit
      TestCase.runBare
      1. junit.framework.TestCase.runBare(TestCase.java:127)
      1 frame
    10. org.hibernate.junit
      UnitTestCase.runBare
      1. org.hibernate.junit.UnitTestCase.runBare(UnitTestCase.java:63)
      1 frame
    11. JUnit
      TestCase.run
      1. junit.framework.TestResult$1.protect(TestResult.java:106)
      2. junit.framework.TestResult.runProtected(TestResult.java:124)
      3. junit.framework.TestResult.run(TestResult.java:109)
      4. junit.framework.TestCase.run(TestCase.java:118)
      4 frames
    12. JUnit3 Runner
      RemoteTestRunner.main
      1. org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)
      2. org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
      3. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
      4. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
      5. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
      6. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
      6 frames