Hi,
What is the best way to take a peek at the SQL in a model right before
it is run?
I am getting a
"[java.sql.SQLException: ORA-00923: FROM keyword not found where
expected"
error, and I would like to track it down.
Thanks,
John
I have seen references to this QueryModelBase, but can't seem to find
it in JATO. Am I looking in the wrong place?
John Hoskins
In <a href="/group/SunONE-JATO/post?protectID=246075234167171124217231170221059165026 048139046">SunONE-JATO@y...</a>, Matthew Stevens <<a href="/group/SunONE-JATO/post?protectID=029166114165042198028082000056130080177 026031196184130152150">matthew.stevens@E...</a>> wrote:
> Also, check out the <QueryModelBase> JavaDocs for
>
> setTraceSQL()
> getSQL()
> beforeExecute()
>
>
> jhoskins wrote:
>
> > Hi,
> > What is the best way to take a peek at the SQL in a model right before
> > it is run?
> > I am getting a
> > "[java.sql.SQLException: ORA-00923: FROM keyword not found where
> > expected"
> > error, and I would like to track it down.
> >
> > Thanks,
> > John
> >
> >
> >
> > To download the latest version of JATO, please visit:
> > <a href="http://www.sun.com/software/download/developer/5102.html">http://www.s un.com/software/download/developer/5102.html</a>
> >
> > For more information about JATO, please visit:
> > <a href="http://developer.iplanet.com/tech/appserver/framework/index.jsp">http: //developer.iplanet.com/tech/appserver/framework/index.jsp</a>
> >
> >
> >
> >
> >
What do you mean you see references in QueryModelBase, but don't find it
in "JATO". QueryModelBase is part of JATO.
Can you clarify what you mean?
c
jhoskins wrote:
>I have seen references to this QueryModelBase, but can't seem to find
>it in JATO. Am I looking in the wrong place?
>John Hoskins
> In <a href="/group/SunONE-JATO/post?protectID=246075234167171124217231170221059165026 048139046">SunONE-JATO@y...</a>, Matthew Stevens <<a href="/group/SunONE-JATO/post?protectID=029166114165042198028082000056130080177 026031196184130152150">matthew.stevens@E...</a>> wrote:
>
>>Also, check out the <QueryModelBase> JavaDocs for
>>
>>setTraceSQL()
>>getSQL()
>>beforeExecute()
>>
>>
>>jhoskins wrote:
>>
>>>Hi,
>>>What is the best way to take a peek at the SQL in a model right before
>>>it is run?
>>>I am getting a
>>>"[java.sql.SQLException: ORA-00923: FROM keyword not found where
>>>expected"
>>>error, and I would like to track it down.
>>>
>>>Thanks,
>>>John
>>>
>>>
>>>
>>>To download the latest version of JATO, please visit:
>>><a href="http://www.sun.com/software/download/developer/5102.html">http://www.s un.com/software/download/developer/5102.html</a>
>>>
>>>For more information about JATO, please visit:
>>><a href="http://developer.iplanet.com/tech/appserver/framework/index.jsp">http: //developer.iplanet.com/tech/appserver/framework/index.jsp</a>
>>>
>>>
>>>
>
>>>
>>>
>
>
>
>To download the latest version of JATO, please visit:
><a href="http://www.sun.com/software/download/developer/5102.html">http://www.s un.com/software/download/developer/5102.html</a>
>
>For more information about JATO, please visit:
><a href="http://developer.iplanet.com/tech/appserver/framework/index.jsp">http: //developer.iplanet.com/tech/appserver/framework/index.jsp</a>
>
>
>
>
Never mind.
What I meant was, I had seen discussions about QueryModelBase in the
forums, but couldn't find it in the Javadoc. Of course this morning I
go looking again, and it pops right up. Guess the error is in the chair.
BTW, I found another way to peek at the SQL before it executes.
In the beforeExecute(..., String sql) of the Model, I can just spit
out the sql. I don't think I would want to try and manipulate it
there. I want to alter it based on which TiledView I'm calling the
model from.
Thanks,
John
In <a href="/group/SunONE-JATO/post?protectID=246075234167171124217231170221059165026 048139046">SunONE-JATO@y...</a>, "Craig V. Conover" <<a href="/group/SunONE-JATO/post?protectID=219212113009229091025149066024064239039 098031046209130">craig.conover@s...</a>> wrote:
> What do you mean you see references in QueryModelBase, but don't
find it
> in "JATO". QueryModelBase is part of JATO.
> Can you clarify what you mean?
> c
>
>
> jhoskins wrote:
>
> >I have seen references to this QueryModelBase, but can't seem to find
> >it in JATO. Am I looking in the wrong place?
> >John Hoskins
> > In <a href="/group/SunONE-JATO/post?protectID=246075234167171124217231170221059165026 048139046">SunONE-JATO@y...</a>, Matthew Stevens <<a href="/group/SunONE-JATO/post?protectID=029166114165042198028082000056130080177 026031196184130152150">matthew.stevens@E...</a>> wrote:
> >
> >>Also, check out the <QueryModelBase> JavaDocs for
> >>
> >>setTraceSQL()
> >>getSQL()
> >>beforeExecute()
> >>
> >>
> >>jhoskins wrote:
> >>
> >>>Hi,
> >>>What is the best way to take a peek at the SQL in a model right
before
> >>>it is run?
> >>>I am getting a
> >>>"[java.sql.SQLException: ORA-00923: FROM keyword not found where
> >>>expected"
> >>>error, and I would like to track it down.
> >>>
> >>>Thanks,
> >>>John
> >>>
> >>>
> >>>
> >>>To download the latest version of JATO, please visit:
> >>><a href="http://www.sun.com/software/download/developer/5102.html">http://www.s un.com/software/download/developer/5102.html</a>
> >>>
> >>>For more information about JATO, please visit:
> >>><a href="http://developer.iplanet.com/tech/appserver/framework/index.jsp">http: //developer.iplanet.com/tech/appserver/framework/index.jsp</a>
> >>>
> >>>
> >>>
> >
> >>>
> >>>
> >
> >
> >
> >To download the latest version of JATO, please visit:
> ><a href="http://www.sun.com/software/download/developer/5102.html">http://www.s un.com/software/download/developer/5102.html</a>
> >
> >For more information about JATO, please visit:
> ><a href="http://developer.iplanet.com/tech/appserver/framework/index.jsp">http: //developer.iplanet.com/tech/appserver/framework/index.jsp</a>
> >
> >
> >
> >
