org.jooq.exception.DataAccessException: SQL [insert into groups (id, name, createdat, updatedat) values (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)), (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)), (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)), (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)), (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint))]; Cannot parse "TIMESTAMP" constant "1340289489"; SQL statement: insert into groups (id, name, createdat, updatedat) values (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)), (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)), (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)), (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)), (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)) -- (CAST(?1 AS BIGINT), CAST(?2 AS VARCHAR), CAST(?3 AS BIGINT), CAST(?4 AS BIGINT)) [22007-187]

Google Groups | Matthew Halder | 9 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

    db-seed issues

    Google Groups | 9 months ago | Matthew Halder
    org.jooq.exception.DataAccessException: SQL [insert into groups (id, name, createdat, updatedat) values (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)), (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)), (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)), (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)), (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint))]; Cannot parse "TIMESTAMP" constant "1340289489"; SQL statement: insert into groups (id, name, createdat, updatedat) values (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)), (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)), (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)), (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)), (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)) -- (CAST(?1 AS BIGINT), CAST(?2 AS VARCHAR), CAST(?3 AS BIGINT), CAST(?4 AS BIGINT)) [22007-187]
  2. 0

    h2 truncate may fail

    GitHub | 4 years ago | ben-manes
    org.jooq.exception.DataAccessException: SQL [truncate table file_metadata]; Cannot truncate """file_vault"".FILE_METADATA"; SQL statement: truncate table file_metadata [90106-167]
  3. 0

    Clock crashed

    GitHub | 2 years ago | phxql
    org.h2.jdbc.JdbcSQLException: Eindeutiger Index oder Primärschlüssel verletzt: "CONSTRAINT_INDEX_B ON PUBLIC.TECHNOLOGY(PLAYER_ID, TYPE) VALUES ( /* key:2 */ null, 1, null, '2d821735-a30f-49b1-b7b1-519a00630131')" Unique index or primary key violation: "CONSTRAINT_INDEX_B ON PUBLIC.TECHNOLOGY(PLAYER_ID, TYPE) VALUES ( /* key:2 */ null, 1, null, '2d821735-a30f-49b1-b7b1-519a00630131')"; SQL statement: insert into "PUBLIC"."TECHNOLOGY" ("ID", "TYPE", "PLAYER_ID", "LEVEL") values (cast(? as uuid), cast(? as int), cast(? as uuid), cast(? as int)) [23505-176]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Database deadlock

    GitHub | 2 years ago | phxql
    org.h2.jdbc.JdbcSQLException: Eine Verklemmung (Deadlock) ist aufgetreten. Die aktuelle Transaktion wurde rückgängig gemacht. Details: " Session #11 (user: ) on thread dw-89 - POST /v1/planet/8.4.2/ship-in-construction is waiting to lock PUBLIC.ROUND while locking PUBLIC.PLANET (exclusive). Session #12 (user: ) on thread pool-2-thread-1 is waiting to lock PUBLIC.PLANET while locking PUBLIC.ROUND (exclusive), PUBLIC.BUILDING (exclusive), PUBLIC.EVENT (exclusive)." Deadlock detected. The current transaction was rolled back. Details: " Session #11 (user: ) on thread dw-89 - POST /v1/planet/8.4.2/ship-in-construction is waiting to lock PUBLIC.ROUND while locking PUBLIC.PLANET (exclusive). Session #12 (user: ) on thread pool-2-thread-1 is waiting to lock PUBLIC.PLANET while locking PUBLIC.ROUND (exclusive), PUBLIC.BUILDING (exclusive), PUBLIC.EVENT (exclusive)."; SQL statement: insert into "PUBLIC"."EVENT" ("ID", "PLAYER_ID", "PLANET_ID", "TYPE", "ROUND", "FIGHT_ID") values (cast(? as uuid), cast(? as uuid), cast(? as uuid), cast(? as int), cast(? as bigint), cast(? as uuid)) [40001-176]
  6. 0

    Issue 307 - h2database - Null Pointer exception while executing a Select - Java SQL database - Google Project Hosting

    google.com | 2 years ago
    org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-136]

  1. Andreas Häber 1 times, last 2 months ago
  2. kjhdofjosvs 1 times, last 4 months ago
1 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

    1340289489

    at org.h2.util.DateTimeUtils.parseDateValue()
  2. H2 Database Engine
    JdbcPreparedStatement.execute
    1. org.h2.util.DateTimeUtils.parseDateValue(DateTimeUtils.java:275)
    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.table.Column.convert(Column.java:148)
    6. org.h2.command.dml.Insert.insertRows(Insert.java:143)
    7. org.h2.command.dml.Insert.update(Insert.java:114)
    8. org.h2.command.CommandContainer.update(CommandContainer.java:78)
    9. org.h2.command.Command.executeUpdate(Command.java:254)
    10. org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:198)
    10 frames
  3. jOOQ
    AbstractDelegatingQuery.execute
    1. org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:194)
    2. org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:410)
    3. org.jooq.impl.AbstractDMLQuery.execute(AbstractDMLQuery.java:276)
    4. org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:342)
    5. org.jooq.impl.AbstractDelegatingQuery.execute(AbstractDelegatingQuery.java:133)
    5 frames
  4. keywhiz.commands
    DbSeedCommand.run
    1. keywhiz.commands.DbSeedCommand.doImport(DbSeedCommand.java:88)
    2. keywhiz.commands.DbSeedCommand.run(DbSeedCommand.java:70)
    3. keywhiz.commands.DbSeedCommand.run(DbSeedCommand.java:50)
    3 frames
  5. Dropwizard
    Application.run
    1. io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:76)
    2. io.dropwizard.cli.Cli.run(Cli.java:70)
    3. io.dropwizard.Application.run(Application.java:73)
    3 frames
  6. keywhiz
    KeywhizService.main
    1. keywhiz.KeywhizService.main(KeywhizService.java:71)
    1 frame