Hi!
I have (better had) a working web-application running on my debian
system (stable/woody, Tomcat 4.0.4, Mysqld 3.23.49, j2sdk 1.4.1,
mysql-connector-java-3.0.8).
After a reboot of the system (patched the kernel) I now get the
following error message:
java.sql.SQLException: Server connection failure during transaction.
Attempted reconnect 3 times. Giving up.
It seems like the connection pooling doesn't even try to contact my
mysqld - at least I can't see any entry in my logs.
Desperatly playing around I found out, that if I disable
autoreconnecting in the server.xml I get at least another error
(java.sql.SQLException: Server configuration denies access to data
source). Any other change - even obviously wrong username,ports -
doesn't have any effect.
Since I didn't change anything in my configuration files (the
application worked in public for about 4 weeks now) I'm not sure where
to search the error. Googling I found hints on too many open connections
- but too many open connections? After completly rebooting the server?
Does anybody have a glue where to search the problem? Or any hints how
to anlayze/debug the malicious interaction beetwen my application, the
DataSourceFactory and the mysqld?
I'm attaching the relevant parts of my server.xml:
Thanks in advance.
Niko
<Resource auth="Container" description="JDBC Resource for
the stamm-DB on localhost" name="jdbc/stamm"
scope="Shareable"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/stamm">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<!-- Maximum number of idle dB connections to retain in pool.
Set to 0 for no limit.
-->
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<!-- MySQL dB username and password for dB connections -->
<parameter>
<name>username</name>
<value>user</value>
</parameter>
<parameter>
<name>password</name>
<value>secret</value>
</parameter>
<!-- Class name for mm.mysql JDBC driver -->
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/stamm?autoReconnect=true</value>
</parameter>
</ResourceParams>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
