Our J2SE webapp using iBatis with SimpleDataSource running in Apache Tomcat
occasionally starts to hang. It hits the roof of max. Nr. of threads and
looking at the thread dump, there are many threads that seem blocked trying to
get and return(!) connections from and to the pool:
"TP-Processor40
The app is quite critical, it's our customer activation system. It is pretty
serious, and the load is considerable.
We are already considering to go for Apache commons DBCP instead, since we have
only good experience with it in a number of other apps. Your reply supports
this - thanks for that!
A follow up on this issue:
We replaced the SimpleDataSource with Apache Commons DBCP but see the same
issue: The pool is getting in some kind of deadlock state where threads are
blocked while trying to get a lock on the pool in order to return or borrow a
connection to or from the pool. Please
