Re: JDBC XA Support and Sample code?

Jignesh K. Shah wrote:
> I am new to the XA world of PostgreSQL. What's the story of XA in
> PostgreSQL JDBC Driver? Also are there examples on how to use the
> "Experimental" XA driver in postgresql-jdbc?

As Kris pointed out, it's not experimental.

It's typically used together with an application server that also acts
as the transaction manager, and manages the connections and transactions
for you. In that case, you don't need to do anything special; if you use
two database connections or other resource managers in a transaction,
the application server will perform two-phase commit using the XA driver
behind the scenes.

The tricky part is configuring the application server/transaction
manager to use the XA-enabled PGXADataSource. That's different on each
product. It would be nice to get a sample config file and tutorial on
Glassfish, hint hint ;-)

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com