Unanswered: Insert after Delete fails. Please Help!!
Hi everyone. I am a newbie and I need some help.
Here is my situation.
Java app does a delete of a record and then does an insert of the same record.
Database #1 - Works fine never had a problem.
Had our DBA create an exact copy of Database#1 for our Qual region. This is called Database#2.
When the java application runs it now fails on the delete with:
SQL0803N One or more values in the INSERT statement, Update statment, or foreign key update caused by a DELETE statement are not valid becaue the primary key, unique constraint or unique index identified by "2" constrains table DATABASE2.JDBPFFE from having duplicate rows or columns. SQLSTATE=23505
Any ideas on why this would happen? Now here is the kicker..... I had our DBA stop and restart the database and it started working. Well for a while and then the error started popping up again. Its this inconsistency that confuses me. Why would it work after a restart and then after a while start erroring out?
Is there some log file that I could look at and compare the differences between the application processing database#1 and database#2?