I'm still curious about the crazy logAbandoned messages - not sure how to
interpret or rely on them. I'll try a again with a briefer posting - maybe I
was too detailed in the original post.
We are getting strange (erroneous?) messages because of the logAbandoned
parameter:
1) The dates look like they are from lalaland (e.g. a date of
April 34,2006 in the second line below).
Maybe I do not understand how remove abandoned is working - the
timeout is supposed to start once a connection is determined to be
"idle".
2) Second the abandoned objects do not appear to be in order -
they jump from 10:23 to 13:34, 13:01, 13:35, back to 10:29 (see below).
Here is an extract/grep from our catalina.out:
DBCP object created 2006-23-04 10:23:35 by the following code was never
closed:
DBCP object created 2006-34-04 13:34:55 by the following code was never
closed:
DBCP object created 2006-01-04 13:01:49 by the following code was never
closed:
DBCP object created 2006-35-04 13:35:00 by the following code was never
closed:
DBCP object created 2006-29-04 10:29:21 by the following code was never
closed:
DBCP object created 2006-36-04 13:36:39 by the following code was never
closed:
DBCP object created 2006-23-04 10:23:35 by the following code was never
closed:
DBCP object created 2006-36-04 13:36:43 by the following code was never
closed:
DBCP object created 2006-01-04 13:01:49 by the following code was never
closed:
DBCP object created 2006-36-04 13:36:56 by the following code was never
closed:
DBCP object created 2006-40-04 13:40:30 by the following code was never
closed:
DBCP object created 2006-15-04 15:15:02 by the following code was never
closed:
DBCP object created 2006-15-04 15:15:02 by the following code was never
closed:
DBCP object created 2006-11-04 14:11:46 by the following code was never
closed:
DBCP object created 2006-00-04 16:00:01 by the following code was never
closed:
DBCP object created 2006-00-04 16:00:01 by the following code was never
closed:
DBCP object created 2006-39-04 13:39:55 by the following code was never
closed:
DBCP object created 2006-00-04 16:00:02 by the following code was never
closed:
DBCP object created 2006-00-04 16:00:02 by the following code was never
closed:
DBCP object created 2006-11-04 14:11:46 by the following code was never
closed:
DBCP object created 2006-26-04 16:26:18 by the following code was never
closed:
DBCP object created 2006-26-04 16:26:18 by the following code was never
closed:
DBCP object created 2006-26-04 16:26:18 by the following code was never
closed:
And, here's the relevant portion of our server.xml:
<Host name="acme.com" debug="0" autoDeploy="false"
appBase="/home/httpd/vhosts/acme.com">
<Alias>www.acme.com</Alias>
<Logger className="org.apache.catalina.logger.FileLogger"
directory="logs" prefix="acme.com_log."
suffix=".txt"
timestamp="true"/>
<Context path="" docBase="httpdocs" reloadable="true" debug="0">
<Resource name="jdbc/acme.com" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/acme.com">
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost/acme?autoReconnect=true&zeroDateTimeBehavi
or=convertToNull&noDatetimeStringSync=true</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>
<parameter>
<name>username</name>
<value>acme</value>
</parameter>
<parameter>
<name>password</name>
<value>secret</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>60</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
</ResourceParams>
</Context>
</Host>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
