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 | 11 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

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

    GitHub | 11 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 | 11 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 | 6 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 | 3 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

    Ebean/idIn Parameter not set

    Stack Overflow | 4 years ago | Janus Troelsen
    javax.persistence.PersistenceException: Query threw SQLException:Parameter "#1" is not set; SQL statement: select t0.virtuelle_adresse c0, t0.reale_adresse c1, t0.betr_nr c2, t0.bemerkung c3, t0.inbetriebnahme c4, t0.dekoder_typ_id c5, t0.model_tfz_typ_id c6, t0.eigentuemer_id c7 from tfz t0 where t0.virtuelle_adresse in (?) [90012-168] Bind values:[] Query was: select t0.virtuelle_adresse c0, t0.reale_adresse c1, t0.betr_nr c2, t0.bemerkung c3, t0.inbetriebnahme c4, t0.dekoder_typ_id c5, t0.model_tfz_typ_id c6, t0.eigentuemer_id c7 from tfz t0 where t0.virtuelle_adresse in (?)

  1. kjhdofjosvs 1 times, last 6 months 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