Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 20358 invoked from network); 26 Oct 2005 13:58:32 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 26 Oct 2005 13:58:32 -0000 Received: (qmail 6961 invoked by uid 500); 26 Oct 2005 13:58:30 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 6944 invoked by uid 500); 26 Oct 2005 13:58:29 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 6906 invoked by uid 99); 26 Oct 2005 13:58:29 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 26 Oct 2005 06:58:28 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [192.223.198.27] (HELO maillnx-us112.fmr.com) (192.223.198.27) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 26 Oct 2005 06:58:24 -0700 Received: from MSGMROSM01WIN.dmn1.fmr.com (MSGMROSM01WIN.dmn1.fmr.com [172.26.7.127]) by maillnx-us112.fmr.com (Switch-3.1.2/Switch-3.1.0) with SMTP id j9QDw36G030054 for ; Wed, 26 Oct 2005 09:58:04 -0400 Received: from MSGMROIV02WIN.DMN1.FMR.COM (10.37.74.75) by MSGMROSM01WIN.dmn1.fmr.com (Sigaba Gateway v3.83) with ESMTP id 51514100; Wed, 26 Oct 2005 09:58:03 -0400 Received: from MSGMMKIM01WIN.DMN1.FMR.COM ([172.25.108.46]) by MSGMROIV02WIN.DMN1.FMR.COM with SMTP_server; Wed, 26 Oct 2005 09:58:03 -0400 Received: from msgmmkclq2win.FMR.COM ([10.33.181.43]) by MSGMMKIM01WIN.DMN1.FMR.COM with Microsoft SMTPSVC(5.0.2195.6713); Wed, 26 Oct 2005 09:58:03 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5DA35.4864492F" Subject: cacheModel question Date: Wed, 26 Oct 2005 09:58:03 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: cacheModel question Thread-Index: AcXaNVy81NEyguC1Q2+8z9p/geGXBw== From: "Rao, Satish" To: X-OriginalArrivalTime: 26 Oct 2005 13:58:03.0512 (UTC) FILETIME=[488B0780:01C5DA35] X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. ------_=_NextPart_001_01C5DA35.4864492F Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Does cacheModel only work with resultClass and resultMap? Currently I have the following entry in the sqlMap {call PROC_NAME(?,?)} 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. ------_=_NextPart_001_01C5DA35.4864492F Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable cacheModel question

Does cacheModel only work with = resultClass and resultMap?

Currently I have the following entry in = the sqlMap

          <cacheModel id=3D"cacheFullname" = type=3D"OSCACHE">
          </cacheModel>

        <parameterMap id=3D"some-param" = class=3D"SomeParams" >
        =         <parameter property=3D"someId" = mode=3D"IN" jdbcType=3D"VARCHAR" = javaType=3D"java.lang.String"/>
        =         <parameter property=3D"someRS" = jdbcType=3D"ORACLECURSOR" = javaType=3D"java.sql.ResultSet" = mode=3D"OUT"/>
        </parameterMap>

        <procedure id=3D"someProcedure" = parameterMap=3D"some-param" = cacheModel=3D"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.

------_=_NextPart_001_01C5DA35.4864492F--