I've got a project where there's a basic interface, with some basic database access. However, when someone "signs up", then a new MySQL database will be allocated for them. There's security associated with it, and the user will have to log in to identify himself.
How can I create a new connection pool for that new database for my web app? My current pool is set up in context.xml - do I modify that on the fly from my web app? What I'm doing currently is figuring out who the user is and which database he's associated with, and when I do any database work, the first statement is "USE <databasename>" to get the proper database. Is there a better approach? More like a proper approach? (Says he who isn't sure he fully understands connection pools yet....) -- Warrick Wilson [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]