java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_IVHDR_IVJOB'. The conflict occurred in database 'test', table 'IVJOB', column 'IVHDR_UNID'.

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

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Oracle Community by 3004, 1 year ago
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_IVHDR_IVJOB'. The conflict occurred in database 'test', table 'IVJOB', column 'IVHDR_UNID'.
via Oracle Community by 843859, 3 months ago
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Insert Skip, tax= 207, asset_id = 17399, asset_name_length = 14
via Google Groups by Ting Ning, 4 months ago
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Transaction (Process ID 54) was deadlocked on {lock} resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
via Oracle Community by 3004, 1 year ago
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Violation of PRIMARY KEY constraint 'PK__JD O_SEQUENCEX__2D7CBDC4'. Cannot insert duplicate key in object 'JDO_SEQUENCEX'.
via Google Groups by karin.bj...@intentia.se, 2 years ago
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot insert duplicate key row in object 'WMMLAATR' with unique index 'WMMI067'.
via Google Groups by Joseph Weinstein, 4 months ago
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name '#foo'.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_IVHDR_IVJOB'. The conflict occurred in database 'test', table 'IVJOB', column 'IVHDR_UNID'.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(UnknownSource)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(UnknownSource)
at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(UnknownSource)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(UnknownSource)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(UnknownSource)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeUpdateInternal(UnknownSource)
at com.microsoft.jdbc.base.BasePreparedStatement.executeUpdate(UnknownSource)
at com.solarmetric.datasource.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:111)
at com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executePreparedStatementNonBatch(SQLExecutionManagerImpl.java:525)
at com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executePreparedStatement(SQLExecutionManagerImpl.java:494)
at com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executeInternal(SQLExecutionManagerImpl.java:388)
at com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.flush(SQLExecutionManagerImpl.java:255)
at com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.flush(JDBCStoreManager.java:515)
at com.solarmetric.kodo.runtime.PersistenceManagerImpl.flushInternal(PersistenceManagerImpl.java:730)
at com.solarmetric.kodo.runtime.PersistenceManagerImpl.commit(PersistenceManagerImpl.java:455)
at com.ipacs.als.test.Test.main(Test.java:200)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 2 years ago
Once, 10 months ago

Write tip

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