Jamie,
[Jamie wrote:]
We had some connection problems with MySql not dropping old connections quickly enough, the configuration from the mysql site was quite good (i.e. it solved our problem): http://dev.mysql.com/doc/refman/5.0/en/connector-j-usagenotes-j2ee.html#connector-j-usagenotes-tomcat
I setup my configuration as suggested and still have no luck. I worked out that I could up the JDBC logging by adding a "profileSQL=true" to the JDBC URI.
I'm beginning to suspect that the connections are actually never closed at all.
DSL