cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Kienenberger <>
Subject Re: Handling multiple databases using Cayenne+Spring
Date Fri, 09 Apr 2010 12:06:50 GMT
If you write a custom DataSourceFactory and DataSource, you can have
your DataSource dynamically choose which connection information to
provide based on the current user.

On Thu, Apr 8, 2010 at 11:41 PM, Sudheer <> wrote:
> Hi Andrus,
> Thank you for the respone
> There is little catch in our existing design. Here is the design
> My application interacts with it Manger applications (could be more than
> one) that are running either on SQL server or Oracle. Schema is same for
> both the vendors. Manager application actually holds information about it's
> database connection.
> User who is using my application will be one Manager at a time. So, when
> user login to my application, system connects to the manager he is
> intereted, bring all connection details and keep them in HTTPSession. For
> Cayenne, I would like to keep DataContext in HTTPSession so that it will be
> user specific.
> I could not understand your previous response. After setting DataSource on a
> node and keeping DataContext in HttpSession affects all other users as well?
> What happens on below scenario?
> Using my application User A can connecto Manager A that is running on SQL
> Server Database.
> Using my application User B can connect to Manager B that is running on
> Oracle.
> If possible can I have sample code or examples for Spring+Cayenne
> integration. Unfortunately I am new to Spring as well :(
> I hope you understand my text :)
> Thank You
> Sudheer
> --
> View this message in context:
> Sent from the Cayenne - User mailing list archive at

View raw message