Re: Getting the SQL while running from eclipse

From: James Cicenia (jame..imijon.com)
Date: Mon Nov 08 2004 - 21:44:37 EST

  • Next message: Anders Peterson: "Re: Getting the SQL while running from eclipse"

    Wow... don't know... when I put NSLog.out.prinln("test").. it goes to
    my console.
    Though nothing I can see overrides the debug enabled. I have noticed
    that
    when I click "change" in Eclipse I don't get what is expected. It gives
    me the
    value on the first line and the second is blank. I think something is
    fishy
    with my wolips.

    Maybe I will just run it in the monitor.

    James

    On Nov 8, 2004, at 8:31 PM, Chuck Hill wrote:

    > Open the run config. Go to the Arguments tab. Add
    >
    > -DEOAdaptorDebugEnabled=true
    >
    > (copy and paste that)
    >
    > Run. If you don't see SQL:
    >
    > 1. Some other place you have added it is overriding this (correct)
    > setting
    > 2. You are redirecting NSLog output somewhere other than the console.
    > No,
    > I don't know how you did that. :-)
    >
    >
    > Chuck
    >
    >
    >>>>> on
    >>>>> either the Arguments or WO tab.
    >
    > At 08:23 PM 08/11/2004 -0600, you wrote:
    >> Sorry it doesn't... that was a second attempt and I see its typo, the
    >> myQualifier1 twice..
    >>
    >> However, I am certainly not getting back what I can visually see in my
    >> data.
    >> I can definitely debug sql, if I can only see it. :(
    >>
    >> -James
    >>
    >>
    >>
    >>
    >> On Nov 8, 2004, at 8:15 PM, Chuck Hill wrote:
    >>
    >>> 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 chil..lobal-village.net
    >>>>> Global Village Consulting Inc.
    >>>>> http://www.global-village.net
    >>>>>
    >>>>
    >>>>
    >>>
    >>> --
    >>>
    >>> Chuck Hill chil..lobal-village.net
    >>> Global Village Consulting Inc.
    >>> http://www.global-village.net
    >>>
    >>
    >>
    >
    > --
    >
    > 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 - 21:44:41 EST