Frederick Wells
MarketForward, a Publicis Groupe Company
427 South LaSalle St.
Chicago, Il 60605
312.220.3056
-----Chuck Hill <[email protected]> wrote: -----
MarketForward, a Publicis Groupe Company
427 South LaSalle St.
Chicago, Il 60605
312.220.3056
To: Fred Wells <[email protected]>
From: Chuck Hill <[email protected]>
Date: 05/21/2009 05:17PM
cc: [email protected]
Subject: Re: lock operation locked more than one row issue!
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 protected])
> Help/Unsubscribe/Update your Subscription:
> http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net
>
> This email sent to [email protected]
--
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 protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
