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-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasou rce-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> <!-- $Id: transaction-service.xml,v 1.2 2002/07/05 06:10:56 d_jencks Exp $ --> <server> <!-- ==================================================================== --> <!-- Transactions --> <!-- ==================================================================== --> <!-- The configurable Xid factory. For use with Oracle, set pad to true --> <mbean code="org.jboss.tm.XidFactory" name="jboss:service=XidFactory"> <attribute name="Pad">true</attribute> </mbean> <!-- | The fast in-memory transaction manager. --> <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> <!-- | UserTransaction support. --> <mbean code="org.jboss.tm.usertx.server.ClientUserTransactionService" name="jboss:service=ClientUserTransaction"> </mbean> <!-- | The CachedConnectionManager is used partly to relay started UserTransactions to | open connections so they may be enrolled in the new tx. --> <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
