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: Tue, 26 May 2009 13:37:18 -0700
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).
Chuck
On May 26, 2009, at 1:19 PM, Fred Wells wrote:
I'm developing on 5.3.3 so I'm using WOLips and EOModeler. No
jdbc2info file, I can't seem to find anything out of the ordinary in
my model. Same behavior with locks on or off.
Frederick Wells
MarketForward, a Publicis Groupe Company
427 South LaSalle St.
Chicago, Il 60605
312.220.3056
-----Chuck Hill <email@hidden> wrote: -----
To: Fred Wells <email@hidden>
From: Chuck Hill <email@hidden>
Date: 05/26/2009 10:34AM
cc: email@hidden
Subject: Re: lock operation locked more than one row issue!
Next place to look is using unlocked editing contexts. Then double
check your model.
Hmmm, WO 5.2.3. So not using WOLips and EntityModeler? Check your
EOModel index for a jdbc2info file and remove it if you find it.
Chuck
On May 26, 2009, at 8:09 AM, Fred Wells wrote:
> I did initially use vertical inheritance as part of my
> troubleshooting process I took it out. I still get the same results.
>
>
> Frederick Wells
> MarketForward, a Publicis Groupe Company
> 427 South LaSalle St.
> Chicago, Il 60605
> 312.220.3056
>
> -----Chuck Hill <email@hidden> wrote: -----
>
> To: Fred Wells <email@hidden>
> From: Chuck Hill <email@hidden>
> Date: 05/21/2009 05:17PM
> cc: email@hidden
> 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@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/
>
>
>
>
------------------------------------------------------------------------
> 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.
--
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.
--
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