struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Martin Gainty <mgai...@hotmail.com>
Subject RE: Possible to return ibatis query in xml file?
Date Thu, 05 Mar 2009 01:53:02 GMT

--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: hgonzalez@gmail.com
> To: user@struts.apache.org
> 
> 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 <emilu@encs.concordia.ca> 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: user-unsubscribe@struts.apache.org
> > For additional commands, e-mail: user-help@struts.apache.org
> >
> >
> 
> 
> 
> --
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
> 

_________________________________________________________________
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
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message