Here is one of my plist:
{
attributes = (
{
allowsNull = Y;
columnName = duration;
name = duration;
prototypeName = intNumber;
userInfo = {"_EntityModeler" = {generateSource =
NO; }; };
},
{
allowsNull = Y;
columnName = durationIsDays;
name = durationIsDays;
prototypeName = charFlag;
userInfo = {"_EntityModeler" = {generateSource =
NO; }; };
},
{
allowsNull = N;
name = id;
prototypeName = id;
userInfo = {"_EntityModeler" = {generateSource =
NO; }; };
},
{
allowsNull = Y;
columnName = idForTemplate;
name = idForTemplate;
prototypeName = intNumber;
userInfo = {"_EntityModeler" = {generateSource =
NO; }; };
},
{
allowsNull = Y;
columnName = instruction;
name = instruction;
prototypeName = varchar255;
userInfo = {"_EntityModeler" = {generateSource =
NO; }; };
},
{
allowsNull = Y;
columnName = isActive;
name = isActive;
prototypeName = charFlag;
userInfo = {"_EntityModeler" = {generateSource =
NO; }; };
},
{
allowsNull = Y;
columnName = isFirstTask;
name = isFirstTask;
prototypeName = charFlag;
userInfo = {"_EntityModeler" = {generateSource =
NO; }; };
},
{
allowsNull = Y;
columnName = isLastTask;
name = isLastTask;
prototypeName = charFlag;
userInfo = {"_EntityModeler" = {generateSource =
NO; }; };
},
{
allowsNull = Y;
columnName = name;
name = name;
prototypeName = varchar100;
userInfo = {"_EntityModeler" = {generateSource =
NO; }; };
},
{
allowsNull = N;
columnName = phaseID;
name = phaseID;
prototypeName = id;
userInfo = {"_EntityModeler" = {generateSource =
NO; }; };
},
{
allowsNull = Y;
columnName = taskID;
name = taskID;
prototypeName = id;
userInfo = {"_EntityModeler" = {generateSource =
NO; }; };
},
{
allowsNull = Y;
columnName = taskID1;
name = taskID1;
prototypeName = id;
userInfo = {"_EntityModeler" = {generateSource =
NO; }; };
},
{
allowsNull = Y;
columnName = taskID2;
name = taskID2;
prototypeName = id;
userInfo = {"_EntityModeler" = {generateSource =
NO; }; };
},
{
allowsNull = N;
columnName = taskTypeID;
name = taskTypeID;
prototypeName = id;
userInfo = {"_EntityModeler" = {generateSource =
NO; }; };
},
{
allowsNull = Y;
columnName = threshold;
name = threshold;
prototypeName = intNumber;
userInfo = {"_EntityModeler" = {generateSource =
NO; }; };
},
{
allowsNull = Y;
columnName = thresholdIsDays;
name = thresholdIsDays;
prototypeName = charFlag;
userInfo = {"_EntityModeler" = {generateSource =
NO; }; };
},
{
allowsNull = Y;
columnName = workflowTemplateID;
name = workflowTemplateID;
prototypeName = id;
userInfo = {"_EntityModeler" = {generateSource =
NO; }; };
},
{
allowsNull = N;
columnName = workgroupID;
name = workgroupID;
prototypeName = id;
userInfo = {"_EntityModeler" = {generateSource =
NO; }; };
},
{
allowsNull = Y;
columnName = xCoordinate;
name = xCoordinate;
prototypeName = intNumber;
userInfo = {"_EntityModeler" = {generateSource =
NO; }; };
},
{
allowsNull = Y;
columnName = yCoordinate;
name = yCoordinate;
prototypeName = intNumber;
userInfo = {"_EntityModeler" = {generateSource =
NO; }; };
}
);
attributesUsedForLocking = (
duration,
durationIsDays,
id,
idForTemplate,
instruction,
isActive,
isFirstTask,
isLastTask,
name,
phaseID,
taskID,
taskID1,
taskID2,
taskTypeID,
threshold,
thresholdIsDays,
workflowTemplateID,
workgroupID,
xCoordinate,
yCoordinate
);
className = "com.marketforward.mundo.data.TemplateTask";
classProperties = (
destinationApprovalTasks,
destinationRejectTasks,
destinationTasks,
duration,
durationIsDays,
idForTemplate,
instruction,
isActive,
isFirstTask,
isLastTask,
name,
phase,
sourceApprovalTask,
sourceRejectTask,
sourceTask,
taskType,
threshold,
thresholdIsDays,
workflowTemplate,
workgroup,
xCoordinate,
yCoordinate
);
externalName = TemplateTask;
fetchSpecificationDictionary = {};
name = TemplateTask;
parent = Task;
primaryKeyAttributes = (id);
relationships = (
{
destination = Task;
isToMany = Y;
joinSemantic = EOInnerJoin;
joins = ({destinationAttribute = taskID2;
sourceAttribute = id; });
name = destinationApprovalTasks;
},
{
destination = Task;
isToMany = Y;
joinSemantic = EOInnerJoin;
joins = ({destinationAttribute = taskID1;
sourceAttribute = id; });
name = destinationRejectTasks;
},
{
destination = Task;
isToMany = Y;
joinSemantic = EOInnerJoin;
joins = ({destinationAttribute = taskID;
sourceAttribute = id; });
name = destinationTasks;
},
{
destination = Phase;
isMandatory = Y;
isToMany = N;
joinSemantic = EOInnerJoin;
joins = ({destinationAttribute = id; sourceAttribute =
phaseID; });
name = phase;
},
{
destination = Task;
isToMany = N;
joinSemantic = EOInnerJoin;
joins = ({destinationAttribute = id; sourceAttribute =
taskID2; });
name = sourceApprovalTask;
},
{
destination = Task;
isToMany = N;
joinSemantic = EOInnerJoin;
joins = ({destinationAttribute = id; sourceAttribute =
taskID1; });
name = sourceRejectTask;
},
{
destination = Task;
isToMany = N;
joinSemantic = EOInnerJoin;
joins = ({destinationAttribute = id; sourceAttribute =
taskID; });
name = sourceTask;
},
{
destination = TaskType;
isMandatory = Y;
isToMany = N;
joinSemantic = EOInnerJoin;
joins = ({destinationAttribute = id; sourceAttribute =
taskTypeID; });
name = taskType;
},
{
destination = WorkflowTemplate;
isToMany = N;
joinSemantic = EOInnerJoin;
joins = ({destinationAttribute = id; sourceAttribute =
workflowTemplateID; });
name = workflowTemplate;
},
{
destination = Workgroup;
isMandatory = Y;
isToMany = N;
joinSemantic = EOInnerJoin;
joins = ({destinationAttribute = id; sourceAttribute =
workgroupID; });
name = workgroup;
}
);
}
Frederick Wells
MarketForward, a Publicis Groupe Company
427 South LaSalle St.
Chicago, Il 60605
312.220.3056
-----David Avendasora < [email protected] > wrote: -----
To: Fred Wells < [email protected] >
From: David Avendasora < [email protected] >
Date: 05/27/2009 01:53PM
cc: Chuck Hill < [email protected] >, Development
WebObjects < [email protected] >
Subject: Re: lock operation locked more than one row issue!
Hi Fred,
On May 27, 2009, at 2:29 PM, Fred Wells wrote:
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.
Are you saying you looked at the EOModel's plist files?
If not, can you paste the contents of that entity's .plist file
here? You said you had been using Vertical Inheritance at one
point. I have seen stuff get left over in the .plist even when the
Entity Modeler UI doesn't show it.
Dave
Frederick Wells
MarketForward, a Publicis Groupe Company
427 South LaSalle St.
Chicago, Il 60605
312.220.3056
-----Chuck Hill < [email protected] > wrote: -----
To: Guido Neitzer < [email protected] >
From: Chuck Hill < [email protected] >
Date: 05/26/2009 07:18PM
cc: Development WebObjects < [email protected] >,
Fred Wells < [email protected] >
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 protected] )
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/webobjects%40avendasora.com
This email sent to [email protected]
------------------------------------------------------------------------
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.
