Re: how to use ibatis to get data from multiple databases

2007-02-14 Thread Ashish Kulkarni
Hi Is there any source code for using properties when creating sql map client Ashish On 2/13/07, Larry Meadors [EMAIL PROTECTED] wrote: Use a properties object when you create the sql map client. Larry On 2/13/07, Ashish Kulkarni [EMAIL PROTECTED] wrote: Hi I have a web application where

how to use ibatis to get data from multiple databases

2007-02-13 Thread Ashish Kulkarni
Hi I have a web application where i am using ibatis, i have a situation where i want to select the database from where i want to get data. In this application user will login and select he wants to use development 1, or development 2 or test 1 from a drop down So if the user selects

Re: how to use ibatis to get data from multiple databases

2007-02-13 Thread Larry Meadors
Use a properties object when you create the sql map client. Larry On 2/13/07, Ashish Kulkarni [EMAIL PROTECTED] wrote: Hi I have a web application where i am using ibatis, i have a situation where i want to select the database from where i want to get data. In this application user will

Re: how to use ibatis to get data from multiple databases

2007-02-13 Thread Jonathan Chase
Although this would require the use of the Spring Framework, it provides a pretty transparent way to do what you're asking: http://blog.interface21.com/main/2007/01/23/dynamic-datasource-routing/ You could probably adapt the idea pretty easily and get rid of the Spring dependencies if that is