[jira] Commented: (IBATIS-154) Way To Map a RefCursor 's ResultSet to a ResultMap

["Ken Katsma (JIRA)" <ib...@incubator.apache.org>]

    [ http://issues.apache.org/jira/browse/IBATIS-154?page=comments#action_12330489 ] 

Ken Katsma commented on IBATIS-154:
-----------------------------------

It would be good if we can express this request through the xml as well.  I gave an example of one way this might be done in the xml in IBATIS-53 but am including it here as a reminder:

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap>
<resultMap id="testResult" class="com.test.TestTO">
  <result property="testCode" column="test_cd" />
       </resultMap>

    <parameterMap id="parameters" class="map" >
        <parameter property="output1" jdbcType="ORACLECURSOR" javaType="java.sql.ResultSet" mode="OUT" treatAsResultSet="true"/>
        <parameter property="in1" jdbcType="int" javaType="java.lang.Integer" mode="IN"/>
    </parameterMap>

    <procedure id="GetEmpRs" parameterMap="parameters" resultMap="testResult">
        { ? = call scott.example.GetEmpRS(?) }
    </procedure>
</sqlMap> 


> Way To Map a RefCursor 's ResultSet to a ResultMap
> --------------------------------------------------
>
>          Key: IBATIS-154
>          URL: http://issues.apache.org/jira/browse/IBATIS-154
>      Project: iBatis for Java
>         Type: Sub-task
>   Components: SQL Maps
>     Versions: 2.1.0
>  Environment: Java Baseline
>     Reporter: Michael Fagan
>     Priority: Minor

>
> This is a re-request for the functionality asked  for in IBATIS-53
> The fix for IBATIS-53 does solve the problem of physically being able to access the ResultSet but does not provide a means to have it mapped to a ResultMap ( which  I feel is the true power of IBATIS ). 
> If we must use a type handler to retrieve the ResultSet can you provide a way that we can use ibatis intrastructure to map a ResultSet it to a object graph/collection? Ideally I would like to handle this in the TypeHandlerCallback.

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