org.hibernate.exception.SQLGrammarException: could not prepare statement

GitHub | JWGmeligMeyling | 3 months ago
  1. 0

    GitHub comment 227#246139279

    GitHub | 3 months ago | JWGmeligMeyling
    org.hibernate.exception.SQLGrammarException: could not prepare statement
  2. 0

    CachedRowSet Support

    Google Groups | 3 years ago | da...@dandymadeproductions.com
    org.h2.jdbc.JdbcSQLException: Column "NAME" not found; SQL statement: INSERT INTO KEY_TABLES.PUBLIC."key_table5" (name, color, price) VALUES (?, ?, ?) [42122-175]
  3. 0

    H2Data cannot cope with periods in column names

    GitHub | 2 years ago | dpisarenko
    java.io.IOException: java.sql.SQLException: org.h2.jdbc.JdbcSQLException: Unbekannter Datentyp: "." Unknown data type: "."; SQL statement: CREATE TABLE table (user.urn VARCHAR PRIMARY KEY,domain.name CLOB,domain.key CLOB,domain.secret CLOB,domain.region CLOB,domain.bucket CLOB,domain.syslog CLOB) [50004-176]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JdbcSQLException: Table "FILECHECKS" not found

    GitHub | 2 years ago | eallik
    org.h2.jdbc.JdbcSQLException: Table "FILECHECKS" not found; SQL statement: select x2."id", x2."filename", x2."timestamp" from "FILECHECKS" x2 [42102-182]
  6. 0

    Login not working after a few hours of being running

    GitHub | 2 years ago | imduffy15
    org.h2.jdbc.JdbcSQLException: Table "T_USER" not found; SQL statement: select user0_.login as login1_5_0_, user0_.created_by as created_2_5_0_, user0_.created_date as created_3_5_0_, user0_.last_modified_by as last_mod4_5_0_, user0_.last_modified_date as last_mod5_5_0_, user0_.email as email6_5_0_, user0_.first_name as first_na7_5_0_, user0_.lang_key as lang_key8_5_0_, user0_.last_name as last_nam9_5_0_, user0_.password as passwor10_5_0_ from T_USER user0_ where user0_.login=? [42102-175]

  1. batwalrus76 1 times, last 2 days ago
  2. kjhdofjosvs 2 times, last 3 weeks ago
  3. Luka 4 times, last 2 months ago
  4. andyglick 1 times, last 10 months ago
