ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bhaarat Sharma <bhaara...@gmail.com>
Subject how to implement resultSetType and resultSetConcurrency in iBatis Stored Procedure.
Date Wed, 04 Nov 2009 16:39:00 GMT
We are using Oracle.

we have an old JDBC call like this...

Conn.prepareCall("{call
some_sp_name()}",ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);

usually we make the following parameter map in our mapping.

<procedure id="getMax" parameterMap="getMaxCall">{call
some_sp_name()}</procedure>

  <parameterMap id="getDebtMaxUpdateNumCall" class="map">
    <parameter property="Result0" jdbcType="ORACLECURSOR"
javaType="java.sql.ResultSet" mode="OUT" resultMap="getMaxResult"/>
  </parameterMap>

  <resultMap id="getMaxResult" class="java.util.HashMap">
    <result property="pk_value" column="pk_value"/>
  </resultMap>


but now that we have resultSetType and resultSetConcurrency parameters...how
do we implement that in iBatis mapping?

Mime
View raw message