You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-cs@ibatis.apache.org by Rivaaj Jumna <ri...@gmail.com> on 2006/08/15 02:36:43 UTC
how to map multiple result sets in .net
Hi
I've been testing out ibatis.net and it looks really good. My one stumbling
block is how to handle stored procedures returning multiple result sets?
Given my limited use of the data mapper, I'm not quite sure how to
accomplish this. Any help is appreciated.
Regards
Rivaaj
Re: how to map multiple result sets in .net
Posted by Gilles Bayon <ib...@gmail.com>.
Well, that could be done, you could open a JIRA ticket if you want to
see it in a next release.
--
Cheers,
Gilles
<a href="http://www.amazon.com/gp/registry/6JCP7AORB0LE">Wish List</a>
Re: how to map multiple result sets in .net
Posted by Clinton Begin <cl...@gmail.com>.
Here's the changelog:
http://fisheye3.cenqua.com/changelog/ibatis/?cs=431155
Here's an example of how it's used:
<procedure id="getEmployeesAndDepartmentsForOrg"
parameterClass="int"
resultMap="EmployeeResult, DepartmentResult">
{call GET_EMP_DEPT (#1#)}
</procedure>
The above example will produce a list of two lists, one with employees, and
the other with departments.
Cheers,
Clinton
On 8/14/06, Rivaaj Jumna <ri...@gmail.com> wrote:
>
> Hi Clinton
>
> I would like to see how it was done in the Java version, are there
> examples of the usage of this feature in the Java version as well?
>
> Regards
> Rivaaj
>
>
> On 8/15/06, Clinton Begin <cl...@gmail.com> wrote:
> >
> >
> > We just implemented it in the Java version. It was quite a mess to
> > implement, due to the current over-layered design (my fault) but not
> > impossible. Something similar could be done for the C# implementation. I
> > can point you to the SVN change log if you'd like to see what I did.
> >
> > Cheers,
> > Clinton
> >
> >
> >
> > On 8/14/06, Rivaaj Jumna < rivaaj@gmail.com> wrote:
> > >
> > > Hi
> > >
> > > I've been testing out ibatis.net and it looks really good. My one
> > > stumbling block is how to handle stored procedures returning multiple result
> > > sets? Given my limited use of the data mapper, I'm not quite sure how to
> > > accomplish this. Any help is appreciated.
> > >
> > > Regards
> > > Rivaaj
> > >
> >
> >
>
Re: how to map multiple result sets in .net
Posted by Rivaaj Jumna <ri...@gmail.com>.
Hi Clinton
I would like to see how it was done in the Java version, are there examples
of the usage of this feature in the Java version as well?
Regards
Rivaaj
On 8/15/06, Clinton Begin <cl...@gmail.com> wrote:
>
>
> We just implemented it in the Java version. It was quite a mess to
> implement, due to the current over-layered design (my fault) but not
> impossible. Something similar could be done for the C# implementation. I
> can point you to the SVN change log if you'd like to see what I did.
>
> Cheers,
> Clinton
>
>
>
> On 8/14/06, Rivaaj Jumna <ri...@gmail.com> wrote:
> >
> > Hi
> >
> > I've been testing out ibatis.net and it looks really good. My one
> > stumbling block is how to handle stored procedures returning multiple result
> > sets? Given my limited use of the data mapper, I'm not quite sure how to
> > accomplish this. Any help is appreciated.
> >
> > Regards
> > Rivaaj
> >
>
>
Re: how to map multiple result sets in .net
Posted by Michael Schall <mi...@gmail.com>.
I would love to see this functionality added!!!
On 8/14/06, Clinton Begin <cl...@gmail.com> wrote:
>
> We just implemented it in the Java version. It was quite a mess to
> implement, due to the current over-layered design (my fault) but not
> impossible. Something similar could be done for the C# implementation. I
> can point you to the SVN change log if you'd like to see what I did.
>
> Cheers,
> Clinton
>
>
>
> On 8/14/06, Rivaaj Jumna <ri...@gmail.com> wrote:
> >
> > Hi
> >
> > I've been testing out ibatis.net and it looks really good. My one
> stumbling block is how to handle stored procedures returning multiple result
> sets? Given my limited use of the data mapper, I'm not quite sure how to
> accomplish this. Any help is appreciated.
> >
> > Regards
> >
> > Rivaaj
> >
>
>
Re: how to map multiple result sets in .net
Posted by Clinton Begin <cl...@gmail.com>.
We just implemented it in the Java version. It was quite a mess to
implement, due to the current over-layered design (my fault) but not
impossible. Something similar could be done for the C# implementation. I
can point you to the SVN change log if you'd like to see what I did.
Cheers,
Clinton
On 8/14/06, Rivaaj Jumna <ri...@gmail.com> wrote:
>
> Hi
>
> I've been testing out ibatis.net and it looks really good. My one
> stumbling block is how to handle stored procedures returning multiple result
> sets? Given my limited use of the data mapper, I'm not quite sure how to
> accomplish this. Any help is appreciated.
>
> Regards
> Rivaaj
>