17 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.h2.jdbc.JdbcSQLException

    Table "ISSUE227TEST$RECURSIVEENTITYCTE" not found; SQL statement: select children0_.parent_id as parent_i3_1_1_, children0_.id as id1_1_1_, children0_.id as id1_1_0_, children0_.name as name2_1_0_, children0_.parent_id as parent_i3_1_0_ from issue_227_recursive_entity children0_ where children0_.parent_id in (select issue227te1_.id from issue_227_recursive_entity issue227te0_ where issue227te0_.parent_id is not null UNION ALL select issue227te0_.id as col_0_0_, issue227te0_.name as col_1_0_, issue227te0_.parent_id as col_2_0_ from issue_227_recursive_entity issue227te0_ cross join Issue227Test$RecursiveEntityCte issue227te1_ where issue227te0_.id=issue227te1_.parent_id ) select issue227te0_.id as id1_0_0_, issue227te1_.id as id1_1_1_, issue227te0_.name as name2_0_0_, issue227te0_.parent_id as parent_i3_0_0_, issue227te1_.name as name2_1_1_, issue227te1_.parent_id as parent_i3_1_1_ from Issue227Test$RecursiveEntityCte issue227te0_ left outer join issue_227_recursive_entity issue227te1_ on issue227te0_.parent_id=issue227te1_.id) [42102-183]

    at org.h2.message.DbException.getJdbcSQLException()
  2. H2 Database Engine
    JdbcConnection.prepareStatement
    1. org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    2. org.h2.message.DbException.get(DbException.java:179)
    3. org.h2.message.DbException.get(DbException.java:155)
    4. org.h2.command.Parser.readTableOrView(Parser.java:5239)
    5. org.h2.command.Parser.readTableFilter(Parser.java:1227)
    6. org.h2.command.Parser.readJoin(Parser.java:1548)
    7. org.h2.command.Parser.parseJoinTableFilter(Parser.java:1872)
    8. org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1867)
    9. org.h2.command.Parser.parseSelectSimple(Parser.java:1975)
    10. org.h2.command.Parser.parseSelectSub(Parser.java:1860)
    11. org.h2.command.Parser.parseSelectUnionExtension(Parser.java:1696)
    12. org.h2.command.Parser.parseSelectUnion(Parser.java:1682)
    13. org.h2.command.Parser.parseSelect(Parser.java:1669)
    14. org.h2.command.Parser.readCondition(Parser.java:2113)
    15. org.h2.command.Parser.readAnd(Parser.java:2030)
    16. org.h2.command.Parser.readExpression(Parser.java:2022)
    17. org.h2.command.Parser.parseSelectSimple(Parser.java:1979)
    18. org.h2.command.Parser.parseSelectSub(Parser.java:1860)
    19. org.h2.command.Parser.parseSelectUnion(Parser.java:1681)
    20. org.h2.command.Parser.parseSelect(Parser.java:1669)
    21. org.h2.command.Parser.parsePrepared(Parser.java:433)
    22. org.h2.command.Parser.parse(Parser.java:305)
    23. org.h2.command.Parser.parse(Parser.java:277)
    24. org.h2.command.Parser.prepareCommand(Parser.java:242)
    25. org.h2.engine.Session.prepareLocal(Session.java:446)
    26. org.h2.engine.Session.prepareCommand(Session.java:388)
    27. org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1189)
    28. org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:72)
    29. org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:277)
    29 frames
  3. Hibernate
    Hibernate.initialize
    1. org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:159)
    2. org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:183)
    3. org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:157)
    4. org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1881)
    5. org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1858)
    6. org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838)
    7. org.hibernate.loader.Loader.doQuery(Loader.java:906)
    8. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348)
    9. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:318)
    10. org.hibernate.loader.Loader.loadCollectionSubselect(Loader.java:2329)
    11. org.hibernate.loader.collection.SubselectOneToManyLoader.initialize(SubselectOneToManyLoader.java:79)
    12. org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:674)
    13. org.hibernate.event.internal.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:86)
    14. org.hibernate.internal.SessionImpl.initializeCollection(SessionImpl.java:1810)
    15. org.hibernate.collection.internal.AbstractPersistentCollection.forceInitialization(AbstractPersistentCollection.java:696)
    16. org.hibernate.Hibernate.initialize(Hibernate.java:77)
    16 frames
  4. com.blazebit.persistence
    Issue227Test.testFetchModeSubselectOnCteQueryResult
    1. com.blazebit.persistence.testsuite.Issue227Test.testFetchModeSubselectOnCteQueryResult(Issue227Test.java:86)
    1 frame
  5. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:497)
    4 frames
  6. JUnit
    JUnitCore.run
    1. org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)
    2. org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
    3. org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)
    4. org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
    5. org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
    6. org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
    7. org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271)
    8. org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70)
    9. org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)
    10. org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
    11. org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
    12. org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
    13. org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
    14. org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
    15. org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
    16. org.junit.runners.ParentRunner.run(ParentRunner.java:309)
    17. org.junit.runner.JUnitCore.run(JUnitCore.java:160)
    17 frames
  7. IntelliJ junit4 module
    JUnit4IdeaTestRunner.startRunnerWithArgs
    1. com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69)
    1 frame
  8. IDEA
    JUnitStarter.main
    1. com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:234)
    2. com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:74)
    2 frames