Hello List,
I'm getting the following exception using Jboss2.4.0 when connecting to
Informix 7.30.fc7. In my test server Jboss, jdbc driver(the latest) and jdk
are the same except that the database server is Informix 7.30.TC3 and
everything is fine. Is it problem of the database server configuration or is
it a strange issue in Jboss config?
I always get correct data from the database, only in first case this
exception shows.
This happens in every Bean:
[MercadoBean] XAException: tx=XidImpl [FormatId=257, GlobalId=siigps//473,
BranchQual=] errorCode=XA_UNKNOWN(1)
[MercadoBean] javax.transaction.xa.XAException
[MercadoBean] at
org.jboss.pool.jdbc.xa.wrapper.XAResourceImpl.commit(XAResourceImpl.java:92)
[MercadoBean] at
org.jboss.tm.TxCapsule.commitResources(TxCapsule.java:1489)
[MercadoBean] at org.jboss.tm.TxCapsule.commit(TxCapsule.java:323)
[MercadoBean] at
org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:76)
[MercadoBean] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
java:355)
[MercadoBean] at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
[MercadoBean] at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:12
7)
[MercadoBean] at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
[MercadoBean] at
org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.jav
a:286)
[MercadoBean] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerI
nvoker.java:390)
[MercadoBean] at java.lang.reflect.Method.invoke(Native Method)
[MercadoBean] at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
[MercadoBean] at sun.rmi.transport.Transport$1.run(Transport.java:152)
[MercadoBean] at java.security.AccessController.doPrivileged(Native
Method)
[MercadoBean] at
sun.rmi.transport.Transport.serviceCall(Transport.java:148)
[MercadoBean] at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:465)
[MercadoBean] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:7
06)
[MercadoBean] at java.lang.Thread.run(Thread.java:484)
This happens in one specific Bean which has some select statements into
temporary tables and a final select to get the desired resultset. It is
specially strange since every beans inherit from the AbstractReportBean and
use this method. The connection only is closed just before returning data
from the EJB to the web tier:
[Default] java.sql.SQLException: Connection has been closed!
[Default] at
org.jboss.pool.jdbc.xa.wrapper.XAClientConnection.prepareStatement(XAClientC
onnection.java:165)
[Default]
[Default] at
igps.common.AbstractReportBean.getDatabaseValues(AbstractReportBean.java:660
)
[Default]
[Default] at
igps.common.AbstractReportBean.getDatabaseValues(AbstractReportBean.java:644
)
[Default]
[Default] at
igps.common.AbstractReportBean.addCriterion(AbstractReportBean.java:67)
[Default]
[Default] at
igps.comercialpapel.SituacaoPlaneamentoProducaoBean.getReport(SituacaoPlanea
mentoProducaoBean.java:42)
[Default]
[Default] at
igps.comercialpapel.SituacaoPlaneamentoProducaoBean.getReport(SituacaoPlanea
mentoProducaoBean.java:35)
[Default]
[Default] at java.lang.reflect.Method.invoke(Native Method)
[Default]
[Default] at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(Stateles
sSessionContainer.java:543)
[Default]
[Default] at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSe
ssionInstanceInterceptor.java:87)
[Default]
[Default] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:133)
[Default]
[Default] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
java:298)
[Default]
[Default] at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
[Default]
[Default] at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:12
7)
[Default]
[Default] at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
[Default]
[Default] at
org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.jav
a:286)
[Default]
[Default] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerI
nvoker.java:390)
[Default]
[Default] at java.lang.reflect.Method.invoke(Native Method)
[Default]
[Default] at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
[Default]
[Default] at sun.rmi.transport.Transport$1.run(Transport.java:152)
[Default]
[Default] at java.security.AccessController.doPrivileged(Native
Method)
[Default]
[Default] at
sun.rmi.transport.Transport.serviceCall(Transport.java:148)
[Default]
[Default] at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:465)
[Default]
[Default] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:7
06)
[Default]
[Default] at java.lang.Thread.run(Thread.java:484)
[Default]
Thanks in advance,
Carlos Ferrão,
Project Engineer
Critical Software SA
Instituto Pedro Nunes, Rua Pedro Nunes,
3030-199 Coimbra, Portugal
Tel: +351(239)708521 - Fax: +351(239)700905
http://www.criticalsoftware.com
___________________________________________
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
