Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2011
    Posts
    3

    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?

    Any help is greatly appreciated.

    Thanks.

  2. #2
    Join Date
    Jun 2011
    Posts
    3

    Error on Insert not Delete

    This error was on the Insert not Delete. Sorry.

  3. #3
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    Some other program(same Java app or not) may be running.

  4. #4
    Join Date
    Jun 2011
    Posts
    3
    Nothing else is running.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •