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.