--you can with oracle so instead of coding this simple statement in
ibatis_query.xml
<select id="test">
select * from a
</select>
--put in this PL/SQL in ibatis_query.xml:
<select id="test">
DECLARE
ctx dbms_xmlgen.ctxHandle;
xml CLOB; --Character Large Object (>64k of character string)
i PLS_INTEGER;
BEGIN
ctx := dbms_xmlgen.newContext('SELECT * FROM A);
xml := dbms_xmlgen.getXML(ctx);
DBMS_OUTPUT.PUT_LINE(xml);
i := dbms_xmlgen.getNumRowsProcessed(ctx);
dbms_output.put_line(TO_CHAR(i));
END;
</select>
Martin
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business
of Sender. This transmission is of a confidential nature and Sender does not
endorse distribution to any party other than intended recipient. Sender does
not necessarily endorse content contained within this transmission.
> Date: Wed, 4 Mar 2009 23:14:16 -0200
> Subject: Re: Possible to return ibatis query in xml file?
> From: [email protected]
> To: [email protected]
>
> If I understand right, the answer is no (and the question is not
> related to struts, but only to ibatis).
> You can't get (AFAIK) the sql generated/executed by ibatis, and there
> are good reasons for that.
> If you are debugging some sql problem, your database should allow you
> to turn on full logging
> of your sql queries.
>
> Hernán J. González
> http://hjg.com.ar/
>
> On Wed, Mar 4, 2009 at 4:46 PM, Emi Lu <[email protected]> wrote:
> > Good morning,
> >
> > I have a question based on ibatis + struts. Would it be possible that in
> > java code, I could get the query in ibatis.
> >
> > For example, in ibatis_query.xml
> > <select id="test">
> > select * from a
> > </select>
> >
> >
> > In java,
> > ===============
> > public ActionForward execute(
> > ActionMapping mapping,
> > ActionForm aform,
> > HttpServletRequest request,
> > HttpServletResponse response)
> > throws Exception
> > {
> > String ibatis_sql = ***(something need to know).getQuery("test", null);
> > ... ...
> > }
> >
> >
> > Thanks a lot!
> > Lu Ying
> >
> >
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [email protected]
> > For additional commands, e-mail: [email protected]
> >
> >
>
>
>
> --
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
_________________________________________________________________
Windows Live™ Contacts: Organize your contact list.
http://windowslive.com/connect/post/marcusatmicrosoft.spaces.live.com-Blog-cns!503D1D86EBB2B53C!2285.entry?ocid=TXT_TAGLM_WL_UGC_Contacts_032009
