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:[EMAIL PROTECTED]] 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:[EMAIL PROTECTED]] 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:[EMAIL PROTECTED]] > Sent: Friday, July 05, 2002 4:54 PM > To: [EMAIL PROTECTED] > 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: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
