Howdy, I don't see a factory defined in your server.xml, so you're not really using connection pooling (I think). You're getting a new conn each time.
Verify this by logging connection.toString() every time you get one and watching the memory addresses. Yoav Shapira Millennium ChemInformatics >-----Original Message----- >From: Andoni [mailto:[EMAIL PROTECTED] >Sent: Wednesday, August 06, 2003 11:38 AM >To: Tomcat Users List >Subject: Tomcat Conn Pooling in 4.0.4 - Very Slow? > >Hello, > >I have changed my server's connection pooling from the connection pooling >software which was shipped with the application to using the JNDI >connection pooling in Tomcat 4.0.4. > >The applications database access has slowed down considerably now that this >is implemented. The parts of the application that don't do database access >work fine (or even faster than the old app.) but those that need to do db >access are very slow comparatively. > >Is there something I am missing? Is this what others have found? > >My server.xml looks like below: > >Thanks, > >Andoni. > > > <Context path="" docBase="../myfile.war" debug="0" reloadable="false"> > <Resource name="jdbc/myname" auth="Container" >type="javax.sql.DataSource"/> > <ResourceParams name="jdbc/myname"> > <parameter> > <name>driverClassName</name> > <value>oracle.jdbc.driver.OracleDriver</value> > </parameter> > <parameter> > <name>user</name> > <value>myusername</value> > </parameter> > <parameter> > <name>password</name> > <value>***</value> > </parameter> > <parameter> > <name>driverName</name> > <value>jdbc:oracle:thin:@troi.myserver.com:1521:oracle9i</value> > </parameter> > </ResourceParams> > </Context> This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
