Hi, Newbie, JDBC connection pool question:
My application uses a central control database. This is ok, and I can see how to use a connection pool for my application to access this. BUT... The application allows a user to recover data from a range of additional databases. That is the central database verified logins etc and then lists a number of databases for the user to connect to. I am very unsure how to handle this "sub -connection". I have a number of thoughts... all bad: 1. Set up connection pools to ALL possible databases (there are less than 10), at the start in the application scope. 2. Set up a dedicated connection in the session scope. 3. Set up a dedicated connection in the request scope (cgi style). I don't like any of these answers. Anybody have experience of this sort of "dynamic database connection" or have any thoughts. Regards,
<<application/ms-tnef>>
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
