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


Solutions on the web787

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
, 5 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 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 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 "MESSAGE_ID"; SQL statement: insert into web_message_translation (message_translation_id, content,locale, message_id) values (null, ?, ?, ?) [23502-194]

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 "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 web
NULL not allowed for column "Y"; SQL statement: INSERT INTO table (x, y) VALUES (?, ?) ON DUPLICATE KEY UPDATE y = y + VALUES(y) [23502-174]

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, 4 days ago
Samebug visitor profile picture
Unknown user
Once, 4 months ago
Samebug visitor profile picture
Unknown user
2 times, 9 months ago
Samebug visitor profile picture
Unknown user
2 times, 10 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
149 more bugmates