Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Date: Thu, 22 Dec 2005 08:42:24 -0700
From: Nathan Maves <Nathan.Maves@Sun.COM>
Subject: Re: What is the best way to get data from 2 different database having
 same table names
In-reply-to: <20051222142748.65756.qmail@web32815.mail.mud.yahoo.com>
Sender: Nathan.Maves@Sun.COM
To: user-java@ibatis.apache.org
Message-id: <22F2121F-9C0D-4E0E-890F-EFAAC0898A56@sun.com>
MIME-version: 1.0
Content-type: text/plain; format=flowed; delsp=yes; charset=US-ASCII
Content-transfer-encoding: 7BIT
References: <20051222142748.65756.qmail@web32815.mail.mud.yahoo.com>

Simple dirty way would be to use the string substitution for the  
table name ($tableName$).  If it is anything more the one query that  
might need this I would think about using multiple contexts.


On Dec 22, 2005, at 7:27 AM, Ashish Kulkarni wrote:

> Hi
> I have a situation, in which i have 2 database on
> suppose DB2, first database is Test1, and second is
> Test2.
>
> There is table called names in both databases.
>
> I have created JNDI connection in tomcat.
>
> Now in my website i want to give user a option to
> select one of the 2 JNDI connection, and then i must
> be able to run query against that database.
>
> For example , if the user selects JNDI ( i will show
> some meaningful name) for Test1 then get the data from
> names in database Test1.
>
> What is the best way of doing this, if i am using
> ibatis SQL Map and DAO
>
> Ashish
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com