tags:

views:

105

answers:

0

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?