Return-Path: 
 <user-java-return-6197-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 36227 invoked from network); 7 Mar 2006 18:31:49 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 7 Mar 2006 18:31:49 -0000
Received: (qmail 71125 invoked by uid 500); 7 Mar 2006 18:31:49 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 70651 invoked by uid 500); 7 Mar 2006 18:31:47 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 70640 invoked by uid 99); 7 Mar 2006 18:31:47 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Mar 2006 10:31:47 -0800
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of eferreyra@gmail.com designates
 64.233.184.204 as permitted sender)
Received: from [64.233.184.204] (HELO wproxy.gmail.com) (64.233.184.204)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Mar 2006 10:31:46 -0800
Received: by wproxy.gmail.com with SMTP id i3so231759wra
        for <user-java@ibatis.apache.org>;
 Tue, 07 Mar 2006 10:31:24 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:user-agent:x-accept-language:mime-version:to:subject:content-type:content-transfer-encoding;
        b=j+6HqRvo6lP7jaGztgvD2upJ1p4KKX0WphQCNBHt745NTcGlct++FnCMnlDDuIabXhWUQuyYRj35mHYcp/xkzgvD6uy249Lq9HvJ7mkVT5wqD1mWEXy9I96SqGt8f/bkwmtIFii2juSTb2Rief1Y1nyfz5v0Rp7RTaYes37qfKI=
Received: by 10.54.151.7 with SMTP id y7mr733866wrd;
        Tue, 07 Mar 2006 10:31:23 -0800 (PST)
Received: from ?201.252.214.14? ( [201.252.214.14])
        by mx.gmail.com with ESMTP id 15sm1182730wrl.2006.03.07.10.31.04;
        Tue, 07 Mar 2006 10:31:08 -0800 (PST)
Message-ID: <440DD13C.60306@gmail.com>
Date: Tue, 07 Mar 2006 15:30:20 -0300
From: Enrique Ferreyra <eferreyra@gmail.com>
User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
X-Accept-Language: es-ar, es, en-us, en
MIME-Version: 1.0
To: user-java@ibatis.apache.org
Subject: remapResults is necessary if the result query doesnt change in a
 execution ?
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Hi , my first message :) ok, i know the performance penalties if i put 
the remapResults = true, and i understand why is necesary this when 
using $$ parameters, i think in my case is not necesary, tell me if im 
wrong.

We work whit informix and we have many instances, we try the software be 
the same setting some parameters at start for the instance choice, but 
in one instance some "table" is in "database1" and in other instance is 
in "database2", the connection is a single database, so we refer to the 
tables as 'database:table' in informix notation, now my question is if i 
make sql querys in a sqlMap like:

    <select id="get-deposito" parameterClass="java.util.HashMap" 
resultMap="get-deposito-result">
        SELECT dep_cod, dep_tip, dep_des
        FROM $depositos$
        WHERE dep_com_cod = #com_cod#
          AND dep_cod = #dep_cod#
          AND dep_tip = #dep_tip#
    </select>

And the $depositos$ value doesnt change in the current execution of the 
application, DO I NEED THE remapResults="true" ?

Thanks !

-- 
  A.U.S. Enrique Ferreyra
    Centro de C�mputos
 Red Megatone - Red Confina