Error Help

[Shafian Kisna]

Hi Everyone,

I am trying to remove my record and insert values to the tables, but I encountered the following error message. Could someone please help?

-----------------------------------------
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/SUN] SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "2" constrains table "PHILIPS.TA_SCHEDULED_TIME" from having duplicate rows for those columns.
SQLSTATE=23505
-----------------------------------------

Thanks in advance

Best Regards
SK

[Shafian Kisna]

Just to share...
Manage to get the solution fr a coll.
It was basically the jdo's response time in removing a record. As a result, by setting the jdo.begin() and jdo.commit(), before & end of the removal condition, the error was resolved.

Take extra care when using the begin and commit of the connection, so as to get trapped in the ObjectNotPersistentException. This exception comes abt when the object is not found, as a result of commit() a particular transaction.

Best Regards
SK