JTA aware JDBC connection pools

I've been looking at a number of 开发者_运维技巧JDBC connection pools, but I have the specific requirement that the pool needs to be JTA aware, which leaves me with a short list of Apache DBCP and OW2 XAPool. The other pools I looked (c3p0, Proxool, BoneCP) at did not appear to satisfy the JTA requirement.

Does anyone have a recommendation about either XAPool, DBCP, or a connection pool I have not mentioned here?

Some standalone transaction managers like Atomikos or Bitronix have their own integrated connection pool. Such a pool is JTA compliant and would solve your problem.

Recently I was facing the same problem and finally I ended up with Bitronix and its integrated connection pool. It works well.

If timelines permit and there's this requirement, I can add JTA support to BoneCP if you want.

Wallace (BoneCP author)