i have the same problem with jboss 3.2.5 and mysql.. my availableConnectionsCount is decreasing over time. I added the
<check-valid-connection-sql> tag to the datasource service but, the decreasing of the connection pool did not stop. after 3 days my application throws "get no managed connection" exceptions and fails until restart of jboss. the jboss is on productive use :-(
can somebody help me or give me some hints ?
Did you ever resolve this issue as I have the same problem on my production server?