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?

Any help is greatly appreciated.

Thanks.

This error was on the Insert not Delete. Sorry.

Some other program(same Java app or not) may be running.

Nothing else is running.