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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

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

Solutions on the web

via Stack Overflow by Volodymyr Bakhmatiuk
, 11 months ago
NULL not allowed for column "MY_CONFIG_ID"; SQL statement: insert into my_config (value, id) values (?, ?) [23502-190]
via Stack Overflow by user8921532
, 2 weeks ago
NULL not allowed for column "PRODUCTNAME"; SQL statement: insert into Product (productId, productCategory, productCondition, productDescription, productManufacturer, productName, productPrice, productStatus, unitInStock) values (null, ?, ?, ?, ?, ?, ?, ?, ?) [23502-196]
via Stack Overflow by Tricoman
, 8 months ago
NULL not allowed for column "MESSAGE_ID"; SQL statement: insert into web_message_translation (message_translation_id, content,locale, message_id) values (null, ?, ?, ?) [23502-194]
via javatalks.ru by Unknown author, 2 years ago
Значение NULL не разрешено для поля "ID" NULL not allowed for column "ID"; SQL statement: insert into articles (article, dwnlddate) values (?, ?) [23502-169]
via Stack Overflow by TroyB
, 2 years ago
NULL not allowed for column "ZIPCODE"; SQL statement: insert into customer (id, version, billaddr, billcity, billstate, billzipcode, cell, contact, country_id, custcode, custname, date_created, email, fax, last_updated, organization, phone, shipaddr
via Google Groups by David Cuthbert, 2 years ago
NULL not allowed for column "USER"; SQL statement: insert into foo(id) values(1) [90006-136]
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

Once, 3 days ago
24 times, 3 days ago
2 times, 2 weeks ago
Once, 1 month ago
4 times, 2 months ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.