[dbcp] Help Tracking down Problem

[Jonathan Rosenberg <jr...@tabbysplace.org>]

I have a Grails application runnin on Tomcat and using DBCP for two
MySQL datasources.  One is configured by Grails, the other I have
configured "by hand" for various reasons.

As far as I can tell, they're both configured identically:

[MaxActive: 10, MaxIdle: 5, MinIdle: 1, InitialSize: 1,
MinEvictableIdleTimeMillis: 60000, TimeBetweenEvictionRunsMillis:
60000, NumTestsPerEvictionRun: 3, MaxWait: 10000, TestOnBorrow: true,
TestWhileIdle: true, TestOnReturn: false, ValidationQuery: 'SELECT 1']

However, the datasource done by hand dies with this message after the
DB connection si dropped by the DB server:

The last packet successfully received from the server was 228,251
milliseconds ago.  The last packet sent successfully to the server was
0 milliseconds ago.

I added some code to the service that returns a Hibernate session for
this datasource and logged he config parameters for the datasource
attached to the session.  They are exactly as shown above.

Nonetheless, my attempt tpo use that session dies with the error above.

I am at a loss as how to find the problem.

Any ideas?

-
JR

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
For additional commands, e-mail: user-help@commons.apache.org