This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Error Help" Watch "Error Help" New topic

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?

----------------------------------------- [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.

Thanks in advance

Best Regards
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
jQuery in Action, 2nd edition
subject: Error Help
Similar Threads
db2 SQL
one question in ICE 287
Synchronizing issue
Invalid column index