JTA aware JDBC connection pools
NickName:Dev Ask DateTime:2011-01-15T12:03:24

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?

Copyright Notice：Content Author:「Dev」，Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/4697919/jta-aware-jdbc-connection-pools

Answers
gargii 2011-11-30T12:59:52

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.\n\nRecently I was facing the same problem and finally I ended up with Bitronix and its integrated connection pool. It works well.",

Products recommended by Amazon
More >>>
SanDisk 128GB microSDXC-Card, Licensed for Nintendo-Switch - SDSQXAO-128G-GNCZN
SanDisk 128GB microSDXC-Card, Licensed for Nintendo-Switch - SDSQXAO-128G-GNCZN
 HUANUO Dual Monitor Stand - Adjustable Spring Monitor Desk Mount Swivel Vesa Bracket with C Clamp, Grommet Mounting Base for 13 to 27 Inch Computer Screens - Each Arm Holds 4.4 to 14.3lbs
HUANUO Dual Monitor Stand - Adjustable Spring Monitor Desk Mount Swivel Vesa Bracket with C Clamp, Grommet Mounting Base for 13 to 27 Inch Computer Screens - Each Arm Holds 4.4 to 14.3lbs
 AMD Ryzen 5 5600X 6-core, 12-Thread Unlocked Desktop Processor with Wraith Stealth Cooler
AMD Ryzen 5 5600X 6-core, 12-Thread Unlocked Desktop Processor with Wraith Stealth Cooler
 Timberland Men's 6-Inch Premium Waterproof Boot
Timberland Men's 6-Inch Premium Waterproof Boot
More about “JTA aware JDBC connection pools” related questions
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...

Show Detail
Using special JDBC driver features with dynamic proxy connection pools

We are evaluating a JTA transaction manager for a legacy Oracle JDBC project and have looked at Bitronix and Atomikos so far. The java.sql.DataSource implementations of both the Bitronix and Atomi...

Show Detail
Flushing JDBC connection pools

Does anyone know the best (or any) way to flush a JDBC connection pool? I can't find anything obvious in the documentation. It appears connection pools aren't meant to ever be deleted. My current

Show Detail
How do you determine if a JDBC Connection was retrieved from a JTA enabled DataSource or straight JDBC?

I'm using a vendor API to obtain a JDBC connection to the application's database. The API works when running in the application server or when running in a stand-alone mode. I want to run a series ...

Show Detail
Should Hystrix replace existing JDBC/HTTP connection pools, or delegate to them?

Many applications use connection pools for both HTTP and JDBC calls for resiliency. But using and configuring these 2 types of pools is very different. This duplicates the complexity of implementing

Show Detail
Monitoring JDBC connection pools

I'm connecting my Java application via JDBC driver and Tomcat configurations. I used this class to define my configurations. But sometimes, I got following exceptions: com.mysql.jdbc.exceptions.

Show Detail
What are the relationships between JTA provider like Atomikos and connection pool like HikariCP?

I'm reading Java Persistence with Hibernate, and I found the following text. Today, high-quality standalone JTA providers such as Bitronix (used for the example code of this book) and Atomikos are

Show Detail
JPA with JTA transactions - get the JDBC connection

This is my class: @Stateless public class MyClass { @Inject UserTransaction tx; @PersistenceContext EntityManager em; public void myMethod() throws Exception { try {...

Show Detail
MySQL implementation of connection pools

Does MySQL jdbc driver has built in support for database connection pools? (like Oracle has OracleDataSource class) I did a thorough search but couldn't find any. I know that I can use external

Show Detail
Hibernate/JTA Transaction cannot proceed: STATUS_COMMITTED when trying to close connection

I enabled Hibernate logs to DEBUG and noticed that it was having troubles with respect to releasing the connections - 2018-10-09 16:33:26,217 TRACE [default task-14]-[org.hibernate.resource.jdbc.

Show Detail