org.h2.jdbc.JdbcSQLException

tip

Check if you're not creating unused SQL entities, as it might cause this exception.


rafaelrafael

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • mvcc
    via by Rami Ojares,
  • Connection.getMetaData().getTables(…) Fails
    via by Jason Osgood,
  • SymmetricDS 3.8 demo not working
    via symmetricds by mike182764
    ,
  • Timeout error trying to lock table in h2
    via by Unknown author,
  • Handling database constraint errors nicely
    via Stack Overflow by Vogel612
    ,
    • 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(DbException.java:345) at org.h2.message.DbException.get(DbException.java:179) at org.h2.message.DbException.get(DbException.java:155) at org.h2.table.Column.validateConvertUpdateSequence(Column.java:305) at org.h2.table.Table.validateConvertUpdateSequence(Table.java:749) at org.h2.command.dml.Insert.insertRows(Insert.java:151) at org.h2.command.dml.Insert.update(Insert.java:114) at org.h2.command.CommandContainer.update(CommandContainer.java:78) at org.h2.command.Command.executeUpdate(Command.java:253) at org.h2.server.TcpServerThread.process(TcpServerThread.java:345) at org.h2.server.TcpServerThread.run(TcpServerThread.java:159) at java.lang.Thread.run(Thread.java:745)

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor2 times, last one,
    Unknown visitor
    Unknown visitor2 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor2 times, last one,
    144 more bugmates