tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jacob Kjome <>
Subject Re: Connection pooling doesn't work for me ... Help !!
Date Fri, 14 Jun 2002 06:08:19 GMT
The definitive solution has been provided by Leslie Hughes 
<> here:

That is for the following configuration:

Tomcat      4.0.3 LE JDK 1.4 Build
mySQL      4.0.1 alpha
mm.mysql 2.0.14

Jakarta-Commons projects
DBCP     Nightly Build 20020523 (Note:  I'd grab the latest 4.1.3 beta 
stuff rather than the nightly here)
collections 2.0
pool           1.0

Install instructions and configuration is provided.

Just to note, I've been using this for Oracle8i with classes12.jar in 
TOMCAT_HOME/common/lib and Tomcat 4.1.3 with the configuration described in 
the link above and everything works just peachy.  In addition, I provided a 
snippet of code that I use to access the DataSource here:

Really, truly, this works.  No need for fancy workarounds like 
ConnectionPoolDataSource or directly using Oracle's connecion pool.  Just 
note that the configuration provided may differ slightly from the docs.  An 
example is the docs refer to the "user" parameter.  Leslie used "username" 
and that works.

So, please, do yourselves a favor and ignore the docs for a bit on this 
one.  Copy the configuration line for line that Leslie has provided.  Then, 
of course, change the values to match your setup.  I *guarantee* this works 
and it is the standard way it is supposed to be done.  Maybe this 
DataSource thread can finally be put to rest?


At 06:39 AM 6/14/2002 +0100, you wrote:
>Nikola Milutinovic wrote:
>>>Note that I've used the ConnectionPoolDataSource class - not sure if
>>>this makes a difference.
>>Well, yes and no. The actual class should be CPDS, but your application 
>>shouldn't specifically ask for it, but for DataSource. The container will 
>>use CPDS and cast it to DS for your use.
>Yes, I'm not using that class in my code, I'm just using DataSource. I was 
>referring to the setup in server.xml.
>Neil Milne                              Hippo IT Consultants Ltd
>To unsubscribe, e-mail:   <>
>For additional commands, e-mail: <>

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message