• 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
lock operation locked more than one row issue!
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

lock operation locked more than one row issue!


  • Subject: lock operation locked more than one row issue!
  • From: Fred Wells <email@hidden>
  • Date: Thu, 21 May 2009 17:12:43 -0500
  • Importance: Normal

This has bewildered me for two days.
First not exactly the most standard set up  running on windows wo 5.2.3, sql server 2000 using the jtds sql driver.
On a certain table in my db I keep getting the "lock operation locked more than one row" what I do know is that when it tries the Lock statement it looks like this:

SELECT t0.duration, RTRIM(t0.durationIsDays), t0.id, t0.idForTemplate, RTRIM(t0.instruction), RTRIM(t0.isActive), RTRIM(t0.isFirstTask), RTRIM(t0.isLastTask), RTRIM(t0.name), t0.phaseID, t0.taskID, t0.taskID1, t0.taskID2, t0.taskTypeID, t0.threshold, RTRIM(t0.thresholdIsDays), t0.workflowTemplateID, t0.workgroupID, t0.xCoordinate, t0.yCoordinate FROM TemplateTask t0 WITH (UPDLOCK, ROWLOCK)"

there's no where clause?!?! so obviously it's going to return more than one row. As far as i can tell all my types are in order. I'm nto sure where else to look for inconsistencies.

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

------------------------------------------------------------------------
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>
  • Prev by Date: Re: JavaFSAdaptor and non-working EO methods
  • Next by Date: Re: ERXEC.useSharedEditingContext
  • Previous by thread: Re: Frustrated by WO / Eclipse / WOLips :(
  • Next by thread: Re: lock operation locked more than one row issue!
  • Index(es):
    • Date
    • Thread