You could have one SqlMapper config file and change the datasource from 1 to 2 with someting as http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+set+the+ connection+string+per+user+in+Web+context
On 3/16/07, Wei Cheng <[EMAIL PROTECTED]> wrote:
This maybe discussed here before but I did not see a clear solution so far. I need to access multiple data source at the same time, reading from DateSource1 and wrting to DataSource2. Two questions: 1) Do I have to use two mapper "config" files for this? There are objections among teammates to have two SqlMapper config files 2) Could the connection string of a SqlMapper instance be assigned/changed OUTSIDE the config file at runtime? Thanks for the information! Wei Cheng Canada ____________________________________________________________________________________ Finding fabulous fares is fun. Let Yahoo! FareChase search your favorite travel sites to find flight and hotel bargains. http://farechase.yahoo.com/promo-generic-14795097
-- Cheers, Gilles <a href="http://www.amazon.com/gp/registry/6JCP7AORB0LE">Wish List</a>

