Apache Geronimo supports the creation of XA database pools, which contain a pool of database connections that can join in XA transactions—that is, they can take part in a two-phase commit process. As there is a need for separate TranQL resource adapters for XA support for each database, Apache Geronimo supports XA with only a limited number of databases.
The databases supported are:
Apache Derby(Derby embedded XA, Derby network XA)
IBM DB2 (DB2 XA)
IBM Informix (In the works)
MySQL (MySQL XA)
Oracle (Oracle XA)
PostgreSQL (PostgreSQL XA)
In order to create an XA database pool, you need to select a database type in the Database Pools portlet as one of the above databases that have XA support, such as Derby embedded XA. The steps after selecting a database type are the same as that for local types except that the transaction type should be selected as XA. There may also be a few extra fields for XA connectors that need to be configured.