Re: [JBoss-user] Oracle XA Datasource - "Use explicit XA" error

Igor Fedorenko Thu, 09 Jan 2003 10:48:42 -0800

Original "Use explicit XA call" can be JBoss bug or can be something inside your code. Please, check if you do something tricky like "ALTER SESSION" or conn.setTransactionIsolation. If you can provide simple example (an SSB) that demostrates this behaviour, I will take a closer look. I will also need to know exact oracle database version and version of jdbc driver you are using.

ORA-03113 and XA_RMERR look pretty much like your demaged your oracle installation. Try one of XA examples that come with oracle database ($ORACLE_HOME/jdbc/demo/demo.zip) to see if it works.

Generally, I've been using xa oracle configuration without any problems.

Muruga Chinnananchi wrote:

Hi Manoj,

Thanks very much for your help. I really appriciate
it.
I followed your instructions with thin driver. I get
the same error with thin driver.
Now i switched back to OCI driver but this time i
executed the initjvm.sql for system/manager oracle
user.
After executing the above sql, I started getting some
other errors. My next step is trying using jdk1.4 jdbc
driver. Here are the errors:

2003-01-08 16:11:47,984 DEBUG
[org.jboss.resource.connectionmanager.IdleRemover]
internalRegisterPool: registering pool with interval
900000 old interval: 450000
2003-01-08 16:11:48,156 ERROR [STDERR]
java.sql.SQLException: ORA-03113: end-of-file on
communication channel
2003-01-08 16:11:48,156 ERROR [STDERR] at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
2003-01-08 16:11:48,156 ERROR [STDERR] at
oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:1597)
2003-01-08 16:11:48,156 ERROR [STDERR] at
oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAccess.java:1209)
2003-01-08 16:11:48,156 ERROR [STDERR] at
oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(OCIDBAccess.java:1321)
2003-01-08 16:11:48,156 ERROR [STDERR] at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
2003-01-08 16:11:48,156 ERROR [STDERR] at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
2003-01-08 16:11:48,156 ERROR [STDERR] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
2003-01-08 16:11:48,156 ERROR [STDERR] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
2003-01-08 16:11:48,156 ERROR [STDERR] at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:407)
2003-01-08 16:11:48,156 ERROR [STDERR] at
oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:171)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:107)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.tm.TransactionImpl.startResource(TransactionImpl.java:1053)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:576)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:415)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:313)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:594)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:885)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102)
2003-01-08 16:11:48,171 ERROR [STDERR] at
com.collaxa.cube.engine.data.ConnectionFactory$ConnectionFactoryImpl.__getConnection(ConnectionFactory.java:240)
2003-01-08 16:11:48,171 ERROR [STDERR] at
com.collaxa.cube.engine.data.ConnectionFactory$ConnectionFactoryImpl.getConnection(ConnectionFactory.java:204)
2003-01-08 16:11:48,171 ERROR [STDERR] at
com.collaxa.cube.engine.data.ConnectionFactory.getConnection(ConnectionFactory.java:98)
2003-01-08 16:11:48,171 ERROR [STDERR] at
com.collaxa.client.beans.BaseCubeSessionBean.createContext(BaseCubeSessionBean.java:137)
2003-01-08 16:11:48,171 ERROR [STDERR] at
com.collaxa.client.beans.BPELContainerManagerBean.refreshScenarios(BPELContainerManagerBean.java:53)
2003-01-08 16:11:48,171 ERROR [STDERR] at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
2003-01-08 16:11:48,171 ERROR [STDERR] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2003-01-08 16:11:48,171 ERROR [STDERR] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2003-01-08 16:11:48,171 ERROR [STDERR] at
java.lang.reflect.Method.invoke(Method.java:324)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:606)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:77)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:108)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:237)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:101)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:130)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:154)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:303)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.ejb.Container.invoke(Container.java:680)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:100)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:88)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:77)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:109)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:82)
2003-01-08 16:11:48,171 ERROR [STDERR] at
$Proxy68.refreshScenarios(Unknown Source)
2003-01-08 16:11:48,171 ERROR [STDERR] at
com.collaxa.client.BPELContainerHandle.refreshScenarios(BPELContainerHandle.java:105)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.apache.jsp.index_jsp._jspService(index_jsp.java:78)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
2003-01-08 16:11:48,171 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:204)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
2003-01-08 16:11:48,171 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:360)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:272)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:550)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.mortbay.http.HttpContext.handle(HttpContext.java:1655)
2003-01-08 16:11:48,171 ERROR [STDERR] at
org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:542)
2003-01-08 16:11:48,187 ERROR [STDERR] at
org.mortbay.http.HttpContext.handle(HttpContext.java:1605)
2003-01-08 16:11:48,187 ERROR [STDERR] at
org.mortbay.http.HttpServer.service(HttpServer.java:862)
2003-01-08 16:11:48,187 ERROR [STDERR] at
org.jboss.jetty.Jetty.service(Jetty.java:497)
2003-01-08 16:11:48,187 ERROR [STDERR] at
org.mortbay.http.HttpConnection.service(HttpConnection.java:752)
2003-01-08 16:11:48,187 ERROR [STDERR] at
org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:916)
2003-01-08 16:11:48,187 ERROR [STDERR] at
org.mortbay.http.HttpConnection.handle(HttpConnection.java:769)
2003-01-08 16:11:48,187 ERROR [STDERR] at
org.mortbay.http.SocketListener.handleConnection(SocketListener.java:202)
2003-01-08 16:11:48,187 ERROR [STDERR] at
org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289)
2003-01-08 16:11:48,187 ERROR [STDERR] at
org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:455)
2003-01-08 16:11:48,187 WARN [org.jboss.tm.TransactionImpl] XAException:
tx=TransactionImpl:XidImpl [FormatId=257,
GlobalId=muruga//25, BranchQual=] errorCode=XAER_RMERR
oracle.jdbc.xa.OracleXAException
at
oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:498)
at
oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:190)
at
org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:107)
at
org.jboss.tm.TransactionImpl.startResource(TransactionImpl.java:1053)
at
org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:576)
at
org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:415)
at
org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:313)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:594)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:885)
at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102)
at
com.collaxa.cube.engine.data.ConnectionFactory$ConnectionFactoryImpl.__getConnection(ConnectionFactory.java:240)
at
com.collaxa.cube.engine.data.ConnectionFactory$ConnectionFactoryImpl.getConnection(ConnectionFactory.java:204)
at
com.collaxa.cube.engine.data.ConnectionFactory.getConnection(ConnectionFactory.java:98)
at
com.collaxa.client.beans.BaseCubeSessionBean.createContext(BaseCubeSessionBean.java:137)
at
com.collaxa.client.beans.BPELContainerManagerBean.refreshScenarios(BPELContainerManagerBean.java:53)
at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:606)
at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:77)
at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:108)
at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:237)
at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:101)
at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:130)
at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204)
at
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:154)
at
org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:303)
at org.jboss.ejb.Container.invoke(Container.java:680)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
at
org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:100)
at
org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:88)
at
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:77)
at
org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80)
at
org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:109)
at
org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:82)
at $Proxy68.refreshScenarios(Unknown Source)
at
com.collaxa.client.BPELContainerHandle.refreshScenarios(BPELContainerHandle.java:105)
at
org.apache.jsp.index_jsp._jspService(index_jsp.java:78)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:204)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:360)
at
org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:272)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:550)
at
org.mortbay.http.HttpContext.handle(HttpContext.java:1655)
at
org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:542)
at
org.mortbay.http.HttpContext.handle(HttpContext.java:1605)
at
org.mortbay.http.HttpServer.service(HttpServer.java:862)
at org.jboss.jetty.Jetty.service(Jetty.java:497)
at
org.mortbay.http.HttpConnection.service(HttpConnection.java:752)
at
org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:916)
at
org.mortbay.http.HttpConnection.handle(HttpConnection.java:769)
at
org.mortbay.http.SocketListener.handleConnection(SocketListener.java:202)
at
org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289)
at
org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:455)
2003-01-08 16:11:48,187 INFO [org.jboss.resource.connectionmanager.XATxConnectionManager]
Could not enlist in transaction on entering meta-aware
object!
javax.transaction.SystemException: enlistResource
failed
at
org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:428)
at
org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:313)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:594)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:885)
at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102)
at
com.collaxa.cube.engine.data.ConnectionFactory$ConnectionFactoryImpl.__getConnection(ConnectionFactory.java:240)
at
com.collaxa.cube.engine.data.ConnectionFactory$ConnectionFactoryImpl.getConnection(ConnectionFactory.java:204)
at
com.collaxa.cube.engine.data.ConnectionFactory.getConnection(ConnectionFactory.java:98)
at
com.collaxa.client.beans.BaseCubeSessionBean.createContext(BaseCubeSessionBean.java:137)
at
com.collaxa.client.beans.BPELContainerManagerBean.refreshScenarios(BPELContainerManagerBean.java:53)
at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:606)
at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:77)
at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:108)
at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:237)
at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:101)
at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:130)
at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204)
at
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:154)
at
org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:303)
at org.jboss.ejb.Container.invoke(Container.java:680)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
at
org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:100)
at
org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:88)
at
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:77)
at
org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80)
at
org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:109)
at
org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:82)
at $Proxy68.refreshScenarios(Unknown Source)
at
com.collaxa.client.BPELContainerHandle.refreshScenarios(BPELContainerHandle.java:105)
at
org.apache.jsp.index_jsp._jspService(index_jsp.java:78)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:204)

