org.h2.jdbc.JdbcSQLException: NULL not allowed for column "MY_CONFIG_ID"; SQL statement: insert into my_config (value, id) values (?, ?) [23502-190]

tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Spring JPA insert entity with id equals null (should be auto generated)

    Stack Overflow | 2 months ago | Volodymyr Bakhmatiuk
    org.h2.jdbc.JdbcSQLException: NULL not allowed for column "MY_CONFIG_ID"; SQL statement: insert into my_config (value, id) values (?, ?) [23502-190]
  2. 0

    Issue with cascade persist using JPA

    Oracle Community | 5 years ago | 926181
    org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "CONSTRAINT_42_1: PUBLIC.B FOREIGN KEY(A_IDA) REFERENCES PUBLIC.A(IDA)"; SQL statement: INSERT INTO ABCD.PUBLIC.B (NAME, IDB, A_IDA) VALUES (?, ?, ?) [23506-164]
  3. 0

    Incorrect SQLSTATE for internal error 90009 (invalid date format)

    Google Groups | 6 years ago | DinamicaFramework
    org.h2.jdbc.JdbcSQLException: Imposible interpretar la constante de fecha "XXX", causa: "format yyyy-mm-dd" Cannot parse date constant "XXX", cause: "format yyyy-mm-dd"; SQL statement: INSERT INTO demo.test1(id, text_not_null, text_unique, text_type, id2) VALUES (NEXTVAL('demo.seq_test1'), 'XXXX', 3, 'XXX', 1) -- (NEXTVAL('demo.seq_test1'), 'XXXX', 3, 'XXX', 1) [90009-155]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Issue 368 - h2database - Support ON DUPLICATE KEY UPDATE syntax in MySQL Compatibility mode - Java SQL database - Google Project Hosting

    google.com | 1 year ago
    org.h2.jdbc.JdbcSQLException: NULL not allowed for column "Y"; SQL statement: INSERT INTO table (x, y) VALUES (?, ?) ON DUPLICATE KEY UPDATE y = y + VALUES(y) [23502-174]

  1. andyglick 352 times, last 1 year ago
17 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. org.h2.jdbc.JdbcSQLException

    NULL not allowed for column "MY_CONFIG_ID"; SQL statement: insert into my_config (value, id) values (?, ?) [23502-190]

    at org.h2.message.DbException.getJdbcSQLException()
  2. H2 Database Engine
    TcpServerThread.run
    1. org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    2. org.h2.message.DbException.get(DbException.java:179)
    3. org.h2.message.DbException.get(DbException.java:155)
    4. org.h2.table.Column.validateConvertUpdateSequence(Column.java:305)
    5. org.h2.table.Table.validateConvertUpdateSequence(Table.java:749)
    6. org.h2.command.dml.Insert.insertRows(Insert.java:151)
    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:253)
    10. org.h2.server.TcpServerThread.process(TcpServerThread.java:345)
    11. org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
    11 frames
  3. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)
    1 frame