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 | 8 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    db-seed issues

    Google Groups | 8 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

    Error marshalling or unmarshalling a user defined type

    GitHub | 2 years ago | oogifu
    org.jooq.exception.DataAccessException: SQL [select "SYS"."SYSCOLUMNS"."COLUMNNAME", "SYS"."SYSCOLUMNS"."COLUMNNUMBER", "SYS"."SYSCOLUMNS"."COLUMNDATATYPE", "SYS"."SYSCOLUMNS"."COLUMNDEFAULT", "SYS"."SYSCOLUMNS"."AUTOINCREMENTINC" from "SYS"."SYSCOLUMNS" where "SYS"."SYSCOLUMNS"."REFERENCEID" = '9c3e00f1-014d-56ee-d014-ffff86da659b' order by "SYS"."SYSCOLUMNS"."COLUMNNUMBER" asc]; Error marshalling or unmarshalling a user defined type: org.apache.derby.catalog.types.TypeDescriptorImpl; local class incompatible: stream classdesc serialVersionUID = -5485274209578709396, local class serialVersionUID = -3812847726962874375
  3. 0

    Connection is read-only. Queries leading to data modification are not allowed

    Google Groups | 1 year ago | Unknown author
    org.jooq.exception.DataAccessException: SQL [insert into `Database`.`MyTable` (`field_one`, `field_two`, `field_three`) values >> (?, ?, ?)]; Connection is read-only. Queries leading to data modification >> are not allowed
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Cannot bind NULL with JDBC Types.BOOLEAN in DB2

    GitHub | 3 years ago | lukaseder
    org.jooq.exception.DataAccessException: SQL [null]; [jcc][10271][10296][4.7.85] Unrecognized JDBC type: 16. ERRORCODE=-4228, SQLSTATE=null
  6. 0

    MySQL's unsigned types cannot be used in other dialects

    GitHub | 4 years ago | azell
    org.jooq.exception.DataAccessException: SQL [insert into "xxx"."sample" ("id", "name", "start_date", "end_date") values (cast(? as integerunsigned), cast(? as varchar), cast(? as date), cast(? as date))]; Unknown data type: "INTEGERUNSIGNED"; SQL statement: insert into "xxx"."sample" ("id", "name", "start_date", "end_date") values (cast(? as integerunsigned), cast(? as varchar), cast(? as date), cast(? as date)) [50004-171]

    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. 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]

      at org.jooq.impl.Utils.translate()
    2. jOOQ
      Utils.translate
      1. org.jooq.impl.Utils.translate(Utils.java:1645)
      1 frame