Re: qualifier to check for empty toMany
Thanks John,
I'll look into Houdah's
-fw
From: John Huss
To: Fred Wells
Cc: webobjects-dev@lists.apple.com
Date: 05/13/2011 12:13 PM
Subject:Re: qualifier to check for empty toMany
Yeah, that's true, me too. I actually have used the Houdah one more -
it's called ExistsInRelationshipQualifier
If you're not up for fixing Wonder's, you could try that one.
John
On Fri, May 13, 2011 at 12:08 PM, Chuck Hill
wrote:
On May 12, 2011, at 11:49 AM, Alexis Tual wrote:
Le 12 mai 2011 à 19:33, Fred Wells a écrit :
Almost but the SQL that get generated isn't right, any one know a way
around this error?
EvaluateExpression failed:
: Next exception:SQL State:S1000 --
error code: 1011 -- msg: The correlation name 'T1' is specified multiple
times in a FROM clause
Here's my list of qualifiers:
EOQualifier qA =
ERXQ.or(ERXQ.equals("status",Status.startedStatus(editingContext())),ERXQ.equals("status",Status.lateStatus(editingContext())),ERXQ.equals("status",Status.thresholdStatus(editingContext(;
EOQualifier qB = ERXQ.equals("workgroup", user.workgroup());
EOQualifier qC = ERXQ.equals("isActive", strY);
EOQualifier qD = ERXQ.isNull("jobTemplate");
EOQualifier qE = ERXQ.not(new
ERXExistsQualifier(ERXQ.isNotNull("userTasks.taskPkid"), "pkid"));
Hmm I guess you have Task ->> UserTask ... try something like that instead
:
EOQualifier qE = new ERXExistsQualifier(ERXQ.isNotNull(UserTask.ID_KEY),
"userTasks");
This qualifier should fetch all Tasks having some userTasks...the first
argument in ERXExistsQualifier should be optional in this case, but it
doesn't allow a null qualifier...
You should test this first, then try it with your rather big qualifier.
This single qualifier in a fspec "should" generate this SQL :
SELECT ... FROM TASK t0 WHERE EXISTS (SELECT t1.ID FROM USER_TASK t1 WHERE
t1.ID is not NULL AND t1.ID_TASK = t0.ID)
However, I've done a quick test and it generates wrong SQL, something like
:
SELECT ... FROM TASK t0 WHERE EXISTS (SELECT t1.ID FROM USER_TASK t1 WHERE
t1.ID is not NULL AND t1.ID = t0.ID)
So, either i'm doing it wrong or there's a small bug in this qualifier
(generates primary key column instead of foreign key), i've corrected it
in my workspace.
But i'm curious to hear from the others, is there someone else using this
qualifier successfully ?
It looks like a bug to me. I mix the Wonder and Houdah qualifiers, and I
don't recall which one I have used for this in the past or where I used
it.
Chuck
EOQualifier qual8 = ERXQ.and(qA,qB,qC,qD,qE);
From:Alexis Tual
To:John Huss
Cc:Fred Wells ,
webobjects-dev@lists.apple.com
Date:05/11/2011 05:22 PM
Subject:Re: qualifier to check for empty toMany
Hi,
John is right, if you have A ->> B, this should work :
EOQualifier qual = new ERXExistsQualifier( ERXQ.isNotNull(B.A_FK_KEY) ,
A.TO_BS_KEY);
ERXFetchSpecification spec = new
ERXFetchSpecification(A.ENTITY_NAME, qual, null);
(not tested though)
hope it helps
Alex
Le 12 mai 2011 à 00:00, John Huss a écrit :
I think you can do this with ERXExistsQualifier and a Not qualifier.
John
On Wed, May 11, 2011 at 4:29 PM, Fred Wells
wrote:
Hey all,
Maybe I missed something but is there a way to construct a qualifier that
check that a toMany relationship is empty? Simply putting in "toMany =%@,
new NSArray(new Object[] {NSKeyValueCoding.NullValue}doesn't do it because
it tries to check across the join table which results in no objects being
found.
-fw
___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/alexis.tual%40gmail.com
This email sent to alexis.t...@gmail.com
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 (Webobjects-dev@lists.apple.co
Re: qualifier to check for empty toMany
Almost but the SQL that get generated isn't right, any one know a way
around this error?
EvaluateExpression failed:
: Next exception:SQL State:S1000 --
error code: 1011 -- msg: The correlation name 'T1' is specified multiple
times in a FROM clause
Here's my list of qualifiers:
EOQualifier qA =
ERXQ.or(ERXQ.equals("status",Status.startedStatus(editingContext())),ERXQ.equals("status",Status.lateStatus(editingContext())),ERXQ.equals("status",Status.thresholdStatus(editingContext(;
EOQualifier qB = ERXQ.equals("workgroup", user.workgroup());
EOQualifier qC = ERXQ.equals("isActive", strY);
EOQualifier qD = ERXQ.isNull("jobTemplate");
EOQualifier qE = ERXQ.not(new
ERXExistsQualifier(ERXQ.isNotNull("userTasks.taskPkid"), "pkid"));
EOQualifier qual8 = ERXQ.and(qA,qB,qC,qD,qE);
From: Alexis Tual
To: John Huss
Cc: Fred Wells ,
webobjects-dev@lists.apple.com
Date: 05/11/2011 05:22 PM
Subject:Re: qualifier to check for empty toMany
Hi,
John is right, if you have A ->> B, this should work :
EOQualifier qual = new ERXExistsQualifier( ERXQ.isNotNull(B.A_FK_KEY) ,
A.TO_BS_KEY);
ERXFetchSpecification spec = new
ERXFetchSpecification(A.ENTITY_NAME, qual, null);
(not tested though)
hope it helps
Alex
Le 12 mai 2011 à 00:00, John Huss a écrit :
I think you can do this with ERXExistsQualifier and a Not qualifier.
John
On Wed, May 11, 2011 at 4:29 PM, Fred Wells
wrote:
Hey all,
Maybe I missed something but is there a way to construct a qualifier that
check that a toMany relationship is empty? Simply putting in "toMany =%@,
new NSArray(new Object[] {NSKeyValueCoding.NullValue}doesn't do it because
it tries to check across the join table which results in no objects being
found.
-fw
___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/alexis.tual%40gmail.com
This email sent to alexis.t...@gmail.com
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 (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
qualifier to check for empty toMany
Hey all,
Maybe I missed something but is there a way to construct a qualifier that
check that a toMany relationship is empty? Simply putting in "toMany =%@,
new NSArray(new Object[] {NSKeyValueCoding.NullValue}doesn't do it because
it tries to check across the join table which results in no objects being
found.
-fw
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 (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
Re: No Instance Availabe error on download
Cheong, I'm not familiar with the code you're talking about, [stefan's code]. can you sned a link? thanks -fw "Cheong Hee \(Gmail\)" 03/05/2010 01:41 AM To , "Fred Wells" cc Subject Re: No Instance Availabe error on download Hi Fred That is where I am trying to recall - is it due to when you zip all directory of files and after that it was unable to continue when the file size reaches ~30M. The number 30M is quite a familiar number to me :) b'cos it hit me many times before. I have also tried out Stefan's code and it worked fine. I suggest you could look at the code how you keep all the files zip together before calling setContentStream. Just4c now.. Cheers Cheong Hee - Original Message - From: Fred Wells To: webobjects-dev@lists.apple.com Sent: Friday, March 05, 2010 4:58 AM Subject: Re: No Instance Availabe error on download Simon, Cheong, Anjo thanks. So I was able to get it to work after pushing the send/recieve timeout up. So in my attempts to get this to work I was using WOLongResponsePage and it still failed. So was I using that wrong? I created a component that was a subclass of WOLongResponse page and performed my actions in appendToResponse. That included zipping up a directory of files and then passing the stream of that zip to the content stream. Or did I need a combination of both [WOLongResponse and adjusting the send/recieve timeout] to get this to work? -fw Simon 03/03/2010 04:30 PM To Fred Wells cc webobjects-dev@lists.apple.com Subject Re: No Instance Availabe error on download are you using the streaming request handler ? On 3 March 2010 22:24, Fred Wells wrote: > > Hello, > I'm not sure if I missed something, I can't seem to find anything on this > but I can't get files larger than a few MBs to download. I am currently > using > WOResponse.setContentStream and right now with a 29MB file it falls under a > 'No Instance Available' error. Is this broken or is there an alternative? > I'm using 5.3 on IIS. > > Thanks. > -fred > > > 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 (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/simon%40potwells.co.uk > > This email sent to si...@potwells.co.uk > 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/chng34%40gmail.com This email sent to chn...@gmail.com 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. ___
Re: No Instance Availabe error on download
Simon, Cheong, Anjo thanks. So I was able to get it to work after pushing the send/recieve timeout up. So in my attempts to get this to work I was using WOLongResponsePage and it still failed. So was I using that wrong? I created a component that was a subclass of WOLongResponse page and performed my actions in appendToResponse. That included zipping up a directory of files and then passing the stream of that zip to the content stream. Or did I need a combination of both [WOLongResponse and adjusting the send/recieve timeout] to get this to work? -fw Simon 03/03/2010 04:30 PM To Fred Wells cc webobjects-dev@lists.apple.com Subject Re: No Instance Availabe error on download are you using the streaming request handler ? On 3 March 2010 22:24, Fred Wells wrote: > > Hello, > I'm not sure if I missed something, I can't seem to find anything on this > but I can't get files larger than a few MBs to download. I am currently > using > WOResponse.setContentStream and right now with a 29MB file it falls under a > 'No Instance Available' error. Is this broken or is there an alternative? > I'm using 5.3 on IIS. > > Thanks. > -fred > > > 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 (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/simon%40potwells.co.uk > > This email sent to si...@potwells.co.uk > 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: No Instance Availabe error on download
No, I am not maybe I'm missing something but isn't my problem in the response not the request? thanks. -fw Simon 03/03/2010 04:30 PM To Fred Wells cc webobjects-dev@lists.apple.com Subject Re: No Instance Availabe error on download are you using the streaming request handler ? On 3 March 2010 22:24, Fred Wells wrote: > > Hello, > I'm not sure if I missed something, I can't seem to find anything on this > but I can't get files larger than a few MBs to download. I am currently > using > WOResponse.setContentStream and right now with a 29MB file it falls under a > 'No Instance Available' error. Is this broken or is there an alternative? > I'm using 5.3 on IIS. > > Thanks. > -fred > > > 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 (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/simon%40potwells.co.uk > > This email sent to si...@potwells.co.uk > 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
No Instance Availabe error on download
Hello, I'm not sure if I missed something, I can't seem to find anything on this but I can't get files larger than a few MBs to download. I am currently using WOResponse.setContentStream and right now with a 29MB file it falls under a 'No Instance Available' error. Is this broken or is there an alternative? I'm using 5.3 on IIS. Thanks. -fred 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: DirectAction with cookies and session
Doh! I needed to add the session id through SWFUpload post params not through directActionURLForActionNamed's query dictionary. thanks. -fw Chuck Hill 09/21/2009 09:53 PM To Fred Wells cc webobjects-dev@lists.apple.com Subject Re: DirectAction with cookies and session On Sep 21, 2009, at 1:19 PM, Fred Wells wrote: > > Hello, > If I missed this I apologize but I can't seem to find anything on > this. I'm trying to test out SWFUpload within one of my WO apps. > It is currently set up to store sessionID in cookies. SWFUpload > needs a post-upload URL for processing, I need the session > information to be > available to that URL. How are you making the URL? Cookies should be OK. Or the URL can have ?wosid= > I can't seem to get DirectAction to 'isSessionIDInRequest' always > comes up false and 'sessionID' always is null. I've tried > constructing the URL through WOActionURL and > 'directActionURLForActionNamed'. WOActionURL? WOContext you mean? If you are doing this in Java, WOContext.directActionURLForActionNamed should do what you want. > Both make a [what looks like] a valid directaction URL. > But when sent it never finds the session from the cookie. Is there > something else I have to do when trying to use a DirectAction in a > session? Log out the request headers. Is the cookie in there? Chuck -- Chuck Hill Senior Consultant / VP Development Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
DirectAction with cookies and session
Hello, If I missed this I apologize but I can't seem to find anything on this. I'm trying to test out SWFUpload within one of my WO apps. It is currently set up to store sessionID in cookies. SWFUpload needs a post-upload URL for processing, I need the session information to be available to that URL. I can't seem to get DirectAction to 'isSessionIDInRequest' always comes up false and 'sessionID' always is null. I've tried constructing the URL through WOActionURL and 'directActionURLForActionNamed'. Both make a [what looks like] a valid directaction URL. But when sent it never finds the session from the cookie. Is there something else I have to do when trying to use a DirectAction in a session? thanks. -fw 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Fred Wells is out of the office.
I will be out of the office starting 06/26/2009 and will not return until 07/01/2009. I will respond to your message when I return. 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: lock operation locked more than one row issue! -- SOLVED
I'm glad to hear I'm not the only one with the chain of MSSQLServer around
my neck!
I won't be WOWODC west, maybe at east.
thanks again and I'm downloading Chuck's MSSQLServerPlugIn right now.
-fw
David Avendasora
05/28/2009 05:21 AM
To
Fred Wells
cc
Development WebObjects
Subject
Re: lock operation locked more than one row issue! -- SOLVED
Hi Fred
Glad to hear that you have everything working!
On May 27, 2009, at 7:07 PM, Fred Wells wrote:
Two things, for some reason I thought that checking 'Generate source' in
the Table view also was for the columns as well, not so. Also I'm not sure
where the prototypes are from but the ones that just show up in Entity
Modeler have some issues specifically with the number prototypes. Anyway
after clearing those out and getting the data types to show up correctly
everything is on.
You must have the ERPrototypes framework added to your classpath. This is
what provides all the various prototypes. If you look in your DB config,
there's a place you can select the set of Prototypes you want to use. The
problem is that there isn't one that is specifically for MSSQLServer.
I've created my own prototypes. It is simple to do and will make your life
much easier in the future - and will keep Chuck from calling you stupid at
WOWODC. :-)
1) Take ERPrototypes out of your project's build path.
2) Create an entity in your Model called "EOJDBCPrototypes" then add an
attribute for each prototype you want.
I'd even use the same names as the WOnder ones you were using, just change
the external type to match SQLServer's. For example, I use NVARCHAR
instead of VARCHAR beause it is MSSQLServer's data type that can store
unicode strings without conversion.
At some point we should add MSSQLServer prototypes to ERPrototypes, I'll
look into it after WOWODC. Any chance you are going to be there?
thanks everybody.
Those of us afflicted with MSSQLServer need to stick together. Thankfully
Chuck is so afflicted (ha ha Chuck!).
I find using MSSQLServer with WebObjects to be similar to Vertical
Inheritance in that it should work in theory and usually does at first,
but then the more you dig into it you start to find things that just don't
work quite as you'd expect and since most people on the list don't use it,
there are obscure bugs lurking waiting to bite you.
If you are not using Chuck's MSSQLServerPlugIn, You will want to,
otherwise you are going to end up with intermittent FK-constraint errors.
Even if you haven't yet, you will. Use it.
You can find it here:
http://www.gvcsitemaker.com/chill/ms_sql_server_eof_plugin
Dave
-fw
Frederick Wells
MarketForward, a Publicis Groupe Company
427 South LaSalle St.
Chicago, Il 60605
312.220.3056
-David Avendasora wrote: -
To: Fred Wells
From: David Avendasora
Date: 05/27/2009 03:33PM
cc: Development WebObjects
Subject: Re: lock operation locked more than one row issue!
What ERPrototypes are you using? There is no set of MSSQLServer
Prototypes, and the JDBC define java.lang.Integer attributes (id,
intNumber, intBoolean, etc) as having an external type of INTEGER, which
is not what SQL Server calls an Integer data type. It uses 'int'.
Maybe that's it?
Dave
On May 27, 2009, at 3:18 PM, Fred Wells wrote:
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;
Re: lock operation locked more than one row issue! -- SOLVED
Two things, for some reason I thought that checking 'Generate source' in the Table view also was for the columns as well, not so. Also I'm not sure where the prototypes are from but the ones that just show up in Entity Modeler have some issues specifically with the number prototypes. Anyway after clearing those out and getting the data types to show up correctly everything is on. thanks everybody.-fwFrederick WellsMarketForward, a Publicis Groupe Company427 South LaSalle St.Chicago, Il 60605312.220.3056-David Avendasora wrote: -To: Fred Wells From: David Avendasora Date: 05/27/2009 03:33PMcc: Development WebObjects Subject: Re: lock operation locked more than one row issue!What ERPrototypes are you using? There is no set of MSSQLServer Prototypes, and the JDBC define java.lang.Integer attributes (id, intNumber, intBoolean, etc) as having an external type of INTEGER, which is not what SQL Server calls an Integer data type. It uses 'int'.
Maybe that's it?Dave
On May 27, 2009, at 3:18 PM, Fred Wells wrote:
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 =
Re: lock operation locked more than one row issue!
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 WellsMarketForward, a Publicis Groupe Company427 South LaSalle St.Chicago, Il 60605312.220.3056-David Avendasora wrote: -To: Fred Wells From: David Avendasora Date: 05/27/2009 01:53PMcc: Chuck Hill , Development WebObjects 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 WellsMarketForward, a Publicis Groupe Company427 South LaSalle St.Chicago, Il 60605312.220.3056-Chuck Hill <
ch...@global-village.net
> wrote: -To: Guido Neitzer <
guido.neit...@gmail.com
>From: Chuck Hill <
ch...@global-village.net
>Date: 05/26/2009 07:18PMcc: Development WebObjects <
webobjects-dev@lists.apple.com
>, Fred Wells <
fred.we...@marketforward.com
>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, a
Re: lock operation locked more than one row issue!
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.Frederick WellsMarketForward, a Publicis Groupe Company427 South LaSalle St.Chicago, Il 60605312.220.3056-Chuck Hill wrote: -To: Guido Neitzer From: Chuck Hill Date: 05/26/2009 07:18PMcc: Development WebObjects , Fred Wells 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 DevelopmentCome 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: lock operation locked more than one row issue!
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 WellsMarketForward, a Publicis Groupe Company427 South LaSalle St.Chicago, Il 60605312.220.3056-Chuck Hill wrote: -To: Fred Wells From: Chuck Hill Date: 05/26/2009 10:34AMcc: webobjects-dev@lists.apple.comSubject: 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.ChuckOn 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 wrote: ->> To: Fred Wells > From: Chuck Hill > Date: 05/21/2009 05:17PM> cc: webobjects-dev@lists.apple.com> 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 (Webobjects-dev@lists.apple.com)> > Help/Unsubscribe/Update your Subscription:> > http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net> >> > This email sent to ch...@global-village.net>> -- > 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 DevelopmentCome to WOWODC'09 in San Fran this June!http://www.wocommunity.org/wowodc09/ Disclaimer The information in this email and any attachment
Re: lock operation locked more than one row issue!
I did initially use vertical inheritance as part of my troubleshooting process I took it out. I still get the same results.Frederick WellsMarketForward, a Publicis Groupe Company427 South LaSalle St.Chicago, Il 60605312.220.3056-Chuck Hill wrote: -To: Fred Wells From: Chuck Hill Date: 05/21/2009 05:17PMcc: webobjects-dev@lists.apple.comSubject: 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 (Webobjects-dev@lists.apple.com)> Help/Unsubscribe/Update your Subscription:> http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net>> This email sent to ch...@global-village.net-- Chuck Hill Senior Consultant / VP DevelopmentCome 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
lock operation locked more than one row issue!
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 WellsMarketForward, a Publicis Groupe Company427 South LaSalle St.Chicago, Il 60605312.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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: webobjects installer crashing - SOLVED
OK, So re-installing GraphKit.pkg by using Pacifist fixed that issue. It wasn't WebObjects issue. sorry throw it in the wrong list.Don, John thanks for help!Frederick WellsMarketForward, a Publicis Groupe Company427 South LaSalle St.Chicago, Il 60605312.220.3056-John Ours wrote: -To: Fred Wells From: John Ours Date: 01/22/2009 07:36PMcc: Don Lindsay , webobjects-dev@lists.apple.comSubject: Re: webobjects installer crashingI've seen this once before and IIRC it's not specific to WO. I believe it was from an old (bad?) install of GraphKit.See:http://discussions.apple.com/thread.jspa?threadID=1206377andhttp://forums.macosxhints.com/showthread.php?p=464643On Jan 22, 2009, at 7:30 PM, Fred Wells wrote:> Process: Installer [2148]> Path: /System/Library/CoreServices/Installer.app/Contents/ > MacOS/Installer> Identifier: com.apple.installer> Version: ??? (???)> Build Info: Installer-281~1> Code Type: X86 (Native)> Parent Process: launchd [86]>> Date/Time: 2009-01-21 22:54:08.231 -0600> OS Version: Mac OS X 10.5.5 (9F33)> Report Version: 6>> Exception Type: EXC_BREAKPOINT (SIGTRAP)> Exception Codes: 0x0002, 0x> Crashed Thread: 0>> Dyld Error Message:> Symbol not found: _GRAxesXAxisWindowSize> Referenced from: /System/Library/CoreServices/Installer.app/ > Contents/MacOS/Installer> Expected in: /System/Library/PrivateFrameworks/GraphKit.framework/ > Versions/A/GraphKit>>> Frederick Wells> MarketForward, a Publicis Groupe Company> 427 South LaSalle St.> Chicago, Il 60605> 312.220.3056>> -Don Lindsay wrote: ->> To: Fred Wells > From: Don Lindsay > Date: 01/21/2009 11:29PM> cc: webobjects-dev@lists.apple.com> Subject: Re: webobjects installer crashing>> Hello;>> Are you installing all of XCode or only the WebObject.mpkg? I have > installed and ran XCode 3.0 in 10.5. The patch level I have now is > 10.5.6. Do you have an error code or are there any messages in the > Console.app?>> Don> On Jan 22, 2009, at 12:01 AM, Fred Wells wrote:>>> On OS X 10.5.5 and 10.5.6 using Xcode tools 3.0 and 3.1 the >> installer crashes. I realize that I have to use WOLips and Eclipse >> but I STILL need WebObject packages and none of the installers seem >> to work. I trying to see if anyone else is have this issue. Seeing >> as I have seen this across three different computers.>>>> -fw>>>>>> Frederick Wells>> MarketForward, a Publicis Groupe Company>> 427 South LaSalle St.>> Chicago, Il 60605>> 312.220.3056>>>> -Don Lindsay < pccd...@mac.com > wrote: ->>>> To: Fred Wells < fred.we...@marketforward.com >>> From: Don Lindsay < pccd...@mac.com >>> Date: 01/21/2009 09:22AM>> cc: webobjects-dev@lists.apple.com>> Subject: Re: webobjects installer crashing>>>> Hello;>>>> What OS X version are you running? WebObjects Apple tools were >> depricated and will not run on OS X 10.5, you have to use Eclipse >> and WOLips to develop on 10.5>>>> Don>> On Jan 21, 2009, at 10:08 AM, Fred Wells wrote:>>>>> I started with developer tools 3.1 actually and that tried to >>> open and crashed I then grabbed the webobjects 5.4.1 and 5.4.3 >>> updates and they both reacted the same way. All of these came from >>> developer connection site.>>>>>> -fw>>>>>> Frederick Wells>>> MarketForward, a Publicis Groupe Company>>> 427 South LaSalle St.>>> Chicago, Il 60605>>> 312.220.3056>>>>>> -Don Lindsay wrote: ->>>>>> To: Fred Wells >>> From: Don Lindsay >>> Date: 01/20/2009 08:33PM>>> cc: webobjects-dev@lists.apple.com>>> Subject: Re: webobjects installer crashing>>>>>> Hello;>>>>>> Can you give us a bit more information? What installer are you >>> using? Where did you download it from?>>>>>> Thanks,>>>>>> Don>>> On Jan 20, 2009, at 2:19 PM, Fred Wells wrote:>>>>>>> I am trying to install webobjects 5.4 on a mac mini running >>>> 10.5.6 the install won't stay up it tries to start and then just >>>> crashes. I've tried also on a black macbook same OS same results. >>>> Anybody see this?>>>>>>>> -fw>>>>>>>>>>>> Frederick Wells>>>> MarketForward, a Publicis Groupe Company>>>> 427 South LaSa
Re: webobjects installer crashing
Process: Installer [2148]Path: /System/Library/CoreServices/Installer.app/Contents/MacOS/InstallerIdentifier: com.apple.installerVersion: ??? (???)Build Info: Installer-281~1Code Type: X86 (Native)Parent Process: launchd [86]Date/Time: 2009-01-21 22:54:08.231 -0600OS Version: Mac OS X 10.5.5 (9F33)Report Version: 6Exception Type: EXC_BREAKPOINT (SIGTRAP)Exception Codes: 0x0002, 0xCrashed Thread: 0Dyld Error Message: Symbol not found: _GRAxesXAxisWindowSize Referenced from: /System/Library/CoreServices/Installer.app/Contents/MacOS/Installer Expected in: /System/Library/PrivateFrameworks/GraphKit.framework/Versions/A/GraphKitFrederick WellsMarketForward, a Publicis Groupe Company427 South LaSalle St.Chicago, Il 60605312.220.3056-Don Lindsay wrote: -To: Fred Wells From: Don Lindsay Date: 01/21/2009 11:29PMcc: webobjects-dev@lists.apple.comSubject: Re: webobjects installer crashingHello; Are you installing all of XCode or only the WebObject.mpkg? I have installed and ran XCode 3.0 in 10.5. The patch level I have now is 10.5.6. Do you have an error code or are there any messages in the Console.app? DonOn Jan 22, 2009, at 12:01 AM, Fred Wells wrote: On OS X 10.5.5 and 10.5.6 using Xcode tools 3.0 and 3.1 the installer crashes. I realize that I have to use WOLips and Eclipse but I STILL need WebObject packages and none of the installers seem to work. I trying to see if anyone else is have this issue. Seeing as I have seen this across three different computers.-fwFrederick WellsMarketForward, a Publicis Groupe Company427 South LaSalle St.Chicago, Il 60605312.220.3056-Don Lindsay < pccd...@mac.com > wrote: -----To: Fred Wells < fred.we...@marketforward.com >From: Don Lindsay < pccd...@mac.com >Date: 01/21/2009 09:22AMcc: webobjects-dev@lists.apple.com Subject: Re: webobjects installer crashingHello; What OS X version are you running? WebObjects Apple tools were depricated and will not run on OS X 10.5, you have to use Eclipse and WOLips to develop on 10.5 DonOn Jan 21, 2009, at 10:08 AM, Fred Wells wrote: I started with developer tools 3.1 actually and that tried to open and crashed I then grabbed the webobjects 5.4.1 and 5.4.3 updates and they both reacted the same way. All of these came from developer connection site.-fwFrederick WellsMarketForward, a Publicis Groupe Company427 South LaSalle St.Chicago, Il 60605312.220.3056-Don Lindsay wrote: -To: Fred Wells From: Don Lindsay Date: 01/20/2009 08:33PMcc: webobjects-dev@lists.apple.com Subject: Re: webobjects installer crashingHello; Can you give us a bit more information? What installer are you using? Where did you download it from? Thanks, DonOn Jan 20, 2009, at 2:19 PM, Fred Wells wrote: I am trying to install webobjects 5.4 on a mac mini running 10.5.6 the install won't stay up it tries to start and then just crashes. I've tried also on a black macbook same OS same results. Anybody see this?-fwFrederick WellsMarketForward, a Publicis Groupe Company427 South LaSalle St.Chicago, Il 60605312.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 ( Webobjects-dev@lists.apple.com )Help/Unsubscribe/Update your Subscription:http://lists.apple.com/mailman/options/webobjects-dev/pccdonl%40mac.com This email sent to pccd...@mac.com 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. Disclaimer The information in this email and any attachments
Re: webobjects installer crashing
On OS X 10.5.5 and 10.5.6 using Xcode tools 3.0 and 3.1 the installer crashes. I realize that I have to use WOLips and Eclipse but I STILL need WebObject packages and none of the installers seem to work. I trying to see if anyone else is have this issue. Seeing as I have seen this across three different computers.-fwFrederick WellsMarketForward, a Publicis Groupe Company427 South LaSalle St.Chicago, Il 60605312.220.3056-Don Lindsay wrote: -To: Fred Wells From: Don Lindsay Date: 01/21/2009 09:22AMcc: webobjects-dev@lists.apple.comSubject: Re: webobjects installer crashingHello; What OS X version are you running? WebObjects Apple tools were depricated and will not run on OS X 10.5, you have to use Eclipse and WOLips to develop on 10.5 DonOn Jan 21, 2009, at 10:08 AM, Fred Wells wrote: I started with developer tools 3.1 actually and that tried to open and crashed I then grabbed the webobjects 5.4.1 and 5.4.3 updates and they both reacted the same way. All of these came from developer connection site.-fwFrederick WellsMarketForward, a Publicis Groupe Company427 South LaSalle St.Chicago, Il 60605312.220.3056-Don Lindsay wrote: -To: Fred Wells From: Don Lindsay Date: 01/20/2009 08:33PMcc: webobjects-dev@lists.apple.com Subject: Re: webobjects installer crashingHello; Can you give us a bit more information? What installer are you using? Where did you download it from? Thanks, DonOn Jan 20, 2009, at 2:19 PM, Fred Wells wrote: I am trying to install webobjects 5.4 on a mac mini running 10.5.6 the install won't stay up it tries to start and then just crashes. I've tried also on a black macbook same OS same results. Anybody see this?-fwFrederick WellsMarketForward, a Publicis Groupe Company427 South LaSalle St.Chicago, Il 60605312.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 ( Webobjects-dev@lists.apple.com )Help/Unsubscribe/Update your Subscription:http://lists.apple.com/mailman/options/webobjects-dev/pccdonl%40mac.com This email sent to pccd...@mac.com 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. 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: webobjects installer crashing
I started with developer tools 3.1 actually and that tried to open and crashed I then grabbed the webobjects 5.4.1 and 5.4.3 updates and they both reacted the same way. All of these came from developer connection site.-fwFrederick WellsMarketForward, a Publicis Groupe Company427 South LaSalle St.Chicago, Il 60605312.220.3056-Don Lindsay wrote: -To: Fred Wells From: Don Lindsay Date: 01/20/2009 08:33PMcc: webobjects-dev@lists.apple.comSubject: Re: webobjects installer crashingHello; Can you give us a bit more information? What installer are you using? Where did you download it from? Thanks, DonOn Jan 20, 2009, at 2:19 PM, Fred Wells wrote: I am trying to install webobjects 5.4 on a mac mini running 10.5.6 the install won't stay up it tries to start and then just crashes. I've tried also on a black macbook same OS same results. Anybody see this?-fwFrederick WellsMarketForward, a Publicis Groupe Company427 South LaSalle St.Chicago, Il 60605312.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 ( Webobjects-dev@lists.apple.com )Help/Unsubscribe/Update your Subscription:http://lists.apple.com/mailman/options/webobjects-dev/pccdonl%40mac.com This email sent to pccd...@mac.com 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
webobjects installer crashing
I am trying to install webobjects 5.4 on a mac mini running 10.5.6 the install won't stay up it tries to start and then just crashes. I've tried also on a black macbook same OS same results. Anybody see this?-fwFrederick WellsMarketForward, a Publicis Groupe Company427 South LaSalle St.Chicago, Il 60605312.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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Fred Wells is out of the office.
I will be out of the office starting Thu 06/26/2008 and will not return until Mon 06/30/2008. I will respond to your message when I return. 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: using null in a fetchspec
chuck,thanks, ERXToManyQualifier was what I was looking for. I keep forgetting to dig into Wonder.-fwFrederick WellsMarketForward, a Publicis Groupe Company427 South LaSalle St.Chicago, Il 60605312.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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
using null in a fetchspec
Hello all,I can't seem to find any info on this and can't get this to work. Is there a way to have null be a qualifier in a fetchspec?Basically, I want to have something like users = null or something. I need to check if an attribute doesn't have a value. For add'l info I am trying to do this on a to-many relationship. thanks-fwFrederick WellsMarketForward, a Publicis Groupe Company427 South LaSalle St.Chicago, Il 60605312.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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
WOWebServiceRegistrar.registerWebService not working at all
So I have been banging my head against this for two days now with no progress. I need tom implement a simple WebService provider. I keep getting this error. [2008-03-20 17:01:02 CDT] java.lang.AbstractMethodError: com.webobjects.webservices.support.WOXMLProvider.getRoles()Ljava/util/List; at org.apache.axis.AxisEngine.refreshGlobalOptions(AxisEngine.java:502) at com.webobjects.webservices.support.WOXMLProvider.doConfigureEngine(WOXMLProvider.java:94)I have tried several different versions of axis and they all give this same error. My deets are:WO 5.3.3OSX 10.4.11Eclipse 3.2.2The thing that I think is a little weird I went back to basics to and started with the Calculator example in Xcode[2.4] and that works when I have the right axis.jar installed [1.1 i think] but that the only thing that i can get working. I barely have a grasp of SOAP and webservices and this stuff is making my head spin. I can't seem to find any relevant info on and of the boards.-fwFrederick WellsMarketForward, a Publicis Groupe Company427 South LaSalle St.Chicago, Il 60605312.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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: Reflexive Many-To-Many won't budge
I am not doing any inheritance in this particular situation objects need to be aware of other objects. There is no difference in them [i.e person:, employee, manager instead task: previous, next]. 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 legally privileged, 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Reflexive Many-To-Many won't budge
Hello all,
I am trying to get a reflexive many to many relationship to work and it
won't budge. I have read through all of th previous postings on this and
nothing gives an definitive answer on this and my attempts to follow what
had been put up still hasn't worked for me. When trying to add to the
relationship through addObjectsToBoth... I get this error with one side of
the relationship:
java.lang.IllegalStateException: A valid global ID could not be obtained
for entity named TaskToTask, relationship named previousTasks, primary key
dictionary {previousTaskPkid = 4; }.
at
com.webobjects.eoaccess.EODatabaseContext.databaseOperationForIntermediateRowFromSourceObject(
EODatabaseContext.java:5061)
at
com.webobjects.eoaccess.EODatabaseContext.recordInsertForIntermediateRowFromSourceObject(
EODatabaseContext.java:5077)
at
com.webobjects.eoaccess.EODatabaseContext.relayAttributesInRelationshipSourceObjectDestinationObject(
EODatabaseContext.java:5103)
as you can see it only has the one primary key in the dictionary
[relevant?].
If I try the reverse of the relationship it doesn't error out but it also
doesn't put anything in the DB it just seems to ignore it. I must be
missing something very basic. I have set up the many-to-many like any of
the other m-t-m 's I have that are across two tables. Those workj
flawlessly but this won't do anything.
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 legally
privileged, 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 (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