--- "Sasidharan, Manoj" <[EMAIL PROTECTED]>
wrote:
One more point..

Incase you are using JDK1.4, use the new JDBC
drivers from Oracle.
MS
-----Original Message-----
From: muruga c [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 08, 2003 2:39 PM
To: [EMAIL PROTECTED]
Subject: [JBoss-user] Oracle XA Datasource - "Use
explicit XA" error


Hi,

I am using JBoss 3.2 Beta3 with Oracle XA driver.
When
i try to use the XADatasource, i get "Use explicit
XA"
call ResourceException (see below for the full error
message). I thought the oracle XA problem got solved
in 3.2 beta3. Maybe i am doing something wrong. Can
somebody please help me with this?

Here is the oracle xa data source config:

XA Data Source Config:
=====================
<datasources>
<xa-datasource>
<jndi-name>JSBContainerXADataSource</jndi-name>
<track-connection-by-tx>true</track-connection-by-tx>

<managedconnectionfactory-class>org.jboss.resource.adapter.jdbc.xa.oracle.XA

OracleManagedConnectionFactory</managedconnectionfactory-class>


<xa-datasource-property
name="URL">jdbc:oracle:oci8:@</xa-datasource-property>
<xa-datasource-property
name="User">muruga</xa-datasource-property>
<xa-datasource-property
name="Password">muruga</xa-datasource-property>
</xa-datasource>
</datasources>

Transaction Service Config:
==========================
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE server>


<server>






<mbean code="org.jboss.tm.XidFactory" name="jboss:service=XidFactory">
<attribute name="Pad">true</attribute>
</mbean>

<mbean code="org.jboss.tm.TransactionManagerService"

name="jboss:service=TransactionManager">
<attribute name="TransactionTimeout">300</attribute>

<depends
optional-attribute-name="XidFactory">jboss:service=XidFactory</depends>
</mbean>


<mbean
code="org.jboss.tm.usertx.server.ClientUserTransactionService"
name="jboss:service=ClientUserTransaction">
</mbean>


<mbean
code="org.jboss.resource.connectionmanager.CachedConnectionManager"
name="jboss.jca:service=CachedConnectionManager">
</mbean>
</server>


Exception Trace
===============
2003-01-08 14:26:26,406 INFO
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool]
ResourceException returning ManagedConnection to
pool:
javax.resource.ResourceException: Could not cleanup:
java.sql.SQLException: Use explicit XA call
at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.cleanup(BaseWra
pperManagedConnection.java:175)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.returnCon
nection(InternalManagedConnectionPool.java:143)
at
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool.retu
rnConnection(JBossManagedConnectionPool.java:516)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2.returnManagedCon
nection(BaseConnectionManager2.java:554)
at
org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventLi

