Re: XA capable driver - Mailing list pgsql-jdbc

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</attribute>
    <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>