Re: Getting the SQL while running from eclipse
Re: Getting the SQL while running from eclipse
- Subject: Re: Getting the SQL while running from eclipse
- From: Chuck Hill <email@hidden>
- Date: Mon, 08 Nov 2004 18:15:29 -0800
Its not your qualifiers, you've just typed it in wrong. Take them all out.
Add back one. Run. I just tried it. It works, trust me.
Chuck
At 07:56 PM 08/11/2004 -0600, James Cicenia wrote:
>nothing... it's set in both places..
>
>Is there a way I can just get the sql my one fetch spec is creating?
>
>I am nesting a large or with an and and the results are not what
>I am expecting
>
>
>
>
>
>
>EOQualifier myQualifier1;
> NSMutableArray args1 = new NSMutableArray();
> args1.addObject("projectState.lifeCycleState");
> args1.addObject(pLifeCycle);
> myQualifier1 = EOQualifier.qualifierWithQualifierFormat("%@ = %@",
>args1);
>
> EOQualifier myQualifier2;
> NSMutableArray args2 = new NSMutableArray();
> args2.addObject("portfolio");
> args2.addObject(portfolio);
> myQualifier2 = EOQualifier.qualifierWithQualifierFormat("%@ = %@",
>args2);
>
> EOQualifier myQualifier3;
> NSMutableArray args3 = new NSMutableArray();
> args3.addObject("rosterMembers.resource.tosuser");
> args3.addObject( this);
> myQualifier3 = EOQualifier.qualifierWithQualifierFormat("%@ = %@",
>args3);
>
> EOQualifier myQualifier4;
> NSMutableArray args4 = new NSMutableArray();
> args4.addObject("assignedProjectManager.tosuser");
> args4.addObject( this);
> myQualifier4 = EOQualifier.qualifierWithQualifierFormat("%@ = %@",
>args4);
>
> EOQualifier myQualifier5;
> NSMutableArray args5 = new NSMutableArray();
> args5.addObject("sponsor.tosuser");
> args5.addObject( this);
> myQualifier5 = EOQualifier.qualifierWithQualifierFormat("%@ = %@",
>args5);
>
> EOQualifier myQualifier6;
> NSMutableArray args6 = new NSMutableArray();
> args6.addObject("submitter.tosuser");
> args6.addObject( this);
> myQualifier6 = EOQualifier.qualifierWithQualifierFormat("%@ = %@",
>args6);
>
> EOOrQualifier orQualifier =
> new EOOrQualifier(
> new NSArray(
> new Object[] {
> myQualifier3,
> myQualifier4,
> myQualifier5,
> myQualifier6}));
>
> EOAndQualifier andQualifier =
> new EOAndQualifier(
> new NSArray(
> new Object[] {
> myQualifier1,
> myQualifier1}));
>
> EOAndQualifier andQualifier1 =
> new EOAndQualifier(
> new NSArray(
> new Object[] {
> andQualifier,
> orQualifier}));
>
> EOFetchSpecification fs = new
>EOFetchSpecification("PortfolioProject",andQualifier1,null);
>
>
>
>On Nov 8, 2004, at 7:35 PM, Chuck Hill wrote:
>
>> Same way as ever. In the run config add -EOAdaptorDebugEnabled=true on
>> either the Arguments or WO tab.
>>
>> Chuck
>>
>>
>> At 07:00 PM 08/11/2004 -0600, James Cicenia wrote:
>>> Hello -
>>>
>>> I can't for the life of me figure out how to see the generated SQL for
>>> a fetch specification I wrote.
>>>
>>> My qualifiers all look good so now I need to see the sql. Is there an
>>> easy way to System.out it?
>>> I have set all the debugs to true in Eclipse's WO and EO Arguments.
>>>
>>> Nothing is being displayed to the console.
>>>
>>> -James
>>>
>>>
>>
>>
>>
>> --
>>
>> Chuck Hill email@hidden
>> Global Village Consulting Inc.
>> http://www.global-village.net
>>
>
>
--
Chuck Hill email@hidden
Global Village Consulting Inc. http://www.global-village.net
_______________________________________________
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