- Do you close the Session ?
- Do you execute native SQL statemenents (creaeteSQL query) and have some lingering connections ?
- Do you use more connections at once than are availble in the Pool and have long running operations (e.g. reporting)
- Do the connections "die" in the Pool (e.g. they become invalid trough timeout) ? I once had problems with an older version of MySQL where i had to sepcify special parameters in the
JDBC)
Pascal