PostgreSQL XA Datasource suspent/resume

[plexiq]

Hi,
im running Jboss4.0.5GA and Postgresql 8.1.4

I was using postgres with a local-tx-datasource, and everything worked fine - except that i keep getting the "prepare called on local tx"-warning. So i tried to configure a xa-datasource, but couldnt get it to work.

Based on this config:
http://wiki.jboss.org/wiki/Wiki.jsp?page=SetUpAPostgreSQLDatasource

On datasource deploy, i get:
"org.postgresql.xa.PGXAConnection suspent/resume not supported"

So, is it possible to avoid this problem?
Can i tell Jboss not to use those operations?

[plexiq]

Solved the problem.

<track-connection-by-tx/>

Has to be added to the datasource. Maybe someone can update the XA-postgresql example to include this.

[weston.price]

Current PostGres supports a subset of the XA specification. As you discovered, suspend/resume is not supported which requires that a connection cannot be dissassociated from a transaction until completion. I will file a JIRA task to create a postgres-xa-ds.xml file with the necessary qualifications for use. I can get this into JBoss 4.2.