[ http://issues.apache.org/jira/browse/IBATIS-252?page=comments#action_12365931 ]
Sven Boden commented on IBATIS-252: ----------------------------------- This is a not an iBATIS bug, it's an application design problem (and not in iBATIS). Normally the component in your application that is using the returned ResultSet also has to close it afterwards. If the ResultSet is not used by your application, why do you request it? A short term solution could be to extend your QueueBean, use the new class as class attribute in the parameterMap and close the ResultSet in the setter for resultCursor. I will try close to this JIRA as "invalid". Regards, Sven > closing resultset cursor in Ibatis > ---------------------------------- > > Key: IBATIS-252 > URL: http://issues.apache.org/jira/browse/IBATIS-252 > Project: iBatis for Java > Type: Bug > Components: SQL Maps > Environment: ,Ibatis, Java,SQL Server and Oracle 9i > Reporter: Shiuli Deb > Assignee: Sven Boden > > Issue is Stored Procedures returns an Cursor. Our application which uses > Ibatis Java, SQL Server and Oracle 9i, access those Cursors as Resultset. > Also our application doesn't use any extra code for getting resultset. So > there is something missing somewhere to close the resultset. Please find a > way to close the resultsets after getting the values. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira