javax.persistence.PersistenceException: Query threw SQLException:Nie można odczytać "TIMESTAMP" jako "1" Cannot parse "TIMESTAMP" constant "1"; SQL statement: select t0.id c0, t0.inactive c1, t0.name c2, t0.email c3, t0.version c4, t0.when_created c5, t0.when_modified c6, t0.group_id c7 from c_user_with_history t0 where ( t0.sys_period_start <= ? and (t0.sys_period_end is null or t0.sys_period_end > ?)) and t0.id = ? [22007-189] Bind values:[1] Query was: select t0.id c0, t0.inactive c1, t0.name c2, t0.email c3, t0.version c4, t0.when_created c5, t0.when_modified c6, t0.group_id c7 from c_user_with_history t0 where ( t0.sys_period_start <= ? and (t0.sys_period_end is null or t0.sys_period_end > ?)) and t0.id = ?

Google Groups | Krzysztof Chudy | 5 months ago
  1. 0

    @History "as of" query errors when executed a second time - invalid bind parameter

    GitHub | 5 months ago | rbygrave
    javax.persistence.PersistenceException: Query threw SQLException:Nie można odczytać "TIMESTAMP" jako "1" Cannot parse "TIMESTAMP" constant "1"; SQL statement: select t0.id c0, t0.inactive c1, t0.name c2, t0.email c3, t0.version c4, t0.when_created c5, t0.when_modified c6, t0.group_id c7 from c_user_with_history t0 where (t0.sys_period_start <= ? and (t0.sys_period_end is null or t0.sys_period_end > ?)) and t0.id = ? [22007-189] Bind values:[1] Query was: select t0.id c0, t0.inactive c1, t0.name c2, t0.email c3, t0.version c4, t0.when_created c5, t0.when_modified c6, t0.group_id c7 from c_user_with_history t0 where (t0.sys_period_start <= ? and (t0.sys_period_end is null or t0.sys_period_end > ?)) and t0.id = ?
  2. 0

    Ebean History asOf(timestamp) error when called twice in postgresql

    Google Groups | 5 months ago | Krzysztof Chudy
    javax.persistence.PersistenceException: Query threw SQLException:Nie można odczytać "TIMESTAMP" jako "1" Cannot parse "TIMESTAMP" constant "1"; SQL statement: select t0.id c0, t0.inactive c1, t0.name c2, t0.email c3, t0.version c4, t0.when_created c5, t0.when_modified c6, t0.group_id c7 from c_user_with_history t0 where ( t0.sys_period_start <= ? and (t0.sys_period_end is null or t0.sys_period_end > ?)) and t0.id = ? [22007-189] Bind values:[1] Query was: select t0.id c0, t0.inactive c1, t0.name c2, t0.email c3, t0.version c4, t0.when_created c5, t0.when_modified c6, t0.group_id c7 from c_user_with_history t0 where ( t0.sys_period_start <= ? and (t0.sys_period_end is null or t0.sys_period_end > ?)) and t0.id = ?
  3. 0

    H2 Oracle decode function

    Stack Overflow | 5 years ago | SvRekaa
    org.h2.jdbc.JdbcSQLException: Hexadecimal string with odd number of characters: "6.0"; SQL statement: select 6.0 - decode(1.0,2.0,3.0,4.0) from dual ; [90003-157]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Failover @Type for h2?

    Stack Overflow | 2 years ago | xenoterracide
    org.h2.jdbc.JdbcSQLException: Hexadecimal string contains non-hex character: "aced0005-7372-000e-74c2-aa3c957d4f00"; SQL statement: select character0_.task_id as task_id1_0_0_, character0_.name as name2_0_0_ from characters character0_ where character0_.task_id=? [90004-176]
  6. 0

    Strange error when using /p group create

    GitHub | 4 years ago | HaoSs07
    org.h2.jdbc.JdbcSQLException: Parameter "#1" is not set; SQ statement: SELECT groups.groupName, groups.priority, groups.prefix, groups.suffix, groups.parent FROM groupConnectors INNER JOIN groups ON groupConnectors.groupID=groups.groupID WHERE groupConnectors.playerID=? AND groupConnectors.zoneID=? [90012-170

  1. kjhdofjosvs 1 times, last 3 weeks ago
6 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. java.lang.IllegalArgumentException

    1

    at org.h2.util.DateTimeUtils.parseDateValue()
  2. H2 Database Engine
    JdbcPreparedStatement.executeQuery
    1. org.h2.util.DateTimeUtils.parseDateValue(DateTimeUtils.java:303)
    2. org.h2.value.ValueTimestamp.parseTry(ValueTimestamp.java:140)
    3. org.h2.value.ValueTimestamp.parse(ValueTimestamp.java:120)
    4. org.h2.value.Value.convertTo(Value.java:862)
    5. org.h2.expression.Comparison.getValue(Comparison.java:256)
    6. org.h2.expression.ConditionAndOr.getValue(ConditionAndOr.java:93)
    7. org.h2.expression.Expression.getBooleanValue(Expression.java:178)
    8. org.h2.command.dml.Select.queryFlat(Select.java:533)
    9. org.h2.command.dml.Select.queryWithoutCache(Select.java:643)
    10. org.h2.command.dml.Query.query(Query.java:322)
    11. org.h2.command.dml.Query.query(Query.java:290)
    12. org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java:194)
    13. org.h2.command.dml.SelectUnion.query(SelectUnion.java:425)
    14. org.h2.command.dml.Query.query(Query.java:290)
    15. org.h2.index.ViewIndex.find(ViewIndex.java:272)
    16. org.h2.index.ViewIndex.find(ViewIndex.java:177)
    17. org.h2.index.BaseIndex.find(BaseIndex.java:127)
    18. org.h2.index.IndexCursor.find(IndexCursor.java:159)
    19. org.h2.table.TableFilter.next(TableFilter.java:329)
    20. org.h2.command.dml.Select.queryFlat(Select.java:531)
    21. org.h2.command.dml.Select.queryWithoutCache(Select.java:643)
    22. org.h2.command.dml.Query.query(Query.java:322)
    23. org.h2.command.dml.Query.query(Query.java:290)
    24. org.h2.command.dml.Query.query(Query.java:36)
    25. org.h2.command.CommandContainer.query(CommandContainer.java:90)
    26. org.h2.command.Command.executeQuery(Command.java:196)
    27. org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:108)
    27 frames
  3. org.avaje.datasource
    ExtendedPreparedStatement.executeQuery
    1. org.avaje.datasource.pool.ExtendedPreparedStatement.executeQuery(ExtendedPreparedStatement.java:121)
    1 frame
  4. avaje-ebeanorm
    DefaultOrmQuery.findUnique
    1. com.avaje.ebeaninternal.server.query.CQuery.prepareBindExecuteQueryWithOption(CQuery.java:342)
    2. com.avaje.ebeaninternal.server.query.CQuery.prepareBindExecuteQuery(CQuery.java:295)
    3. com.avaje.ebeaninternal.server.query.CQueryEngine.find(CQueryEngine.java:354)
    4. com.avaje.ebeaninternal.server.query.DefaultOrmQueryEngine.findId(DefaultOrmQueryEngine.java:135)
    5. com.avaje.ebeaninternal.server.core.OrmQueryRequest.findId(OrmQueryRequest.java:300)
    6. com.avaje.ebeaninternal.server.core.DefaultServer.findId(DefaultServer.java:1037)
    7. com.avaje.ebeaninternal.server.core.DefaultServer.findUnique(DefaultServer.java:1051)
    8. com.avaje.ebeaninternal.server.querydefn.DefaultOrmQuery.findUnique(DefaultOrmQuery.java:1090)
    8 frames
  5. com.avaje.tests
    TestHistoryInsert.test
    1. com.avaje.tests.history.TestHistoryInsert.test(TestHistoryInsert.java:74)
    1 frame
  6. 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:498)
    4 frames
  7. JUnit
    ParentRunner.run
    1. org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
    2. org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
    3. org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
    4. org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
    5. org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
    6. org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
    7. org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
    8. org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
    9. org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
    10. org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
    11. org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
    12. org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
    13. org.junit.runners.ParentRunner.run(ParentRunner.java:363)
    13 frames
  8. JUnit4 Provider
    JUnit4TestSet.execute
    1. org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:59)
    1 frame
  9. SureFire
    Surefire.run
    1. org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:115)
    2. org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:102)
    3. org.apache.maven.surefire.Surefire.run(Surefire.java:180)
    3 frames
  10. 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:498)
    4 frames
  11. SureFire
    SurefireBooter.main
    1. org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:350)
    2. org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:1021)
    2 frames