ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nathan Maves <Nathan.Ma...@Sun.COM>
Subject Re: What is the best way to get data from 2 different database having same table names
Date Thu, 22 Dec 2005 15:42:24 GMT
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

View raw message