I don't think "1000*60" is a valid expression for
timeBetweenEvictionRunsMillis -- at least I've never tried putting math
expressions where an integer constant should be. It should be set to
60000. Also are you keeping your connections in code or closing them
when finished? They should be closed as soon as reasonable so they can
return to the connection pool.
--David
Ken Bowen wrote:
Unfortunately, overnight produced the same Exception, even with the
settings described.
Any other thoughts anyone?
--Ken
On Jul 15, 2008, at 12:34 PM, Ken Bowen wrote:
Definitely a plan. I put the following in my context.xml:
validationQuery="select 1"
testWhileIdle="true"
timeBetweenEvictionRunsMillis="1000*60"
removeAbandoned="true"
I set connect_timeout=5 in /etc/my.cnf, and restarted both mysql and
tomcat.
After 30min, everything's fine, but that's not much of test. I'll
see what it looks like tomorrow morning.
Thanks,
Ken
On Jul 15, 2008, at 10:23 AM, Hassan Schroeder wrote:
On Tue, Jul 15, 2008 at 4:04 AM, Ken Bowen <[EMAIL PROTECTED]> wrote:
The problem: With MySQL connect_timeout = 5, I'm getting timeout
exceptions
(below) even though I have a
validation query set; Here's my app's META-INF/context-xml:
<Context path="" debug="5" reloadable="true" crossContext="true">
<Resource name="jdbc/sb_data" auth="Container"
type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="xxxxxx" password="xxxxxx"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/sb_data"
validationQuery="select 1"/>
<http://commons.apache.org/dbcp/configuration.html>
You might try setting testWhileIdle to true (with a reasonable value
for timeBetweenEvictionRunsMillis) and removeAbandoned to true.
Just to see if that changes/eliminates the symptom...
FWIW,
--
Hassan Schroeder ------------------------ [EMAIL PROTECTED]
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
David Smith
Programmer/Analyst
College of Agriculture and Life Sciences
Cornell University
B32 Morrison Hall
Ithaca, NY 14853
Phone: (607) 255-4521
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]