Return-Path: 
 <ibatis-user-java-return-1688-apmail-incubator-ibatis-user-java-archive=incubator.apache.org@incubator.apache.org>
Delivered-To: apmail-incubator-ibatis-user-java-archive@www.apache.org
Received: (qmail 48970 invoked from network); 5 Apr 2005 21:10:00 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 5 Apr 2005 21:10:00 -0000
Received: (qmail 78983 invoked by uid 500); 5 Apr 2005 21:09:59 -0000
Delivered-To: apmail-incubator-ibatis-user-java-archive@incubator.apache.org
Received: (qmail 78963 invoked by uid 500); 5 Apr 2005 21:09:58 -0000
Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ibatis-user-java@incubator.apache.org
List-Help: <mailto:ibatis-user-java-help@incubator.apache.org>
List-Unsubscribe: <mailto:ibatis-user-java-unsubscribe@incubator.apache.org>
List-Post: <mailto:ibatis-user-java@incubator.apache.org>
List-Id: <ibatis-user-java.incubator.apache.org>
Delivered-To: mailing list ibatis-user-java@incubator.apache.org
Received: (qmail 78947 invoked by uid 99); 5 Apr 2005 21:09:58 -0000
X-ASF-Spam-Status: No, hits=0.5 required=10.0
	tests=TO_ADDRESS_EQ_REAL
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from tde00.tde.com (HELO tde00.tde.com) (208.42.240.20)
  by apache.org (qpsmtpd/0.28) with ESMTP; Tue, 05 Apr 2005 14:09:57 -0700
Received: from tde.com (unverified [208.42.242.171]) by tde00.tde.com
 (Vircom SMTPRS 3.2.315.0) with ESMTP id <B0037026296@tde00.tde.com> for
 <ibatis-user-java@incubator.apache.org>;
 Tue, 5 Apr 2005 15:09:54 -0600
Message-ID: <4252FEAB.5080500@tde.com>
Date: Tue, 05 Apr 2005 15:10:03 -0600
From: Mike Fagan <mfagan@tde.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-CA;
 rv:1.0.2) Gecko/20030208 Netscape/7.02
X-Accept-Language: en-ca, en
MIME-Version: 1.0
To: "ibatis-user-java@incubator.apache.org"
 <ibatis-user-java@incubator.apache.org>
Subject: prevent caching of resultMap
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Hi,

I have a stored function that returns a refcursor with the different 
columns based on passed in parameters.
My problem is that IBATIS is caching the column names from the first 
call to this stored function causing later calls with a different 
refcursor definition to fail due to different columns returned. I have 
set cacheModelsEnabled to false and was wondering if I am missing 
another config setting. Using version 2.0.9

Here is my sqlMap:

    <parameterMap id="queryParameters" class="map" >
        <parameter property="result" jdbcType="ORACLECURSOR" mode="OUT"/>
        <parameter property="user" jdbcType="NUMERIC" javaType="long" 
mode="IN" />
        <parameter property="resultid" jdbcType="NUMERIC" 
javaType="long" mode="IN" />
        <parameter property="startidx" jdbcType="NUMERIC" javaType="int" 
mode="IN" />
        <parameter property="endidx" jdbcType="NUMERIC" javaType="int" 
mode="IN" />
        <parameter property="fields" jdbcType="VARCHAR" 
javaType="java.lang.String" mode="IN" />
        <parameter property="total" jdbcType="NUMERIC" javaType="long" 
mode="OUT" />
    </parameterMap>

    <procedure id="queryRecords" resultClass="java.util.HashMap" 
parameterMap="queryParameters" >
        { ? = call RECORDSET.getPagedRecordCursor(?, ?, ?, ?, ?, ?) }
    </procedure>

Thanks,
Mike Fagan