When you create a sql map client, you can pass in a properties object...that works just exactly like the <properties /> 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 (test1 or test2), and get it from there. Larry On 12/22/05, Ashish Kulkarni <[EMAIL PROTECTED]> 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 >
