tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mihai Gheorghiu" <tane...@earthlink.net>
Subject Re: JDBC Connection Pool Theory ??
Date Fri, 21 Sep 2001 17:18:21 GMT
I've been looking at some pooling examples and I must admit I'm still not
clear whether it is possible to have db connections with the username and
password of the web/java user, or the database "sees" n connections with the
same username and password  generated by the pool manager. I want the
web/java usernane and pwd to be passed to the db for logging/signing
purposes. Can anyone please point me to some relevant
documentation/tutorial?
Thank you all.

-----Original Message-----
From: C. Schlegelmilch <c_schlegelmilch@yahoo.com>
To: tomcat-user@jakarta.apache.org <tomcat-user@jakarta.apache.org>
Date: Friday, September 21, 2001 12:19 PM
Subject: Re: JDBC Connection Pool Theory ??


>We had our web development class develop their own
>software for connection pooling.  These are extremely
>simple soluitons but they work quite well for the
>small to medium traffic they are likely to get.
>
>They are using "Professional Java Server Programming"
>as a reference and it has some interesting sections on
>Connection Pooling.  This is good if you're only
>running a simple application.  It was also noted that
>this resource did not address any synchronization
>issues which is very important (the last thing you
>want is two seperate threads getting a reference to
>the next free connection at the same time).  This is
>really the only big gottcha that we found in a simple
>implementation.
>
> --- Jon Shoberg <jshoberg@cbd.net> wrote: >
>> Can anyone suggest or point to readings on JDBC
>> connection pool theory?
>> Something that covers how a pool is implemented,
>> best case / worst case
>> scenarios, tips and traps.
>>
>> My next web application is looking to be very
>> database (mysql) intensive.
>> I would like a pooling mechanism that is VERY simple
>> to use, VERY light, low
>> overhead, and portable.  Having looked at packages
>> such as poolman, I
>> decided I need to learn a bit more about JDBC and
>> pooling in general.  Any
>> thoughts ?
>>
>> Jon
>>
>
>____________________________________________________________
>Do You Yahoo!?
>Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
>or your free @yahoo.ie address at http://mail.yahoo.ie


Mime
View raw message