Which database? Have you turned on SQL logging to see what SQL is being generated. Generally, EOF should _not_ be locking rows. Is there a BLOB/CLOB in the table being deleted?
This can also be a symptom of violating the EOF commandments which results in EOF getting confused between inserts, updates, and deletes. Trying to process a delete as an update can result in data inconsistencies leading EOF to attempt row locking. Chuck On Dec 1, 2010, at 4:50 PM, Andrew R. Kinnie wrote: > I have an app with a D2W component which is having issues deleting. > Specifically, I have two entities relevant Booking and Performance which are > related. Booking has a to-one to Performance. (Performance has a to-many to > Booking) A Booking is essentially a Performance on a particular event date. > So If I have Jerry Seinfeld this weekend, I'd have a Booking for Dec 3, and > another for Dec 4. When we attempted to add some bookings for the weekend, > the user added three bookings for Jerry on Dec 3, and when we tried to delete > them, we got this: > > com.webobjects.eoaccess.EOGeneralAdaptorException: lockRowComparingAttributes > -- com.webobjects.jdbcadaptor.JDBCChannel: lock operation locked more than > one row > The model for the Booking entity has a bookingid, a performanceid and an > eventDate. They were all used for locking. I deleted the performanceid from > the attributes for locking entry in the plist, and eliminated the old entry > in jdbc2info (for a no longer active db connection) but I still get this > error. I also removed the locking on eventDate, to no avail. > > In the short term, I'd be happy enough to simply delete them out of the > database, but I've always thought doing that through WO was greatly preferred > and would potentially avoid major issues, and in any event, D2W presumably > should not be doing this. > > Any ideas? > > Recently updated wonder (5.4 branch) running on a mac, 10.6. > > Andrew > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net > > This email sent to ch...@global-village.net -- Chuck Hill Senior Consultant / VP Development Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
