My current theory, to be explored tomorrow, revolves around this comment
from Andrus (I think) in DefaultType:
* Addresses bugs in certain JDBC drivers that do not handle
java.lang.Short
* properly. Recasts java.lang.Short to java.lang.Integer when
* binding values to PreparedStatement. Drivers that are proven to have
issues with
* short values are Sybase and Oracle (Mac OS X only).
I'm guessing it has to do with my custom enumerated type (an Integer
under the hoods) that maps to a SMALLINT in Sybase (and, as fate would
have it, I'm on OS X). Everything else looks OK (except, of course, it
UPDATEs an unchanged record because it thinks my PK has changed).
/dev/mrg
PS. I still think the bind log could be better.
-----Original Message-----
From: Mike Kienenberger [mailto:mkienen..laska.net]
Sent: Wednesday, May 11, 2005 4:44 PM
To: cayenne-deve..bjectstyle.org
Cc: cayenne-deve..bjectstyle.org
Subject: Re: Optimistic Locking Bug?
"Gentry, Michael (Contractor)" <michael_gentr..anniemae.com> wrote:
> I'm still having optimistic locking issues, though ... Bleh.
Start by turning off locking for datetime/timestamp fields.
These have given me trouble on both Oracle and Openbase for different
reasons.
Once you determine that these are causing the problem, then you can try
to
figure out why. :)
-Mike
This archive was generated by hypermail 2.0.0 : Wed May 11 2005 - 18:05:25 EDT