cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sudheer <>
Subject Re: Handling multiple databases using Cayenne+Spring
Date Fri, 09 Apr 2010 03:41:38 GMT

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

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

View this message in context:
Sent from the Cayenne - User mailing list archive at

View raw message