• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Error Help

 
Shafian Kisna
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic