-
1. Re: Postgres XA Datasource configuration
garyg Jul 24, 2002 12:39 AM (in response to jlmartinez)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 -
2. Re: Postgres XA Datasource configuration
davidjencks Jul 24, 2002 12:56 AM (in response to jlmartinez)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.
-
3. Re: Postgres XA Datasource configuration
jlmartinez Jul 24, 2002 1:57 PM (in response to 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. -
4. Re: Postgres XA Datasource configuration
kovacs_vdo Jul 31, 2002 11:14 AM (in response to jlmartinez)PostrgeSQL does not support 2pc.