Hi,
we are having a problem with a really old application we had to switch
databases. It runs on JBoss 2.2.2 (whooo) and does its job perfectly.
However a change of DB from M$ SQL to Oracle suddendly produces errors like
these:
26.07.2002 00.37 [Timer] XAException: tx=XidImpl [FormatId=257,
GlobalId=pdbh9qda//347081, BranchQual=] errorCode=XAER_NOTA
26.07.2002 00.37 [Timer] javax.transaction.xa.XAException
26.07.2002 00.37 [Timer] at
org.opentools.minerva.jdbc.xa.wrapper.XAResourceImpl.start(XAResourceImpl.ja
va:258)
26.07.2002 00.37 [Timer] at
org.jboss.tm.TxCapsule.startResource(TxCapsule.java:1105)
26.07.2002 00.37 [Timer] at
org.jboss.tm.TxCapsule.enlistResource(TxCapsule.java:632)
followed by a
26.07.2002 00.37 [Timer] XAException: tx=XidImpl [FormatId=257,
GlobalId=pdbh9qda//347081, BranchQual=] errorCode=XAER_PROTO
26.07.2002 00.37 [Timer] javax.transaction.xa.XAException
26.07.2002 00.37 [Timer] at
org.opentools.minerva.jdbc.xa.wrapper.XAResourceImpl.end(XAResourceImpl.java
:124)
26.07.2002 00.37 [Timer] at
org.jboss.tm.TxCapsule.endResource(TxCapsule.java:1147)
26.07.2002 00.37 [Timer] at
org.jboss.tm.TxCapsule.delistResource(TxCapsule.java:541)
and
26.07.2002 00.37 [Task] TRANSACTION ROLLBACK EXCEPTION:Transaction marked
for rollback, possibly a timeout; nested exception is:
java.lang.RuntimeException: Transaction marked for rollback, possibly a
timeout
26.07.2002 00.37 [Task] java.lang.RuntimeException: Transaction marked for
rollback, possibly a timeout
26.07.2002 00.37 [Task] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterce
ptor.java:118)
As I can see from the archieves there seem to be a problem with
<attribute name="GCMinIdleTime">120000</attribute>
in the following config:
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=mssql_brains1">
<attribute name="PoolName">mssql_brains1</attribute>
<attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
l</attribute>
<attribute name="Properties"></attribute>
<attribute name="URL">jdbc:oracle:thin:@SERVER:1521:ingra</attribute>
<attribute name="GCMinIdleTime">120000</attribute>
<attribute name="JDBCUser">user</attribute>
<attribute name="MaxSize">30</attribute>
<attribute name="Password">pass</attribute>
<attribute name="GCEnabled">true</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">false</attribute>
<attribute name="GCInterval">60000</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>
setting this to
<attribute name="GCMinIdleTime">600000</attribute>
is a cure???
If so - why is that?
What other problems might be the root cause for this? I see from the
archieves that there had been a lot of discussion on this subject, ranging
from flames about oracle to patches to XidImpl but there is no real and
definite answer to be found. (Especially concerning the use of the Oracle
XADataSource wrapper class)
Any pointers?
Burkhard
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
