||Adding Transactions to Servlets with JOTM|
|Subject:||Two phase commit and MySQL ?|
Response to: Two phase commit and MySQL ?
In the article, I used XAPool which is a XA-aware JDBC Connection pool. It uses simple JDBC Driver and wraps it in XA objects.
The advantage is that you can then use any (well, most) databases below (e.g. PostgreSQL, HSQLDB) as long as they support transactional tables.
MySQL JDBC Driver was supporting XA in version 2.0.14 but it has been dropped from their latest version 3.0.18.
SAPDB also provides implementation of XA objects.