org.jooq.exception.DataAccessException: SQL [update CLIENTS set CLIENTS.LASTSEEN = case when CLIENTS.LASTSEEN is null then cast(? as bigint) else greatest(CLIENTS.LASTSEEN, cast(? as timestamp)) end where CLIENTS.ID = cast(? as int)]; Cannot parse "TIMESTAMP" constant "1475185281"; SQL statement: update CLIENTS set CLIENTS.LASTSEEN = case when CLIENTS.LASTSEEN is null then cast(? as bigint) else greatest(CLIENTS.LASTSEEN, cast(? as timestamp)) end where CLIENTS.ID = cast(? as int) [22007-187]

GitHub | csstaub | 2 months ago
  1. 0

    GitHub comment 270#250614346

    GitHub | 2 months ago | csstaub
    org.jooq.exception.DataAccessException: SQL [update CLIENTS set CLIENTS.LASTSEEN = case when CLIENTS.LASTSEEN is null then cast(? as bigint) else greatest(CLIENTS.LASTSEEN, cast(? as timestamp)) end where CLIENTS.ID = cast(? as int)]; Cannot parse "TIMESTAMP" constant "1475185281"; SQL statement: update CLIENTS set CLIENTS.LASTSEEN = case when CLIENTS.LASTSEEN is null then cast(? as bigint) else greatest(CLIENTS.LASTSEEN, cast(? as timestamp)) end where CLIENTS.ID = cast(? as int) [22007-187]
  2. 0

    db-seed issues

    Google Groups | 3 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]
  3. 0

    db-seed issues

    Google Groups | 3 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] at org.jooq.impl.Utils.translate(Utils.java:1645) at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:661)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    GitHub comment 193#45418501

    GitHub | 3 years ago | shilad
    org.jooq.exception.DataAccessException: SQL [select count( *) from "PUBLIC"."LOCAL_PAGE" where ("PUBLIC"."LOCAL_PAGE"."LANG_ID" in (cast(? as smallint)) and "PUBLIC"."LOCAL_PAGE"."NAME_SPACE" in (cast(? as smallint)) and "PUBLIC"."LOCAL_PAGE"."IS_REDIRECT" in (cast(? as boolean)) and "PUBLIC"."LOCAL_PAGE"."IS_DISAMBIG" in (cast(? as boolean)))]; Table "LOCAL_PAGE" not found; SQL statement: select count(*) from "PUBLIC"."LOCAL_PAGE" where ("PUBLIC"."LOCAL_PAGE"."LANG_ID" in (cast(? as smallint)) and "PUBLIC"."LOCAL_PAGE"."NAME_SPACE" in (cast(? as smallint)) and "PUBLIC"."LOCAL_PAGE"."IS_REDIRECT" in (cast(? as boolean)) and "PUBLIC"."LOCAL_PAGE"."IS_DISAMBIG" in (cast(? as boolean))) [42102-174]
  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 [update CLIENTS set CLIENTS.LASTSEEN = case when CLIENTS.LASTSEEN is null then cast(? as bigint) else greatest(CLIENTS.LASTSEEN, cast(? as timestamp)) end where CLIENTS.ID = cast(? as int)]; Cannot parse "TIMESTAMP" constant "1475185281"; SQL statement: update CLIENTS set CLIENTS.LASTSEEN = case when CLIENTS.LASTSEEN is null then cast(? as bigint) else greatest(CLIENTS.LASTSEEN, cast(? as timestamp)) end where CLIENTS.ID = cast(? as int) [22007-187]

      at org.h2.util.DateTimeUtils.parseDateValue()
    2. H2 Database Engine
      DateTimeUtils.parseDateValue
      1. org.h2.util.DateTimeUtils.parseDateValue(DateTimeUtils.java:275)
      1 frame