• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag
 

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: lock operation locked more than one row issue!
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: lock operation locked more than one row issue!


  • Subject: Re: lock operation locked more than one row issue!
  • From: Fred Wells <email@hidden>
  • Date: Wed, 27 May 2009 13:29:01 -0500
  • Importance: Normal

OK, so after trying several different drivers and all throw some type of locking error either lock failed to retrieve any rows or lock operation locked more than one row. Right now I'm just looking for any more ideas as to where look for a possible cause on this. The EOModel files seem to be fine I can't find anythign out of the ordinary I'm not sure where else to look or if there are any parameters that can be changed to alter how locking is handled.

Frederick Wells
MarketForward, a Publicis Groupe Company
427 South LaSalle St.
Chicago, Il 60605
312.220.3056

-----Chuck Hill <email@hidden> wrote: -----

To: Guido Neitzer <email@hidden>
From: Chuck Hill <email@hidden>
Date: 05/26/2009 07:18PM
cc: Development WebObjects <email@hidden>, Fred Wells <email@hidden>
Subject: Re: lock operation locked more than one row issue!


On May 26, 2009, at 5:13 PM, Guido Neitzer wrote:

> On May 26, 2009, at 1:37 PM, Chuck Hill wrote:
>
>> I am not sure what you have done then.  The problem is not that it  
>> is selecting multiple rows.  The problem is that it is trying to  
>> lock rows:
>>
>>> > > SELECT ...  FROM TemplateTask t0 WITH (UPDLOCK, ROWLOCK)"
>>
>>
>> EOF should not be doing that, that is optimistic^H^H^H^H^H^H^H^  
>> pessimistic locking.  Something has confused EOF which causes it to  
>> do this (it is a bug).
>
> Do you have to tell the plugin that explicitly? Never used MS SQL.


No, you don't.  It is bad, but not that bad.  ;-)

Chuck


--
Chuck Hill             Senior Consultant / VP Development

Come to WOWODC'09 in San Fran this June!
http://www.wocommunity.org/wowodc09/



------------------------------------------------------------------------
Disclaimer
The information in this email and any attachments may contain proprietary and confidential information that is intended for the addressee(s) only. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, retention or use of the contents of this information is prohibited. When addressed to our clients or vendors, any information contained in this e-mail or any attachments is subject to the terms and conditions in any governing contract. If you have received this e-mail in error, please immediately contact the sender and delete the e-mail.
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

  • Follow-Ups:
    • Re: lock operation locked more than one row issue!
      • From: Chuck Hill <email@hidden>
    • Re: lock operation locked more than one row issue!
      • From: David Avendasora <email@hidden>
References: 
 >lock operation locked more than one row issue! (From: Fred Wells <email@hidden>)
 >Re: lock operation locked more than one row issue! (From: Chuck Hill <email@hidden>)
 >Re: lock operation locked more than one row issue! (From: Fred Wells <email@hidden>)
 >Re: lock operation locked more than one row issue! (From: Chuck Hill <email@hidden>)
 >Re: lock operation locked more than one row issue! (From: Fred Wells <email@hidden>)
 >Re: lock operation locked more than one row issue! (From: Chuck Hill <email@hidden>)
 >Re: lock operation locked more than one row issue! (From: Guido Neitzer <email@hidden>)
 >Re: lock operation locked more than one row issue! (From: Chuck Hill <email@hidden>)

  • Prev by Date: Re: Prototype mutableArray savechanges error
  • Next by Date: Re: lock operation locked more than one row issue!
  • Previous by thread: Re: lock operation locked more than one row issue!
  • Next by thread: Re: lock operation locked more than one row issue!
  • Index(es):
    • Date
    • Thread