When a connection is returned to the pool
PoolableConnectionFactory.passivateObject is called on it:
http://jakarta.apache.org/commons/dbcp/xref/org/apache/commons/dbcp/PoolableConnectionFactory.html#358
As you can see a rollback is done (if needed) and setAutoCommit is
also called. If this pass
I wrote my own connection pool, that I thought was pretty cool, but that was
before I started looking at jakarta commons products. Now it looks pretty
pathetic compared to dbcp, but I did learn a couple things from it that might
you might not have covered.
The big gotcha was the need to rollba