-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
> 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
,
>
> 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
> >>
-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
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
> 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
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
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
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.