Re: XA capable driver

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
>

In response to

Responses

Browse pgsql-jdbc by date

  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