On Sep 30, 2004, at 3:12 AM, Jeremy Matthews wrote:
However, when I take an entry that I imported directly into MySQL (via
CocoaMySQL), it will display and delete fine. And when I click on the
"Editing" link I setup, it passes the values accordingly. But then,
after changing some values, I try to save and hit a WO error message:
com.webobjects.eoaccess.EOGeneralAdaptorException:
updateValuesInRowDescribedByQualifier --
com.webobjects.jdbcadaptor.JDBCChannel method failed to update row in
database
This exception is generally thrown when an optimistic locking failure
has occurred. I.e., the values of the attributes used for locking in
the cache (i.e., the values fetched) do not match the values of the
same attributes in the database when the update is being saved. This
can occur when some other process has updated the object since it was
fetched by your WO process or when a rounding error occurs when the
database value is converted to a possibly less precise Java value.
This can happen with timestamps or floating point values. You might
try excluding NSTimestamp attributes from the list of attributes used
for locking in your EOModel to see whether that solves the problem.
