You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Clement Justin (JIRA)" <ib...@incubator.apache.org> on 2006/02/11 23:45:27 UTC

[jira] Created: (IBATIS-255) How to close RefCursors

How to close RefCursors
-----------------------

         Key: IBATIS-255
         URL: http://issues.apache.org/jira/browse/IBATIS-255
     Project: iBatis for Java
        Type: Wish
  Components: SQL Maps  
    Versions: 2.1.6    
 Environment: Websphere5.0, Struts, iBatis, Oracle 9i(Uses Stored Procs for DB Access)
    Reporter: Clement Justin


Hai, I'am new to iBatis. Currently i'am developing a project involving Struts for Web interface and iBatis for DB Read and write. 
I'am using ParameterMap for setting values to SP and resultMap for getting values back from SP. All SPs are returning Ref-Cursors. But the ref-Cursors opened in SPs are still being opened at DB side. I don't use any type handler, using only SQL Map configuration. Can anyone guide me, on how to close the Resultset, once value is retrieved from SP.

-- 
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


[jira] Closed: (IBATIS-255) How to close RefCursors

Posted by "Clinton Begin (JIRA)" <ib...@incubator.apache.org>.
     [ http://issues.apache.org/jira/browse/IBATIS-255?page=all ]
     
Clinton Begin closed IBATIS-255:
--------------------------------

    Resolution: Invalid

Support question.  Duplicate.  Please read the documentation.  

We don't support ref cursors yet.



> How to close RefCursors
> -----------------------
>
>          Key: IBATIS-255
>          URL: http://issues.apache.org/jira/browse/IBATIS-255
>      Project: iBatis for Java
>         Type: Wish
>   Components: SQL Maps
>     Versions: 2.1.6
>  Environment: Websphere5.0, Struts, iBatis, Oracle 9i(Uses Stored Procs for DB Access)
>     Reporter: Clement Justin

>
> Hai, I'am new to iBatis. Currently i'am developing a project involving Struts for Web interface and iBatis for DB Read and write. 
> I'am using ParameterMap for setting values to SP and resultMap for getting values back from SP. All SPs are returning Ref-Cursors. But the ref-Cursors opened in SPs are still being opened at DB side. I don't use any type handler, using only SQL Map configuration. Can anyone guide me, on how to close the Resultset, once value is retrieved from SP.

-- 
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