org.h2.jdbc.JdbcSQLException: Schema "public" not found; SQL statement: insert into "public"."user" ("id", "username", "password", "role") values ( cast(? as uuid), cast(? as varchar), cast(? as varchar), cast(? as varchar)) [90079-192]

Google Groups | Mark Manders | 2 months ago
  1. 0

    Schema does not exist with render mapping

    Google Groups | 2 months ago | Mark Manders
    org.h2.jdbc.JdbcSQLException: Schema "public" not found; SQL statement: insert into "public"."user" ("id", "username", "password", "role") values ( cast(? as uuid), cast(? as varchar), cast(? as varchar), cast(? as varchar)) [90079-192]
  2. 0

    Corrupted database v1.4.192 with PageStore after OutOfMemory error

    GitHub | 1 month ago | petrholik
    org.h2.jdbc.JdbcSQLException: Obecná chyba: "java.lang.RuntimeException: page[704] data leaf table:10 LOB_DATA entries:1 parent:1250 keys:[345, 346] offsets:[1529, 340] parent 1250 expected 239" General error: "java.lang.RuntimeException: page[704] data leaf table:10 LOB_DATA entries:1 parent:1250 keys:[345, 346] offsets:[1529, 340] parent 1250 expected 239"; SQL statement: INSERT INTO INFORMATION_SCHEMA.LOB_DATA(BLOCK, COMPRESSED, DATA) VALUES(?, ?, ?) [50000-192]
  3. 0

    H2 User defined aggregate function, ListAgg, can't use DISTINCT or TRIM() on the first parameter

    Stack Overflow | 1 year ago | Jeffrey P
    org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SELECT ... "; expected "NOT, EXISTS, INTERSECTS, SELECT, FROM"; SQL statement: select ... from ... group by ... [42001-174]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error using db-seed data

    GitHub | 1 year ago | joffotron
    org.jooq.exception.DataAccessException: SQL [insert into GROUPS (ID, NAME, CREATEDAT, UPDATEDAT) values (cast(? as int), cast(? as varchar), cast(? as timestamp), cast(? as timestamp)), (cast(? as int), cast(? as varchar), cast(? as timestamp), cast(? as timestamp)), (cast(? as int), cast(? as varchar), cast(? as timestamp), cast(? as timestamp)), (cast(? as int), cast(? as varchar), cast(? as timestamp), cast(? as timestamp)), (cast(? as int), cast(? as varchar), cast(? as timestamp), cast(? as timestamp))]; Table "GROUPS" not found; SQL statement: insert into GROUPS (ID, NAME, CREATEDAT, UPDATEDAT) values (cast(? as int), cast(? as varchar), cast(? as timestamp), cast(? as timestamp)), (cast(? as int), cast(? as varchar), cast(? as timestamp), cast(? as timestamp)), (cast(? as int), cast(? as varchar), cast(? as timestamp), cast(? as timestamp)), (cast(? as int), cast(? as varchar), cast(? as timestamp), cast(? as timestamp)), (cast(? as int), cast(? as varchar), cast(? as timestamp), cast(? as timestamp)) [42102-187]
  6. 0

    db-seed issues

    Google Groups | 3 months ago | Matthew Halder
    org.h2.jdbc.JdbcSQLException: 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]

    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.h2.jdbc.JdbcSQLException

      Schema "public" not found; SQL statement: insert into "public"."user" ("id", "username", "password", "role") values ( cast(? as uuid), cast(? as varchar), cast(? as varchar), cast(? as varchar)) [90079-192]

      at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate()
    2. Spring Framework
      AbstractFallbackSQLExceptionTranslator.translate
      1. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84)[spring-jdbc-4.3.3.RELEASE.jar:4.3.3.RELEASE]
      2. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)[spring-jdbc-4.3.3.RELEASE.jar:4.3.3.RELEASE]
      3. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)[spring-jdbc-4.3.3.RELEASE.jar:4.3.3.RELEASE]
      3 frames
    3. org.springframework.boot
      JooqExceptionTranslator.exception
      1. org.springframework.boot.autoconfigure.jooq.JooqExceptionTranslator.translate(JooqExceptionTranslator.java:89)[spring-boot-autoconfigure-1.4.1.RELEASE.jar:1.4.1.RELEASE]
      2. org.springframework.boot.autoconfigure.jooq.JooqExceptionTranslator.handle(JooqExceptionTranslator.java:78)[spring-boot-autoconfigure-1.4.1.RELEASE.jar:1.4.1.RELEASE]
      3. org.springframework.boot.autoconfigure.jooq.JooqExceptionTranslator.exception(JooqExceptionTranslator.java:53)[spring-boot-autoconfigure-1.4.1.RELEASE.jar:1.4.1.RELEASE]
      3 frames
    4. jOOQ
      AbstractDelegatingQuery.execute
      1. org.jooq.impl.ExecuteListeners.exception(ExecuteListeners.java:244)[jooq-3.8.4.jar:na]
      2. org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:363)[jooq-3.8.4.jar:na]
      3. org.jooq.impl.AbstractDelegatingQuery.execute(AbstractDelegatingQuery.java:135)[jooq-3.8.4.jar:na]
      3 frames