File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Object Relational Mapping and the fly likes Error Help Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Error Help" Watch "Error Help" New topic
Author

Error Help

Shafian Kisna
Ranch Hand

Joined: Oct 25, 2005
Posts: 70
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

Joined: Oct 25, 2005
Posts: 70
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Error Help