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: http://n3.nabble.com/Handling-multiple-databases-using-Cayenne-Spring-tp699967p707573.html Sent from the Cayenne - User mailing list archive at Nabble.com.
