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: James Cicenia <email@hidden>
- Date: Mon, 8 Nov 2004 19:56:19 -0600
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
_______________________________________________
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