ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "bhaarat Sharma" <bhaara...@gmail.com>
Subject Re: iBatis with Oracle stored procs (multiple resultsets)
Date Mon, 26 Nov 2007 12:44:55 GMT
I am doing something like this:

  <procedure id="getUsage" parameterMap="getUsageCall"
resultMap="select-usage-object1,select-usage-object2">
      {call test_friends (?)}
   </procedure>

as you see we have two resultMaps. I think thats the way to do it. But maybe
someone Senior can help us both...



On Nov 26, 2007 5:25 AM, <guillen.olmos.angel@servexternos.repsolypf.com>
wrote:

>  Hi,
>
> i'm using SQL Server too. Stored procedures returning multiple resultSet
> works, but I can only map the first resultSet into a resultMap. ┬┐How do you
> map the multiple resultSets?
>
> I can't find the sintax to do this.
>
> Thanks
>
> Angel
>
>  ------------------------------
> *De:* bhaarat Sharma [mailto:bhaarat.s@gmail.com]
> *Enviado el:* domingo, 25 de noviembre de 2007 22:07
> *Para:* user-java@ibatis.apache.org
> *Asunto:* iBatis with Oracle stored procs (multiple resultsets)
>
> Hi
>
> I am fairly new to iBatis. We are currently using iBatis with java and MS
> sql server. Stored procedures returning multiple resultMaps is working fine
> for us right now.
>
> However, we are going to be switching to oracle soon and As you know
> oracle has RF Cursors when it comes to returning multiple resultsets from
> stored procs.  I am just wondering if there are known problems with this
> approach ?
>
> I am going to be trying this very soon but just wanted to know if some of
> you out there are already aware of some known hiccups.
>
> Thanks
>
> --
> -bhaarat
>



-- 
-bhaarat

Mime
View raw message