Postgres XA Datasource configuration

[jlmartinez]

Somebody knows how to configure Postgres XA Datasources in JBoss 3.0

is possible obtain an example of postgresXA-service.xml ?

Thank you,

Jose Luis Martinez

[garyg]

Hope this helps. Here's how my postgresql datasource is configured in the jboss.jcml (under the JDBC section).

---


org.postgresql.Driver



PostgresqlDB
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl

jdbc:postgresql:acais://localhost:5432
1200000
mypasswd
10
mypasswd
false
false
false
true
120000
1800000
false
false
1.0
0

[davidjencks]

Do you have some evidence that Postgres supports xa semantics and provides an XADataSource implementation? I haven't found any despite some searching. Even if there is an XADataSource implementation it won't do you any good unless Postgres actually supports two phase commit. If this is the case, stick with the regular driver, it is simpler.

[jlmartinez]

I'm not sure that Postgres driver supports XA, I was using an XA configuration in JBoss 2.4.4 (jboss.jcml file). But really I have a problem when I sent massive querys, I posted the problem in :

http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=forums/ I'm going to test the version JBoss-3.0.1RC1, according to response of Dain Sundstrom.

Thank you for your help.

Jose Luis Martinez
Sorry for my poor english.

[kovacs_vdo]

PostrgeSQL does not support 2pc.