stener$TxRemover.afterCompletion(TxConnectionManager.java:628)
at
org.jboss.tm.TransactionImpl.doAfterCompletion(TransactionImpl.java:1206)
at
org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:381)
at
org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:
361)
at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
java:295)
at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:101)
at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:13
0)
at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204)
at
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinde
rInterceptor.java:154)
at
org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.jav
a:303)
at
org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFacto
ry.java:351)
at
org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionPro
xy.java:81)
at $Proxy84.getNextKeySet(Unknown Source)
at
com.collaxa.cube.engine.data.CubeInstanceKeyFactory.create(CubeInstanceKeyFa
ctory.java:62)
at
com.collaxa.cube.engine.core.CubeInstanceFactory.create(CubeInstanceFactory.
java:33)
at
com.collaxa.cube.engine.CubeEngine.createInstance(CubeEngine.java:2710)
at
com.collaxa.cube.engine.CubeEngine.createAndInvoke(CubeEngine.java:1075)
at
com.collaxa.cube.engine.bean.CubeEngineBean.createAndInvoke(CubeEngineBean.j
ava:100)
at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(Stateles
sSessionContainer.java:606)
at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(Cach
edConnectionInterceptor.java:186)
at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSe
ssionInstanceInterceptor.java:77)
at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor
.java:108)
at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
java:237)
at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:101)
at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:13
0)
at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204)
at
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinde
rInterceptor.java:154)
at
org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.jav
a:303)
at
org.jboss.ejb.Container.invoke(Container.java:680)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
at
org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:100)
at
org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:88)
at
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:77
)
at
org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80)
at
org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInter
ceptor.java:109)
at
org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:82)
at $Proxy77.createAndInvoke(Unknown Source)
at
com.collaxa.client.dispatch.BaseDelegate.__asyncCreateAndInvoke(BaseDelegate
.java:70)
at
com.cxdn.samples.HelloWorldDispatchDelegate.createAndInvoke(HelloWorldDispat
chDelegate.java:59)
at
org.apache.jsp.ngDoInitiate_jsp._jspService(ngDoInitiate_jsp.java:144)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2
04)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:360)
at
org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandl
er.java:272)
at
org.mortbay.jetty.servlet.Dispatcher.dispatch(Dispatcher.java:194)
at
org.mortbay.jetty.servlet.Dispatcher.include(Dispatcher.java:121)
at
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:8
22)
at
org.apache.jsp.displayScenario_jsp._jspService(displayScenario_jsp.java:366)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2
04)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:360)
at
org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandl
er.java:272)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:550)
at
org.mortbay.http.HttpContext.handle(HttpContext.java:1655)
at
org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext
.java:542)
at
org.mortbay.http.HttpContext.handle(HttpContext.java:1605)
at
org.mortbay.http.HttpServer.service(HttpServer.java:862)
at org.jboss.jetty.Jetty.service(Jetty.java:497)
at
org.mortbay.http.HttpConnection.service(HttpConnection.java:752)
at
org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:916)
at
org.mortbay.http.HttpConnection.handle(HttpConnection.java:769)
at
org.mortbay.http.SocketListener.handleConnection(SocketListener.java:202)
at
org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289)
at
org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:455)
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up
now.
http://mailplus.yahoo.com
-------------------------------------------------------
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld =
Something 2 See!
http://www.vasoftware.com
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
-------------------------------------------------------
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld =
Something 2 See!
http://www.vasoftware.com
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com


-------------------------------------------------------
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
http://www.vasoftware.com
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

--
Igor Fedorenko
Think smart. Think automated. Think Dynamics.
www.thinkdynamics.com



-------------------------------------------------------
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
http://www.vasoftware.com
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] Oracle XA Datasource - "Use explicit XA" error

Reply via email to