com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'NM' cannot be null Error Code: 1048 Call: UPDATE KRMS_TERM_SPEC_T SET NM = ?, TYP = ?, DESC_TXT = ?, VER_NBR = ? WHERE ((TERM_SPEC_ID = ?) AND (VER_NBR = ?)) bind => [6 parameters bound] Query: UpdateObjectQuery(org.kuali.rice.krms.impl.repository.TermSpecificationBo@632037f9)

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

,

Check whether privilege has the "not null" restriction. If so it always has to have a value and can never be null.

A different reason could be a wrong implementation of a foreign key. Check whether you always correctly insert/update in both tables.

Solutions on the web

via Kuali JIRA by Erik Meade, 1 year ago
Column 'NM' cannot be null Error Code: 1048 Call: UPDATE KRMS_TERM_SPEC_T SET NM = ?, TYP = ?, DESC_TXT = ?, VER_NBR = ? WHERE ((TERM_SPEC_ID = ?) AND (VER_NBR = ?)) bind => [6 parameters bound] Query: UpdateObjectQuery(org.kuali.rice.krms.impl.repository.TermSpecificationBo@632037f9)
via Kuali JIRA by Christopher Wade, 1 year ago
Column 'NMSPC_CD' cannot be null Error Code: 1048 Call: UPDATE KRMS_TERM_SPEC_T SET NMSPC_CD = ?, VER_NBR = ? WHERE ((TERM_SPEC_ID = ?) AND (VER_NBR = ?)) bind => [4 parameters bound] Query: UpdateObjectQuery(org.kuali.rice.krms.impl.repository.TermSpecificationBo@41f774db)
via Stack Overflow by ManieQ
, 2 years ago
Duplicate entry '111222-0' for key 2 Error Code: 1062 Call: UPDATE Booking SET bk_cnum_user = ?, bk_title = ? WHERE (bk_id = ?) bind => [3 parameters bound] Query: UpdateObjectQuery(tp.coma.cint.data.entities.Bookings[ bkId=22 ])
via Stack Overflow by Sam Sorrell
, 11 months ago
Column 'quote_id' cannot be null Error Code: 1048 Call: UPDATE quote_item SET QUOTE_ID = ? WHERE (ID = ?) bind => [null, 64] Query: UpdateObjectQuery(com.millereads.model.quote.QuoteItem@11e6d13)
via Stack Overflow by pringlesinn
, 2 years ago
Column 'color_id' cannot be null Error Code: 1048 Call: UPDATE vehicle SET color_id = ? WHERE (id = ?) bind => [2 parameters bound] Query: DeleteObjectQuery(br.com.something.entity.Vehicle[ id=3 ])
via Stack Overflow by marcelocbf
, 2 years ago
, TODATE, TYPE, ENTITY_UID, VERSION) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [14 parameters bound] Query: InsertObjectQuery(co.bmq.media.entity.Artist@3741c26)
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'NM' cannot be null Error Code: 1048 Call: UPDATE KRMS_TERM_SPEC_T SET NM = ?, TYP = ?, DESC_TXT = ?, VER_NBR = ? WHERE ((TERM_SPEC_ID = ?) AND (VER_NBR = ?)) bind => [6 parameters bound] Query: UpdateObjectQuery(org.kuali.rice.krms.impl.repository.TermSpecificationBo@632037f9)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2460)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2377)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2361)
at sun.reflect.GeneratedMethodAccessor611.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at net.bull.javamelody.JdbcWrapper.doExecute(JdbcWrapper.java:385)
at net.bull.javamelody.JdbcWrapper$StatementInvocationHandler.invoke(JdbcWrapper.java:130)
at net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:271)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:890)
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:900)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:962)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:631)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:558)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2002)
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:298)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.updateObject(DatasourceCallQueryMechanism.java:797)
at org.eclipse.persistence.internal.queries.StatementQueryMechanism.updateObject(StatementQueryMechanism.java:435)
at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.updateObjectForWriteWithChangeSet(DatabaseQueryMechanism.java:1079)
at org.eclipse.persistence.queries.UpdateObjectQuery.executeCommitWithChangeSet(UpdateObjectQuery.java:84)
at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:301)
at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:899)
at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:798)
at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108)
at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1786)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1737)
at org.eclipse.persistence.internal.sessions.CommitManager.commitChangedObjectsForClassWithChangeSet(CommitManager.java:267)
at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:130)
at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:4207)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1441)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1531)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.issueSQLbeforeCompletion(UnitOfWorkImpl.java:3168)
at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.issueSQLbeforeCompletion(RepeatableWriteUnitOfWork.java:352)

Users with the same issue

6 times, 1 week ago
Once, 2 weeks ago
Samebug visitor profile picture
Unknown user
Once, 3 years ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
70 more bugmates

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