-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Adam,
AD wrote:
I am trying to troubleshoot an error that seems to occur quite frequently
with no real solution. I constantly see
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link
failure in my application after the
Dear Adam,
2 - use something like DBCP to enforce a validation query for the
connection
from the pool.
Does anyone have any feedback/advise on this issue? It appears to
be quite
common. I am running on Redhat Linux, Tomcat 5.5.26
Perhaps this discussion is useful to you?
Hello,
I am trying to troubleshoot an error that seems to occur quite frequently
with no real solution. I constantly see
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link
failure in my application after the app runs for a few days. Communication
is fine, networking
Christopher Schultz wrote:
Yes, using DataSourceRealm is the preferred configuration.
Thank you for confirming that :)
[...] By the way, there's no reason not
to upgrade to the most recent Connector/J, either.
Sorry.. are you referring to the mysql-connector JAR file? In my
Hi,
I have an existing Tomcat configuration that is working well. However,
it is running version 4.1.31. We are updating the platform, so I
thought I'd take the opportunity to update Tomcat. Unfortunately (??) I
must stick with the Tomcat 4.1 release.
I have a test machine on which I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Robert,
Robert Jacobson wrote:
| I was authenticating using a mysql database through the JDBCRealm. I
| found some posts in the archives (
|
http://www.mail-archive.com/[EMAIL PROTECTED]/msg149130.html)
| indicating that switching from the
The DatasourceRealm will work. Drop the autoReconnect parameter from
the database url though as it's not recommended by the MySQL folks.
Instead, add a validationQuery to your ResourceParams so database
connections are tested briefly before they are borrowed from the pool.
The query can be