tomcat-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Glenn Nielsen <gl...@voyager.apg.more.net>
Subject Re: Tomcat 4.1-dev and commons-dbcp sql timeout problems
Date Wed, 06 Feb 2002 01:50:55 GMT
I found a solution for this problem, thought I would update this posting
in case anyone else needs to solve this.

The problem with SQLExceptions due to an SQL timeout was due
to the MySQL JDBC driver.  Adding "?autoReconnect=true" to the
MySQL JDBC connect URL solved the problem.  We were only seeing
the timeout bug after mysqld would drop a connection after 8 hours
of inactivity.

We did some load testing using DBCP and had no problems running up to 1000
connections per minute.  We now have DBCP in production using JNDI named
DataSource's for several applications, including one which uses Castor JDO.
Seems to be working fine.

Regards,

Glenn

Glenn Nielsen wrote:
> 
> I tried using DBCP instead of tyrex for a JNDI named JDBC DataSource
> in Tomcat 4.1-dev for several days.  Castor JDO is used between the
> applicaton and the db.  With Tyrex everything works fine, with DBCP
> we get SQLTimeoutException's periodically.  This is using MySQL
> 3.23 with InnoDB tables and the latest mm.mysql jdbc driver.
> 
> Has anyone else experienced lost connections resulting in SQLTimeoutException's
> when using DBCP?
> 
> Regards,
> 
> Glenn
> 
> ----------------------------------------------------------------------
> Glenn Nielsen             glenn@more.net | /* Spelin donut madder    |
> MOREnet System Programming               |  * if iz ina coment.      |
> Missouri Research and Education Network  |  */                       |
> ----------------------------------------------------------------------
> 
> --
> To unsubscribe, e-mail:   <mailto:tomcat-dev-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail: <mailto:tomcat-dev-help@jakarta.apache.org>

-- 
----------------------------------------------------------------------
Glenn Nielsen             glenn@more.net | /* Spelin donut madder    |
MOREnet System Programming               |  * if iz ina coment.      |
Missouri Research and Education Network  |  */                       |
----------------------------------------------------------------------

--
To unsubscribe, e-mail:   <mailto:tomcat-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-dev-help@jakarta.apache.org>


Mime
View raw message