Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: neutral (asf.osuosl.org: local policy)
Message-ID: <43F50823.6060106@pandora.be>
Date: Fri, 17 Feb 2006 00:17:55 +0100
From: Sven Boden <list123@pandora.be>
Reply-To: list123@pandora.be
User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
MIME-Version: 1.0
To: clement.k.justin@jpmchase.com
Cc: ibatis-dev@incubator.apache.org, user-java@ibatis.apache.org
Subject: Re: Reg. Problem with Cursors still open.
References: 
 <OF0C7A5EDD.7AFCDCC5-ON85257117.007E1791-85257117.007F1419@jpmchase.com>
In-Reply-To: 
 <OF0C7A5EDD.7AFCDCC5-ON85257117.007E1791-85257117.007F1419@jpmchase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


Available options... but none that really fits you...
1) the way you use it now is not officially supported (IBATIS-53 returns 
a ResultSet but does not map it to a ResultMap), you don't really use 
output1, it just gets mapped to the returning ResultSet... and I'm still 
waiting for your Oracle query to count open cursors ;-)
2) Michael Fagan made a patch to iBATIS which you can find in the iBATIS 
WIKI (under use of Oracle cursors), but it's not in the baseline of 
iBATIS. And if you use that you may end up in a dead track in the end 
(unless you patch yourself every new version of iBATIS).

There are some ideas on supporting what you want, but none of it's 
implemented yet (discussed last week on the dev mailing list). And will 
depend on whether we find a nice clean solution to it all and when we 
find the time to build it in.... this will not be short short term (at 
least not by me).

Regards,
Sven

clement.k.justin@jpmchase.com wrote:

>Dear Sven,
>
>JIRA IBATIS-53 example uses, queryForObject() method, which in turn will 
>return only one resultset.  We need multiple resultset, is it possible 
>using queryForList() Method in retrieving resultset. 
>
>R u asking us to use the modified jar files for this instance in the 
>attachment section.
>
>Where do i get the modified Jar files for running the code? Guide me or 
>Can you update me with a sample code for getting multiple resultset using 
>queryForList() method.
>
>regards,
>-----------------------------------------------------------
>Clement K Justin.
>Tata Consultancy Services,
>Columbus, Ohio.
>Work Phone : 614-213-7417.
>------------------------------------------------------------
>
>  
>
>>    
>>