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]
