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 = ?

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Google Groups by Krzysztof Chudy, 1 year ago
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
via GitHub by rbygrave
, 1 year ago
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
via Google Groups by Saulius, 4 months ago
Query threw SQLException:ERROR: syntax error at or near "t0" Bind values:[1867776] Query was: select t0.dtype as c0, t0.id as c1, t0.username as c2, t0.password as c3, t0.accumulated_discount as c4, t0.registered as c5, t0.last_login as c6, t0.locale as c7, t0.balance as c8 from users t0 where t0. and t0.id = ?
via GitHub by 0xbaadf00d
, 10 months ago
Query threw SQLException:ERROR: could not identify an equality operator for type json Position : 48 Bind values:[SCHEDULED,PAYPAL] Query was: select distinct t0.id c0, t0.uid c1, t1.id c2, t1.paypal_settings c3 from contract t0 join
via GitHub by rbygrave
, 1 year ago
Query threw SQLException:Incorrect syntax near the keyword &apos;distinct&apos;. Bind values:[0] Query was: select top 3 distinct t0.id c0, t0.status c1, t0.order_date c2, t0.ship_date c3, t1.name c4, t0.cretime c5, t0.updtime c6, t0.kcustomer_id
via Google Groups by Saulius, 1 year ago
Query threw SQLException:An I/ O error occured while sending to the backend. Bind values:[<... skipped, basically just lots of integer ids of type long ...>] Query was: select t0.* from hotel t0 where t0.city in (<... skipped, basically just lots of question marks ...> )
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 = ?
at org.h2.util.DateTimeUtils.parseDateValue(DateTimeUtils.java:303)
at org.h2.value.ValueTimestamp.parseTry(ValueTimestamp.java:140)
at org.h2.value.ValueTimestamp.parse(ValueTimestamp.java:120)
at org.h2.value.Value.convertTo(Value.java:862)
at org.h2.expression.Comparison.getValue(Comparison.java:256)
at org.h2.expression.ConditionAndOr.getValue(ConditionAndOr.java:93)
at org.h2.expression.Expression.getBooleanValue(Expression.java:178)
at org.h2.command.dml.Select.queryFlat(Select.java:533)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:643)
at org.h2.command.dml.Query.query(Query.java:322)
at org.h2.command.dml.Query.query(Query.java:290)
at org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java:194)
at org.h2.command.dml.SelectUnion.query(SelectUnion.java:425)
at org.h2.command.dml.Query.query(Query.java:290)
at org.h2.index.ViewIndex.find(ViewIndex.java:272)
at org.h2.index.ViewIndex.find(ViewIndex.java:177)
at org.h2.index.BaseIndex.find(BaseIndex.java:127)
at org.h2.index.IndexCursor.find(IndexCursor.java:159)
at org.h2.table.TableFilter.next(TableFilter.java:329)
at org.h2.command.dml.Select.queryFlat(Select.java:531)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:643)
at org.h2.command.dml.Query.query(Query.java:322)
at org.h2.command.dml.Query.query(Query.java:290)
at org.h2.command.dml.Query.query(Query.java:36)
at org.h2.command.CommandContainer.query(CommandContainer.java:90)
at org.h2.command.Command.executeQuery(Command.java:196)
at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:108)
at org.avaje.datasource.pool.ExtendedPreparedStatement.executeQuery(ExtendedPreparedStatement.java:121)
at com.avaje.ebeaninternal.server.query.CQuery.prepareBindExecuteQueryWithOption(CQuery.java:342)
at com.avaje.ebeaninternal.server.query.CQuery.prepareBindExecuteQuery(CQuery.java:295)
at com.avaje.ebeaninternal.server.query.CQueryEngine.find(CQueryEngine.java:354)
at com.avaje.ebeaninternal.server.query.DefaultOrmQueryEngine.findId(DefaultOrmQueryEngine.java:135)
at com.avaje.ebeaninternal.server.core.OrmQueryRequest.findId(OrmQueryRequest.java:300)
at com.avaje.ebeaninternal.server.core.DefaultServer.findId(DefaultServer.java:1037)
at com.avaje.ebeaninternal.server.core.DefaultServer.findUnique(DefaultServer.java:1051)
at com.avaje.tests.history.TestHistoryInsert.test(TestHistoryInsert.java:74)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:115)
at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:102)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:350)

Users with the same issue

Once, 7 months ago

Know the solutions? Share your knowledge to help other developers to debug faster.