Re: Implementing Connection Pooling

2010-07-01 Thread Andrew Laughlin
, > > On 7/1/2010 6:06 PM, Caldarale, Charles R wrote: > >> From: Andrew Laughlin [mailto:andrew.laugh...@gmail.com] > >> Subject: Re: Implementing Connection Pooling > >> > >> The credentials for a database connection are specified per > >>

Re: Implementing Connection Pooling

2010-07-01 Thread Andrew Laughlin
alk me through were I'm going wrong? On Thu, Jul 1, 2010 at 3:06 PM, Caldarale, Charles R < chuck.caldar...@unisys.com> wrote: > > From: Andrew Laughlin [mailto:andrew.laugh...@gmail.com] > > Subject: Re: Implementing Connection Pooling > > > > The credentia

Re: Implementing Connection Pooling

2010-07-01 Thread Andrew Laughlin
me, previously MySql authenticated connection to the database as user A, this is the desired behaviour. The application will still authenticate user B at a higher level. The logic shown simply attempts to employ connection pooling a bit dynamically. 2010/7/1 Mikolaj Rydzewski > Andrew Laughli

Implementing Connection Pooling

2010-07-01 Thread Andrew Laughlin
Just started using Tomcat 6.0.26 connected to MySQL 5.1. The MySql server contains a database for each organization. Each user that logs in, specifies an organization and is directed to the corresponding DB. I would like to employ connection pooling, with a small pool allocated to each database.