Tarun,
It would be my guess that you're having problems with optimistic
locking. I'm assuming you're using a single webobjects app and that
nothing else is updating the database. If that's true, what type of
columns do you have as locking attributes (the lock symbol) ? With
some databases, using dates or high resolution numerics can cause
update errors because the stored resolution is not the same as the
database resolution. So, you might get SQL that looks like:
update table set x=1, y=2.333334, z='10-Jul-07 00:00.001' where key=1
and y=2.33333 and z='11-Jul-07 00:00.000'
I like having a single 'trans_id' integer column to lock on that
always gets incremented. That way, a single value can determine
whether or not the record has been updated inbetween my read and my
save.
Ken
On Jul 15, 2007, at 6:39 PM, Tarun Reddy wrote:
I have code where I updated a value based upon user input. The
first time I update the value, it correctly updates, however if I
attempt to update it again through a second web form submit, I get
the following error:
Application: WOIdeas
Error: com.webobjects.eoaccess.EOGeneralAdaptorException:
updateValuesInRowDescribedByQualifier --
com.webobjects.jdbcadaptor.JDBCChannel method failed to update row
in database
Reason: updateValuesInRowDescribedByQualifier --
com.webobjects.jdbcadaptor.JDBCChannel method failed to update row
in database
Stack trace:
File Line# Method Package
Here is my basic code:
EOEditingContext ec = session.defaultEditingContext();
....
IdeaRating ir = findIdeaRating(session.getUser(), topIdea);
else {
//update ideaRating
int myRatingInt = new
Integer(myRating).intValue();
topIdea.updateRatingToAverage(ir.rating().intValue(),
myRatingInt);
ir.setRating(myRatingInt);
ec.saveChanges();
}
Any ideas?
Thanks!
Tarun
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/kenlists%
40anderhome.com
This email sent to [EMAIL PROTECTED]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
