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

Samebug tips

  1. ,
    Expert tip

    Check if you're not creating unused SQL entities, as it might cause this exception.

Solutions on the web

via Google Groups by Mike Goodwin, 1 year ago
Cannot parse "DATE" constant ; SQL statement: ... FROM (SELECT NULL) WHERE (true) LIMIT 25000 [22007-193]
via Google Groups by Navjot Singh, 2 years ago
Timeout trying to lock table "TRACKED_ASSET100"; SQL statement: insert into TRACKED_ASSET100 ( ......) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [50200-157]
via Stack Overflow by manish rajput
, 1 year ago
General error: "java.lang.ArrayIndexOutOfBoundsException"; SQL statement: delete from FINACLECOREAPPNEWPRREPPAIR1492520606640_SCANNEDLIST where file_path=? and lastModifiedTime=? [50000-171]
via Stack Overflow by sonoerin
, 2 years ago
Unique index or primary key violation: "PRIMARY_KEY_4 ON PUBLIC.USERS(USERNAME)"; SQL statement: INSERT INTO users (username, password, enabled) VALUES ('admin', '$2a$10$GVPAMYRozI08Mcll5too6.Q4M2jTO0iJVoiaVDv9pMxRqTpxNj9vO', TRUE) [23505-172]
org.h2.jdbc.JdbcSQLException: Cannot parse "DATE" constant ; SQL statement: ...FROM (SELECT NULL)WHERE (true)LIMIT 25000 [22007-193] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:168) at org.h2.value.ValueDate.parse(ValueDate.java:81) at org.h2.value.Value.convertTo(Value.java:928) at org.h2.expression.Function.getSimpleValue(Function.java:1084) at org.h2.expression.Function.getValueWithArgs(Function.java:1195) at org.h2.expression.Function.getValue(Function.java:590) at org.h2.expression.ExpressionList.getValue(ExpressionList.java:32) at org.h2.expression.JavaAggregate.updateAggregate(JavaAggregate.java:192) at org.h2.expression.Function.updateAggregate(Function.java:2663) at org.h2.expression.Alias.updateAggregate(Alias.java:87) at org.h2.command.dml.Select.queryGroup(Select.java:365) at org.h2.command.dml.Select.queryWithoutCache(Select.java:650) at org.h2.command.dml.Query.query(Query.java:341) at org.h2.command.dml.Query.query(Query.java:309) at org.h2.expression.Subquery.getValue(Subquery.java:36) at org.h2.expression.ExpressionList.getValue(ExpressionList.java:32) at org.h2.expression.Alias.getValue(Alias.java:36) at org.h2.command.dml.Select.queryFlat(Select.java:549) at org.h2.command.dml.Select.queryWithoutCache(Select.java:655) at org.h2.command.dml.Query.query(Query.java:341) at org.h2.command.dml.Query.query(Query.java:309) at org.h2.command.dml.Query.query(Query.java:1) at org.h2.command.CommandContainer.query(CommandContainer.java:112) at org.h2.command.Command.executeQuery(Command.java:201) at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:110)