Article:
  Adding Transactions to Servlets with JOTM
Subject:   Two phase commit and MySQL ?
Date:   2003-08-08 03:04:46
From:   anonymous2
Last time I looked, MySQL didn't support two-phase commit, so I can't see how it will work together with other resources when some of the transactions fail?


Are any of the other Free Software/Open Source databases able to really support distributed transactions from Java ?


/Sebastian

Main Topics Oldest First

Showing messages 1 through 1 of 1.

  • Two phase commit and MySQL ?
    2003-08-12 02:30:56  jeff.mesnil [View]

    In the article, I used XAPool[1] 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.

    jeff

    [1] http://xapool.experlog.com