You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user-java@ibatis.apache.org by bhaarat Sharma <bh...@gmail.com> on 2007/11/25 22:07:09 UTC

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

RE: iBatis with Oracle stored procs (multiple resultsets)

Posted by gu...@servexternos.repsolypf.com.

Thank you Sharma.

How do you work whith the two result maps when you are programming the API?

A java method can only return one result...

Can any one confirm me if it's possible to work whith two result maps and how?

Thank you

________________________________

De: bhaarat Sharma [mailto:bhaarat.s@gmail.com]
Enviado el: lunes, 26 de noviembre de 2007 13:45
Para: user-java@ibatis.apache.org
Asunto: Re: iBatis with Oracle stored procs (multiple resultsets)

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 <ma...@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)

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

Re: iBatis with Oracle stored procs (multiple resultsets)

Posted by bhaarat Sharma <bh...@gmail.com>.

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, <gu...@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

RE: iBatis with Oracle stored procs (multiple resultsets)

Posted by gu...@servexternos.repsolypf.com.

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