ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jan Vissers <Jan.Viss...@cumquat.nl>
Subject Re: Returning Multiple Resultsets from a Stored Procedure
Date Fri, 11 Feb 2005 01:37:30 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-15"
 http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<font face="Bitstream Vera Sans Mono">I would think you need a custom
typehandler. This would/could bring you support for weakly typed ref
cursors. What I personally was/am looking for is an example or
description how to support strongly typed ones. The latter would be
much nicer.<br>
<br>
-J.<br>
</font><br>
Yee, Richard K, CTR,, DMDCWEST wrote:
<blockquote
 cite="midB1A1D42876EED611858C00805FC78FF70938D8C5@ddsmttayz064.int.dmdc.osd.mil"
 type="cite">
  <pre wrap="">Clinton,
I guess I'm a little confused then about the current limitations of iBATIS
and stored procedures. I thought I read in the archives that iBATIS didn't
handle REF_CURSORS as an OUT parameter from a stored procedure.

Please excuse me if my questions are a little ignorant because I haven't
done much work with stored procedures.

What I need iBATIS to do is be able to get the result set returned by a
stored procedure.

Thanks,

Richard


-----Original Message-----
From: Clinton Begin [<a class="moz-txt-link-freetext" href="mailto:clinton.begin@gmail.com">mailto:clinton.begin@gmail.com</a>]

Sent: Thursday, February 10, 2005 5:06 PM
To: <a class="moz-txt-link-abbreviated" href="mailto:ibatis-user-java@incubator.apache.org">ibatis-user-java@incubator.apache.org</a>
Subject: Re: Returning Multiple Resultsets from a Stored Procedure


Absolutely.  

Cheers,
Clinton


On Fri, 11 Feb 2005 00:49:41 -0000, Yee, Richard K, CTR,, DMDCWEST
<a class="moz-txt-link-rfc2396E" href="mailto:Richard.Yee.ctr@osd.pentagon.mil">&lt;Richard.Yee.ctr@osd.pentagon.mil&gt;</a>
wrote:
  </pre>
  <blockquote type="cite">
    <pre wrap="">Clinton,
Does iBATIS support even one resultSet (multiple rows) from a Stored 
Procedure?

Thanks,

Richard


-----Original Message-----
From: Clinton Begin [<a class="moz-txt-link-freetext" href="mailto:clinton.begin@gmail.com">mailto:clinton.begin@gmail.com</a>]
Sent: Thursday, February 10, 2005 4:39 PM
To: <a class="moz-txt-link-abbreviated" href="mailto:ibatis-user-java@incubator.apache.org">ibatis-user-java@incubator.apache.org</a>
Subject: Re: Returning Multiple Resultsets from a Stored Procedure

Nope.  Not at this time.

It doesn't fit our single input/single output semantic.

Cheers,
Clinton

On Mon, 07 Feb 2005 14:02:15 +1100, Dan Batten <a class="moz-txt-link-rfc2396E" href="mailto:danatten@gmx.net">&lt;danatten@gmx.net&gt;</a>

wrote:
    </pre>
    <blockquote type="cite">
      <pre wrap="">Gidday,

I'm very interested in using iBatis for my next project but have 
been unable to find any answer to the question:

Does iBatis support returning multiple resultsets from one stored 
procedure?

If it does could you please post a simple example.

Cheers,
Dan.

      </pre>
    </blockquote>
  </blockquote>
  <pre wrap=""><!---->
  </pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<table>
  <tbody>
    <tr>
      <td><a href="http://www.spreadfirefox.com/?q=affiliates&amp;id=0&amp;t=55"><img
 alt="Get Firefox!" title="Get Firefox!"
 src="cid:part1.01090300.09010905@cumquat.nl" border="0"></a></td>
      <td> And </td>
      <td><a href="http://www.mozilla.org/products/thunderbird/"
 title="Get Thunderbird - Reclaim Your Inbox"><img
 src="cid:part2.05070103.00060007@cumquat.nl" alt="Get Thunderbird"
 border="0" height="32" width="110"></a></td>
    </tr>
  </tbody>
</table>
</div>
</body>
</html>

Mime
View raw message