--- Robert Bateman <[EMAIL PROTECTED]> wrote: > Chuck, > > I think you need to move your connection pooling over to your context.xml at > the web application level. Here is my pool definition from one of my apps: > > <Resource name="jdbc/MySQL_Sequoia_Admin" > scope="Shareable" > type="javax.sql.DataSource"/> > <ResourceParams name="jdbc/MySQL_Sequoia_Admin"> > <!-- The JDBC connection url for connecting to your MySQL dB. > The autoReconnect=true argument to the url makes sure that the > mysql JDBC Driver will automatically reconnect if mysqld closed the > connection. mysqld by default closes idle connections after 8 hours. > --> > <parameter> > <name>url</name> > <value>jdbc:mysql://localhost:3306/Sequoia_Admin?autoReconnect=true,maxReconnects=3</value> > > </parameter> > <!-- MySQL dB username and password for dB connections --> > <parameter> > <name>username</name> > <value>xxxxx</value> > </parameter> > <parameter> > <name>password</name> > <value>xxxx</value> > </parameter> > <!-- Maximum number of dB connections in pool. Make sure you > configure your mysqld max_connections large enough to handle > all of your db connections. Set to 0 for no limit. --> > <parameter> > <name>maxActive</name> > <value>100</value> > </parameter> > <!-- Maximum time to wait for a dB connection to become available > in ms, in this example 15 seconds. An Exception is thrown if > this timeout is exceeded. Set to -1 to wait indefinitely. --> > <parameter> > <name>maxWait</name> > <value>15000</value> > </parameter> > <!-- Validation Query to insure our connection is still valid. --> > <parameter> > <name>validationQuery</name> > <value>SELECT version()</value> > </parameter> > <!-- Make sure we test each and every connection before we borrow > it to see if it is still valid. --> > <parameter> > <name>testOnBorrow</name> > <value>true</value> > </parameter> > <parameter> > <name>driverClassName</name> > <value>com.mysql.jdbc.Driver</value> > </parameter> > <!-- Maximum number of idle dB connections to retain in pool. > Set to 0 for no limit. --> > <parameter> > <name>maxIdle</name> > <value>100</value> > </parameter> > <parameter> > <name>removeAbandoned</name> > <value>true</value> > </parameter> > <!--Use the removeAbandonedTimeout parameter / seconds.--> > <parameter> > <name>removeAbandonedTimeout</name> > <value>60</value> > </parameter> > <parameter> > <name>logAbandoned</name> > <value>true</value> > </parameter> > </ResourceParams> > > > it may not be perfect, but it works on our end. > > > Hope that helps! > > Bob
Thanks, I give that a shot... -rhugga ===== Chuck Carson - Sr. Systems Engineer Syrrx, Inc. - www.syrrx.com 10410 Science Center Drive San Diego, CA 92121 Work: 858.731.3540 Fax: 858.550.0526 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
