Hi, i had the same problems with jtds jdbc driver and ms sql server (and it was driving me crazy).
The problem described shortly: The sql server closes connections and the jdbc driver throws an exception. This exception is not recognized by the jdbc pooling component. The connection gets lost, but the jdbc pool doesn't know it. This occurs till your max connection number is exceed and then your application hangs when requesting a datasource from the pool. A solution is to upgrade your excalibure datasource to a recent version. Look under http://cvs.apache.org/viewcvs.cgi/avalon-excalibur/datasource/src/java/org/a pache/avalon/excalibur/datasource/AbstractJdbcConnection.java revision 1.30 fixes this bug. hth, Frank
