org.h2.jdbc.JdbcSQLException

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


Samebug tips1

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

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.


Solutions on the web1173

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

Solution icon of stackoverflow
NULL not allowed for column "ID"; SQL statement: insert into CheckedInUsers (checkedInEventsId, checkedInUsersId) values (?, ?) [23502-191]

Solution icon of stackoverflow
via Stack Overflow by Luke
, 3 months ago
NULL not allowed for column "PHONE_ID"; SQL statement: insert into phone_history (id, created, phone_id, type_id) values (null, ?, ?, ?) [23502-168]

Solution icon of github
NULL not allowed for column "ID_USUARIO"; SQL statement: insert into TB_USUARIO (ID_USUARIO, NM_USUARIO) values (?, ?) [23502-192]

Solution icon of web
via javatalks.ru by Unknown author, 1 year ago
Значение NULL не разрешено для поля "ID" NULL not allowed for column "ID"; SQL statement: insert into articles (article, dwnlddate) values (?, ?) [23502-169]

Solution icon of stackoverflow
NULL not allowed for column "FRIENDS_PERSON_ID"; SQL statement: /* insert collection row net.myuser.myapp.common.dal.dto.Person.enemies */ insert into persons_persons (persons_person_id, enemies_word_id) values (?, ?) [23502-173]

Solution icon of github
via GitHub by melodous
, 1 year ago
NULL not allowed for column "DESCRIPTION"; SQL statement: INSERT INTO BRANCHES(PROJECTID, NAME, DESCRIPTION, DISABLED) VALUES (?, ?, ?, ?) [23502-185]

Solution icon of stackoverflow
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]

Solution icon of stackoverflow
NULL not allowed for column "ID"; SQL statement: INSERT INTO systemuser (systemuseridnr, editby, failedloginattempts, firstname, lastedittime, lastfailedlogindate, lastlogindate, lastname, systemusername, password, phone, statusnr, systemusergroupidnr) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23502-168]

Solution icon of googlegroups
via Google Groups by David Cuthbert, 1 year ago
NULL not allowed for column "USER"; SQL statement: insert into foo(id) values(1) [90006-136]

Stack trace

  • 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)

Write tip

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

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 2 months ago
Samebug visitor profile picture
Unknown user
2 times, 7 months ago
Samebug visitor profile picture
Unknown user
2 times, 8 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
2 times, 1 year ago
144 more bugmates