Re: lock operation locked more than one row issue!
Re: lock operation locked more than one row issue!
- Subject: Re: lock operation locked more than one row issue!
- From: Chuck Hill <email@hidden>
- Date: Thu, 21 May 2009 15:17:50 -0700
Are you using Vertical Inheritance?
On May 21, 2009, at 3:12 PM, Fred Wells wrote:
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
--
Chuck Hill Senior Consultant / VP Development
Come to WOWODC'09 in San Fran this June!
http://www.wocommunity.org/wowodc09/
_______________________________________________
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