what exactly is an XADataSource
garyg Jul 24, 2002 12:37 AMI'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.