Re: Implementing Connection Pooling

2010-07-02 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Chuck, On 7/2/2010 8:27 AM, Caldarale, Charles R wrote: > > From: Andrew Laughlin [mailto:andrew.laugh...@gmail.com] Subject: >> Re: Implementing Connection Pooling >> >> Because I won't have this info until run-tim

RE: Implementing Connection Pooling

2010-07-02 Thread Caldarale, Charles R
> From: Andrew Laughlin [mailto:andrew.laugh...@gmail.com] > Subject: Re: Implementing Connection Pooling > > Because I won't have this info until run-time. Which means you can't configure the appropriate elements. > It appears Apache Commons has a GenericObjectPo

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 Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Chuck, 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 specifie

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 Caldarale, Charles R
> From: Andrew Laughlin [mailto:andrew.laugh...@gmail.com] > Subject: Re: Implementing Connection Pooling > > The credentials for a database connection are specified per > database. That is, user credentials are not used to get an > authenticated connection to the database

Re: Implementing Connection Pooling

2010-07-01 Thread Andrew Laughlin
Thanks for responding Mikolaj. I may not completely understanding your response. The credentials for a database connection are specified per database. That is, user credentials are not used to get an authenticated connection to the database. Notice OrgID is the database name, username and passw

Re: Implementing Connection Pooling

2010-07-01 Thread Mikolaj Rydzewski
Andrew Laughlin wrote: Notice no username or password entry exists. Here's the code to get a connection: Context ctx = new InitialContext(); org.apache.tomcat.dbcp.dbcp.BasicDataSource ds = (org.apache.tomcat.dbcp.dbcp.BasicDataSource)ctx.lookup( "java:comp/env/jdbc/DB" ); // These must be set

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.