Re: What is the best way to get data from 2 different database having same table names

2005-12-28 Thread Nathan Maves
SMC is short hand for SqlMapClient. If you look at the API you will see that there is a method in the SqlMapClientBuilder class that takes a properties object. This properties can have the different connection information that you need to connect to different databases. What we are sugg

Re: What is the best way to get data from 2 different database having same table names

2005-12-28 Thread Ashish Kulkarni
Larry What is SMC and how do i create it? suppose i have a SQL statement like select * from myname.table1 and similarly have some thing like select * from diffname.table1 how do i on the fly execute one of the querries depending on user selection. table1 has same layout Ashish --- Larry Mead

Re: What is the best way to get data from 2 different database having same table names

2005-12-22 Thread Nathan Maves
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 da

Re: What is the best way to get data from 2 different database having same table names

2005-12-22 Thread Larry Meadors
When you create a sql map client, you can pass in a properties object...that works just exactly like the tag in the sql map config xml file. So, prompt the user, then create a SMC for them based on their selection - if you wanted to, you could store the SMC in application scope based on the key (