Re: XA capable driver - Mailing list pgsql-jdbc

From G.L. Grobe
Subject Re: XA capable driver
Date
Msg-id 003201c23902$95f0cfa0$0500a8c0@trinity
Whole thread Raw
In response to Re: XA capable driver  (Aaron Mulder <ammulder@alumni.princeton.edu>)
Responses Re: XA capable driver
List 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@alumni.princeton.edu>
To: <pgsql-jdbc@postgresql.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@postgresql.org
>


pgsql-jdbc by date:

Previous
From: "Paul Stead"
Date:
Subject: Re: Bad Timestamp Format Error
Next
From: Aaron Mulder
Date:
Subject: Re: XA capable driver