ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <lmead...@apache.org>
Subject Re: How can I change datasource connect info on the fly w/iBATIS and Spring?
Date Fri, 13 Apr 2007 18:34:11 GMT
You could implement a custom datasource and datasource factory to
switch it on the fly, but I think you'd have troubles with things like
caching, etc.

A safer implementation would have two sql map clients - one per
datasource that you swapped instead.


On 4/13/07, Paul Sanders <tendancer@gmail.com> wrote:
> One of the characteristics of my application is that the datasource
> connection information can be supplied by the user, and I wonder if anyone
> has any advice on how to handle that?
> Currently I define a datasource in my applicationcontext with default
> information (my test db) and specify my BanPolicyDAO object, letting Spring
> inject the datasource. All works well with my new BanPolicy configuration
> (that you've all seen over and over this week!).
> I searched the archives for dealing with multiple datasources but all the
> responses seemed to be in the case when you knew the connection info in
> advance. In my case I need to create a new datasource on the fly, or be able
> to change the settings of the existing one. So far my efforts haven't worked
> - the DAO only ever uses the original connection info.
> Anyone tried this, or have have any thoughts on the best way to do it?
> Cheers
> Paul
> --
> View this message in context: http://www.nabble.com/How-can-I-change-datasource-connect-info-on-the-fly-w-iBATIS-and-Spring--tf3573169.html#a9983995
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

View raw message