Couple ways to deal with this. First, for multiple databases you will need an instance of SqlMapClient for each (i.e. 3 databases means 3 instances of SqlMapClient). Do not attempt to share the same SqlMapClient instance accross databases.
As for runtime configuration, you can achieve this at least two ways. Firs, you can create an instance of SqlMapClient using the SqlMapClientBuilder as always, but you pass a properties instance (with your connection string) as the second parameter to the build method. See the docs for more. Another way to deal with multiple databases (depending on your needs) is to bypass the SqlMaps datasource configuration entirely, and instead set a user connection (use SqlMapClient.setUserConnection() or .openSession(Connection)). See the docs for more. Cheers, Clinton On Tue, 14 Dec 2004 16:50:48 +0200, Alexey Boroday <[EMAIL PROTECTED]> wrote: > Hello. > > Could you help me please - I'd like to configure dataSource connection > string in the run-time instead of storing it in the sqlmap.config file. > How can I fill this property in runtime? > > And one more - application should be able read data from two separate > databases and write it into the third one. Tell me please - is it possibly > to have two database elements in the sqlmap.config? Or I should define three > dataSource elements inside one database? > How can I run QueryForList method to make it returns object list from one > database if in the config file three dataSource are enumerated? > > Thank you > > ___________________________________________________________________________ > > This communication is confidential and may be legally privileged. > If you believe you are not an intended recipient, please inform the sender, > delete the e-mail and do not copy, print or use it or disclose it to others. > You can inform the sender by replying to this e-mail or by telephone (+380 44 > 4906080). > >
