James,
There is also one other possibility that I like to throw out there in
case you are using MySQL for your database:
MySQL has two different field types used for date/time. There is
"datetime" and "timestamp." These field types are not the same.
Make sure you use "datetime" and not "timestamp" unless you really
want to behavior provided by "timestamp." The "timestamp" field will
automatically update to the current date and time unless the field's
value is explicitly included in the SQL UPDATE statement. EOF will
not include it unless the value (according to EOF) has changed.
If by chance you really do want the behavior of "timestamp" then make
sure it is not included for optimistic locking in your EOModel
definition. However, I would highly recommend against using
"timestamp" entirely. I would expect EOF to become "out-of-sync"
with the actual database values and may cause a lot of confusion.
On Feb 21, 2007, at 1:35 PM, Art Isbell wrote:
On Feb 21, 2007, at 8:02 AM, James Cicenia wrote:
This is me testing and it happens? I don't have anyone else in the
system to
lock the record....
If any of the attributes that you are using for locking is a
floating point or timestamp data type, rounding errors could result
in the fetched value not matching the local value. Also, if any of
the string attributes used for locking might have trailing space
characters, these could be stripped somewhere along the line which
would also cause a mismatch. You might need to eliminate floating
point and timestamp locking attributes or you might need to
explicitly strip trailing space characters from all string
attribute values.
Aloha,
Art
_______________________________________________
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/robertwalker1%
40mac.com
This email sent to [EMAIL PROTECTED]
--
Robert Walker
[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]
