Return-Path: 
 <ibatis-user-java-return-1365-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 15667 invoked from network); 11 Mar 2005 14:23:36 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur-2.apache.org with SMTP; 11 Mar 2005 14:23:36 -0000
Received: (qmail 18431 invoked by uid 500); 11 Mar 2005 14:23:33 -0000
Delivered-To: apmail-incubator-ibatis-user-java-archive@incubator.apache.org
Received: (qmail 18310 invoked by uid 500); 11 Mar 2005 14:23:32 -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 18273 invoked by uid 99); 11 Mar 2005 14:23:32 -0000
X-ASF-Spam-Status: No, hits=0.4 required=10.0
	tests=DNS_FROM_RFC_ABUSE,RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: domain of scottzhu@gmail.com designates
 64.233.184.194 as permitted sender)
Received: from wproxy.gmail.com (HELO wproxy.gmail.com) (64.233.184.194)
  by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 11 Mar 2005 06:23:31 -0800
Received: by wproxy.gmail.com with SMTP id 71so1513177wra
        for <ibatis-user-java@incubator.apache.org>;
 Fri, 11 Mar 2005 06:23:27 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:references;
        b=VG3uwTnjVgY18BBMDLGX2RXmwFZ5wgdrgKPC/BcegKwoV1yb+sTjkO7R3kMjsWioMJPCF/IkZPbd5KXVQDRIxrL9KD0Vh3sPWI0vFA2zTmivxsLcMax0VpH0QBex78Ay8zve8SoUhMSgHUn0QxmMG0lkzhHTtPTGPpsMzafEuPQ=
Received: by 10.54.40.2 with SMTP id n2mr2481371wrn;
        Fri, 11 Mar 2005 06:23:27 -0800 (PST)
Received: by 10.54.31.20 with HTTP; Fri, 11 Mar 2005 06:23:27 -0800 (PST)
Message-ID: <edbccbb90503110623233a3635@mail.gmail.com>
Date: Fri, 11 Mar 2005 09:23:27 -0500
From: Scott Zhu <scottzhu@gmail.com>
Reply-To: Scott Zhu <scottzhu@gmail.com>
To: ibatis-user-java@incubator.apache.org
Subject: Re: Dynamically passing the name of schema to select statement
In-Reply-To: <CD7D5DDE91C4E94182D3D284AA9448AA2FB786@BCMSG111.corp.ads>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
References: <CD7D5DDE91C4E94182D3D284AA9448AA2FB786@BCMSG111.corp.ads>
X-Virus-Checked: Checked
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

You can do something like:
   <select id="someStatementName" remapResults="true"
parameterClass="java.util.Map" resultMap="someResultMap">
      <![CDATA[
      select * from $RuleTable$ where RULE_ACTIVE=1 
      ]]>
   </select>

Then just treat "RuleTable as any other parameter you need to set.
Notice the remapResults="true" is required.


On Thu, 10 Mar 2005 19:42:58 -0800, Rajiv Kumar <Rajiv.Kumar@telus.com> wrote:
> 
> 
> Hello, 
> 
> I have very simple select statement 
> select * from Level_1_Rules where RULE_ACTIVE=1 
> 
> All I want to do is qualify table name with schema name. 
> 
> For every run of my program this schema name is different. 
> 
> 
> Regards, 
> Rajiv Kumar