From: | "G(dot)L(dot) Grobe" <gary(at)grobe(dot)net> |
---|---|
To: | "Aaron Mulder" <ammulder(at)alumni(dot)princeton(dot)edu>, <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: XA capable driver |
Date: | 2002-08-01 02:24:37 |
Message-ID: | 003201c23902$95f0cfa0$0500a8c0@trinity |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
I'm using this very thing now. JBoss 2.4.x w/ a data source setup as you've
listed below. Even so, there are XA errors and warning I'm receiving in
places because the driver is not XA capable and I don't know how to get
around this.
----- Original Message -----
From: "Aaron Mulder" <ammulder(at)alumni(dot)princeton(dot)edu>
To: <pgsql-jdbc(at)postgresql(dot)org>
Sent: Wednesday, July 31, 2002 10:31 AM
Subject: Re: [JDBC] XA capable driver
> On Tue, 30 Jul 2002, G.L. Grobe wrote:
> > I'm not totally up to par about knowing what XA capabilities are in a
> > driver, but as I understand it, my errors are because the postgres
> > driver doesn't support XA datasources.
> >
> > Problem is I'm not sure how to fix this? Is there a postgres driver
> > somewheres that does support them or do I need to make different JBoss
> > (application server) configurations of my datasources?
>
> Which version of JBoss? The jboss.jcml exerpt below works for
> 2.4.x.
>
> Aaron
>
>
> <mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
> <attribute name="Drivers">org.postgresql.Driver</attribute>
> </mbean>
>
> <mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=postgres">
> <attribute name="PoolName">postgres</attribute>
> <attribute
name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attr
ibute>
> <attribute name="Properties"></attribute>
> <attribute name="URL">jdbc:postgresql://server/database</attribute>
> <attribute name="GCMinIdleTime">1200000</attribute>
> <attribute name="JDBCUser">user</attribute>
> <attribute name="MaxSize">10</attribute>
> <attribute name="Password">password</attribute>
> <attribute name="GCEnabled">false</attribute>
> <attribute name="InvalidateOnError">false</attribute>
> <attribute name="TimestampUsed">false</attribute>
> <attribute name="Blocking">true</attribute>
> <attribute name="GCInterval">120000</attribute>
> <attribute name="IdleTimeout">1800000</attribute>
> <attribute name="IdleTimeoutEnabled">false</attribute>
> <attribute name="LoggingEnabled">false</attribute>
> <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
> <attribute name="MinSize">2</attribute>
> </mbean>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Aaron Mulder | 2002-08-01 03:09:19 | Re: XA capable driver |
Previous Message | Sanjeev Kumar | 2002-08-01 00:22:32 |