/connection-autoReconnect-tp4340944p4989963.html
Sent from the Tomcat - User mailing list archive at Nabble.com.
-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
:
http://tomcat.10.n6.nabble.com/connection-autoReconnect-tp4340944p4989844.html
Sent from the Tomcat - User mailing list archive at Nabble.com.
-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Arnaud,
On 11/20/12 4:23 AM, Arnaud wrote:
> We have been struggling with this MySQL last packet message for
> some times as well. And we are still not sure if we have solved it
> yet.
You can get the "last packet" message for a number of reasons.
Ty
html
<http://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html> and at
dev.mysql.com/doc/refman/5.5/en/connector-j-reference-configuration-properties.html
<http://dev.mysql.com/doc/refman/5.5/en/connector-j-reference-configuration-properties.html>
--
View this message in context:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jerry,
On 1/28/12 8:32 PM, Jerry Malcolm wrote:
> Not good news. I changed every resource statement in server.xml
> to something like this:
>
> type="javax.sql.DataSource" maxActive="100" maxIdle="30"
> maxWait="1" removeAbandoned="true" remove
Answers and comments are inline (mostly).
- Original Message -
> From: Jerry Malcolm <2ndgenfi...@gmail.com>
> To: Tomcat Users List ; Mark Eggers
>
> Cc:
> Sent: Saturday, January 28, 2012 5:32 PM
> Subject: Re: connection autoReconnect?
>
> Not good n
Not good news. I changed every resource statement in server.xml to
something like this:
Zero change. I'm still getting the exact same error message telling me the
connection has expired and I should use autoReconnect to fix it.
First question... is the syntax above correct? (I saw some
- Original Message -
> From: Jerry Malcolm <2ndgenfi...@gmail.com>
> To: Tomcat Users List
> Cc:
> Sent: Thursday, January 26, 2012 2:58 PM
> Subject: Re: connection autoReconnect?
>
>T hanks to all for the assistance. I'll try adding those parameters.
> From: Jerry Malcolm [mailto:2ndgenfi...@gmail.com]
> Subject: Re: connection autoReconnect?
> Basically, TC grabs a handful of connections and
> opens them up.
The Tomcat JDBC pool (not sure about the commons one) opens up whatever is
configured for initialSize.
> Then when a
random connection is provided
from the pool. As long as we're hitting all of the connections often
enough, they never time out. But when things get dormant for a while
connections time out and close. And in TC 5, if the luck of the draw gave
me a closed connection, autoReconnect would fire it b
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dan,
On 1/26/12 12:45 PM, Daniel Mikusa wrote:
> I agree that it looks like you have specified autoReconnect
> correctly, but I'm no expert there.
+1
autoReconnect has been specified properly, but you have to understand
what it does: autoReconnect c
On Thu, 2012-01-26 at 07:46 -0800, Jerry Malcolm wrote:
> I migrated to Tomcat 7.0 a couple of months ago on several servers. Ever
> since moving to 7, I periodically get the following exception on MySql
> calls on all of my 7.0 servers:
>
> Exception: com.mysql.jdbc.exceptions.jdbc4.Communicatio
12 matches
Mail list logo