Pooled JDBC Connections

[Frank Apap <fs...@optonline.net>]

Does Tomcat version 3.3 or version 4.0 have support (built-in) for
database pooling?  If so does anyone have any doc's on how to set this
up?
 
Thanks in advance.
Frank
 

RE: Pooled JDBC Connections

[Steve Ahlstrom <sa...@americanisp.net>]

After much head scratching and misleading messages in the archive, lots of
trial and error, and several bouts of cussing, I got pooling to work
last night (using Tomcat 4.04 and mySQL).

You need a jdbc driver (I'm using mm.mysql-2.0.14-bin.jar, obviously for
mySQL).

You also need commons-collections.jar, commons-dbcp.jar, and
commons-pool.jar.
These can be found deep in the unfriendly pages on jarkata.apache.org as
part
of a subproject for Tomcat.

Take these 4 jar files and place them in $CATALINA_HOME/common/lib.

Then take a look at one of the archive messages found at
http://marc.theaimsgroup.com/?l=tomcat-user&m=102225547106556&w=2

This will show you what you need in your server.xml file (replace
your own database username and password for his examples).

Good luck and try getting inventive with the cussing, it helps.

Steve

-----Original Message-----
From: Frank Apap [mailto:fsa3@optonline.net]
Sent: Saturday, July 06, 2002 12:05 AM
To: 'Tomcat Users List'
Subject: RE: Pooled JDBC Connections


I have searched them, although I do find some stuff its very
contradicting and unclear.  Some of the messages mention needing 3rd
party software while others talk about built-in tomcat support (although
I only found this for version 4.x).  A more definitive answer on this
would be GREATLY appreciated.

Frank


-----Original Message-----
From: William Gustave [mailto:wgustave@verizon.net]
Sent: Friday, July 05, 2002 7:51 PM
To: Tomcat Users List
Subject: RE: Pooled JDBC Connections

Search the archives..

> -----Original Message-----
> From: Frank Apap [mailto:fsa3@optonline.net]
> Sent: Friday, July 05, 2002 4:54 PM
> To: tomcat-user@jakarta.apache.org
> Subject: Pooled JDBC Connections
>
>
> Does Tomcat version 3.3 or version 4.0 have support (built-in) for
> database pooling?  If so does anyone have any doc's on how to set this
> up?
>
> Thanks in advance.
> Frank
>
>

--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>


--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>





--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

RE: Pooled JDBC Connections

[Frank Apap <fs...@optonline.net>]

I have searched them, although I do find some stuff its very
contradicting and unclear.  Some of the messages mention needing 3rd
party software while others talk about built-in tomcat support (although
I only found this for version 4.x).  A more definitive answer on this
would be GREATLY appreciated.

Frank


-----Original Message-----
From: William Gustave [mailto:wgustave@verizon.net] 
Sent: Friday, July 05, 2002 7:51 PM
To: Tomcat Users List
Subject: RE: Pooled JDBC Connections

Search the archives..

> -----Original Message-----
> From: Frank Apap [mailto:fsa3@optonline.net]
> Sent: Friday, July 05, 2002 4:54 PM
> To: tomcat-user@jakarta.apache.org
> Subject: Pooled JDBC Connections
> 
> 
> Does Tomcat version 3.3 or version 4.0 have support (built-in) for
> database pooling?  If so does anyone have any doc's on how to set this
> up?
>  
> Thanks in advance.
> Frank
>  
> 

--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

RE: Pooled JDBC Connections

[William Gustave <wg...@verizon.net>]

Search the archives..

> -----Original Message-----
> From: Frank Apap [mailto:fsa3@optonline.net]
> Sent: Friday, July 05, 2002 4:54 PM
> To: tomcat-user@jakarta.apache.org
> Subject: Pooled JDBC Connections
> 
> 
> Does Tomcat version 3.3 or version 4.0 have support (built-in) for
> database pooling?  If so does anyone have any doc's on how to set this
> up?
>  
> Thanks in advance.
> Frank
>  
> 

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>