ibatis-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ken Katsma (JIRA)" <ibatis-...@incubator.apache.org>
Subject [jira] Commented: (IBATIS-154) Way To Map a RefCursor 's ResultSet to a ResultMap
Date Mon, 26 Sep 2005 17:26:50 GMT
    [ 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">
<resultMap id="testResult" class="com.test.TestTO">
  <result property="testCode" column="test_cd" />

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

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

> 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:
For more information on JIRA, see:

View raw message