6 Replies Latest reply on Jul 27, 2002 1:15 AM by garyg

    what exactly is an XADataSource

    garyg Novice

      I'm chasing some XAException warnings and errors of errorCode=XAER_RMERR (see below for output).

      Anyways, I'm told by someone off the com.databases.postgresql.interfaces.jdbc site that the reason I'm seeing this is probably because Im using distributed transactions (which the XA refers to) and neither the postgresql or jdbc driver support distributed connections (yet that's how my jboss.jcml is config'd, *I think*).

      And this is my question ... I configured the jboss.jcml as an XADataSource and is if this were a normal thing. So like, what am I not understanding here.

      Anyhelp much appreciated.

      --- output
      [WARN,TxCapsule] XAException: tx=XidImpl [FormatId=257, GlobalId=cassia//184, BranchQual=] errorCode=XAER_RMERR
      javax.transaction.xa.XAException
      at org.jboss.mq.SpyXAResource.commit(SpyXAResource.java:102)
      at org.jboss.tm.TxCapsule.commitResources(TxCapsule.java:1490)
      at org.jboss.tm.TxCapsule.commit(TxCapsule.java:324)
      at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:76)
      at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:314)
      at org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMessageConsumer.java:565)
      at org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:376)
      at org.jboss.mq.SpySession.run(SpySession.java:248)
      at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:172)
      at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:725)

      --- jboss.jcml


      <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=PostgresqlDB">
      <attribute name="PoolName">PostgresqlDB</attribute>
      <attribute name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute>
      <attribute name="Properties"></attribute>
      <attribute name="URL">jdbc:postgresql:acais://localhost:5432</attribute>
      <attribute name="GCMinIdleTime">1200000</attribute>
      <attribute name="JDBCUser">mypasswd</attribute>
      <attribute name="MaxSize">10</attribute>
      <attribute name="Password">mypasswd</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">0</attribute>
      </mbean>


      Any help much appreciated.