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