Isn't it possible to use multiple result set support (resultMap="resultMap1,
resultMap2" or resultClass="resultClass1, resultClass2") to map ootput
parameter (Ref Cursors) the same way I have done with the first procedure
that return only one output parameter?
Or is there a chance to extend the iBatis framework to do that?
Ciao,
Alessandro
>Output parameter results are currently not cached. So the best way to deal
>with it is to simply cache it yourself, perhaps in your DAO layer.
>
>
>Cheers,
>Clinton
>
>
>
>
>
>On 9/20/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>>
>> Hi, I have cahced an Oracle Ref Cursor returned by a procedure in this
>> way, with iBatis 2.2.0 build 638.
>>
>> <cacheModel id="rs-cache" type="MEMORY">
>> <flushInterval hours="6" />
>> <property name="reference-type" value="SOFT" />
>> </cacheModel>
>>
>> <!-- Single ResultSet Stored Procedure -->
>>
>> <parameterMap id="single-rs" class="map">
>> <parameter property="idPortaf" javaType="java.lang.Integer"
>> mode="IN"/>
>> <parameter property="startPerfDate" jdbcType="DATE" javaType="
>> java.util.Date" mode="IN"/>
>> <parameter property="endDate" jdbcType="TIMESTAMP" javaType="
>> java.util.Date" mode="IN"/>
>>
>> <parameter property="output1" jdbcType="ORACLECURSOR" javaType="
>> java.sql.ResultSet" mode="OUT"/>
>> </parameterMap>
>>
>> <procedure id="GetSingleEmpRs" parameterMap="single-rs" resultClass="
>> java.util.HashMap" cacheModel="rs-cache" >
>> {call PKG_FOR_JSP_PERF_ATTRIBUTION.risultatojspPa_1(?,?,?,?)}
>> </procedure>
>>
>> How can I do it with a procedure that return multiple Oracle Ref Cursors?
>>
>> I have tried this but it is not working:
>>
>> <!-- Multiple ResultSet Stored Procedure -->
>>
>> <resultMap id="rc1-map" class="java.util.HashMap">
>> <result property="data" column="DATA" />
>> </resultMap>
>>
>> <resultMap id="rc2-map" class="java.util.HashMap">
>> <result property="classeDesc2" column="CLASSE_DESC_2" />
>> <result property="internalWeight" column="INTERNAL_WEIGHT" />
>> </resultMap>
>>
>> <parameterMap id="multiple-rs" class="map">
>> <parameter property="level" jdbcType="VARCHAR" javaType="
>> java.lang.String" mode="IN"/>
>> <parameter property="type" jdbcType="VARCHAR" javaType="
>> java.lang.String" mode="IN"/>
>> <parameter property="endDate" jdbcType="DATE" javaType="
>> java.util.Date" mode="IN"/>
>> <parameter property="perimetro" jdbcType="INTEGER" javaType="
>> java.lang.Integer" mode="IN"/>
>>
>> <parameter property="output1" jdbcType="ORACLECURSOR" javaType="
>> java.sql.ResultSet" mode="OUT" resultMap="rc1-map"/>
>> <parameter property="output2" jdbcType="ORACLECURSOR" javaType="
>> java.sql.ResultSet" mode="OUT" resultMap="rc2-map"/>
>>
>> </parameterMap>
>>
>> <procedure id="GetMultipleEmpRs" parameterMap="multiple-rs"
>> cacheModel="rs-cache">
>> {call
>> PKG_ASSET_ALLOCATION.PRINT_POSTITION_KEEPING_JSP(?,?,?,?,?,?)}
>> </procedure>
>>
>> Thanks,
>> Alessandro
>>
>> Clinton Begin wrote:
>> >
>> > Correct. A cache model will only work with results, not with output
>> params
>> > (because you passed the object in), and certainly not with Oracle
>> cursors
>> > (because they are live connections to the DB).
>> >
>> > Cheers,
>> > Clinton
>> >
>> > On 10/26/05, Rao, Satish <[EMAIL PROTECTED]> wrote:
>> >>
>> >>
>> >> Does cacheModel only work with resultClass and resultMap?
>> >>
>> >> Currently I have the following entry in the sqlMap
>> >>
>> >> <cacheModel id="cacheFullname" type="OSCACHE">
>> >> </cacheModel>
>> >>
>> >> <parameterMap id="some-param" class="SomeParams" >
>> >> <parameter property="someId" mode="IN" jdbcType="VARCHAR" javaType="
>> >> java.lang.String"/>
>> >> <parameter property="someRS" jdbcType="ORACLECURSOR" javaType="
>> >> java.sql.ResultSet" mode="OUT"/>
>> >> </parameterMap>
>> >>
>> >> <procedure id="someProcedure" parameterMap="some-param"
>> >> cacheModel="cacheFullname">
>> >> {call PROC_NAME(?,?)}
>> >> </procedure>
>> >>
>> >> The stored procedure uses the OUT parameter to fetch the Oracle cursor
>> >> and
>> >> I have CustomTypeHandler to map the Oracle Cursor to a ResultSet.
>> >>
>> >> The cacheModel doesn't work in this case.
>> >>
>> >> Has anyone tried using cacheModel with the above scenario?
>> >>
>> >> Thanks.
--
View this message in context:
http://www.nabble.com/cacheModel-question-tf452929.html#a6422736
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
