Re: Getting the SQL while running from eclipse

From: James Cicenia (jame..imijon.com)
Date: Mon Nov 08 2004 - 20:56:19 EST

  • Next message: Chuck Hill: "Re: Getting the SQL while running from eclipse"

    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 chil..lobal-village.net
    > Global Village Consulting Inc.
    > http://www.global-village.net
    >

    This archive was generated by hypermail 2.0.0 : Mon Nov 08 2004 - 20:56:23 EST