[jboss-user] [Installation, Configuration & Deployment] - Issue with XA datasource on JBoss 5.1. GA

katoch do-not-reply at jboss.com
Mon Nov 16 07:13:20 EST 2009


Hi,
I am getting below exception with XA datasource deployed on JBoss 5.1.

data source file is :
====================

<?xml version="1.0" encoding="UTF-8"?>

<!-- ===================================================================== -->
<!--                                                                       -->
<!--  JBoss Server Configuration                                           -->
<!--                                                                       -->
<!-- ===================================================================== -->
<!-- $Id: oracle-xa-ds.xml 77479 2008-08-26 10:33:09Z alex.loubyansky at jboss.com $ -->
<!-- ===================================================================== -->
<!-- ATTENTION:  DO NOT FORGET TO SET Pad=true IN transaction-service.xml  -->
<!-- ===================================================================== -->
 
  <xa-datasource> 
    <jndi-name>jdbc/eloquence</jndi-name>  
    <!-- uncomment to enable interleaving  -->  
    <isSameRM-override-value>false</isSameRM-override-value>  
    <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>  
    <xa-datasource-property name="URL">jdbc:oracle:thin:@cst:1521:orcl</xa-datasource-property>  
    <xa-datasource-property name="User">ddd</xa-datasource-property>  
    <xa-datasource-property name="Password">ddd</xa-datasource-property>  
    <use-java-context>false</use-java-context>  
    <min-pool-size>5</min-pool-size>  
    <max-pool-size>20</max-pool-size>  
    <!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->  
    <!--valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name-->  
    <!-- Checks the Oracle error codes and messages for fatal errors -->  
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>  
    <!-- Oracles XA datasource cannot reuse a connection outside a transaction once enlisted in a global transaction and vice-versa -->  
    <no-tx-separate-pools/>  
    <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->  
    <!-- Oracle9i mapping can be used for Oracle10g -->  
     
      <type-mapping>Oracle9i</type-mapping> 
     
  </xa-datasource>  
   
    <depends optional-attribute-name="TransactionManagerService">jboss:service=TransactionManager 
   

==================

Exception is ::

2009-11-16 17:31:47,402 WARN  [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Destroying connection that could not be successfully matched: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener at 11eeb3f[state=NORMAL mc=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection at b2d46e handles=0 lastUse=1258372722094 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool at 13578ff context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool at 19aeb84 xaResource=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection at b2d46e txSync=null]
2009-11-16 17:31:47,449 WARN  [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: invalid arguments in call)
	at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:465)
	at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:409)
	at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:633)
	at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:267)
	at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:622)
	at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
	at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)
	at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
	at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
	at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:104)
	at cincom.iDGenesis.Framework.CSConnectionPool$CSPooledConnection.acquireDataSourceConnection(Unknown Source)
	at cincom.iDGenesis.Framework.CSConnectionPool$CSPooledConnection.acquire(Unknown Source)
	at cincom.iDGenesis.Framework.CSConnectionPool.getConnection(Unknown Source)
	at cincom.iDGenesis.Framework.CSDatabaseResource.query(Unknown Source)
	at cincom.iDGenesis.Framework.CSDatabaseResource.initialise(Unknown Source)
	at TAn.processBody1(TAn.java:121)
	at TAn.start(TAn.java:76)
	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:585)
	at cincom.iDGenesis.Framework.CSDocument.Start(Unknown Source)
	at cincom.iDGenesis.Framework.CSCollDocuments.generateDoc(Unknown Source)
	at cincom.iDGenesis.Framework.CSCollDocuments.generateDocs(Unknown Source)
	at cincom.iDGenesis.Framework.CSApplication.generateDocs(Unknown Source)
	at cincom.iDGenesis.Framework.CSCompositionProcessor.processApplication(Unknown Source)
	at cincom.iDGenesis.Framework.CSInflowHandlerNativeXML.endCollDocuments(Unknown Source)
	at cincom.iDGenesis.Framework.CSSAXEngineHandler.endElement(Unknown Source)
	at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
	at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
	at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
	at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
	at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
	at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
	at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
	at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
	at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
	at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source)
	at cincom.iDGenesis.Framework.CSInflowHandlerNativeXML.parseInflow(Unknown Source)
	at cincom.iDGenesis.Framework.CSInflowHandlerNativeXML.start(Unknown Source)
	at cincom.iDGenesis.Framework.CSCompositionProcessor.handleNativeXMLInflow(Unknown Source)
	at cincom.iDGenesis.Framework.CSCompositionProcessor.processRequest(Unknown Source)
	at cincom.eloquence.framework.request.EngineRequestProcessor.processRequest(Unknown Source)
	at cincom.eloquence.framework.request.EngineRequestProcessor.processRequest(Unknown Source)
	at cincom.eloquence.common.server.request.RequestWS.onMessage(Unknown Source)
	at cincom.iDGenesis.EngineServer.ws.CEEngineWS.onMessage(Unknown Source)
	at cincom.iDGenesis.EngineServer.ws.CEEngineWSDelegate.onMessage(Unknown Source)
	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:585)
	at com.sun.xml.ws.api.server.InstanceResolver$1.invoke(InstanceResolver.java:246)
	at com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:146)
	at com.sun.xml.ws.server.sei.EndpointMethodHandler.invoke(EndpointMethodHandler.java:257)
	at com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:93)
	at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:598)
	at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:557)
	at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:542)
	at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:439)
	at com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:243)
	at com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:444)
	at com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:244)
	at com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:135)
	at com.sun.xml.ws.transport.http.servlet.WSServletDelegate.doGet(WSServletDelegate.java:129)
	at com.sun.xml.ws.transport.http.servlet.WSServletDelegate.doPost(WSServletDelegate.java:160)
	at com.sun.xml.ws.transport.http.servlet.WSServlet.doPost(WSServlet.java:75)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
	at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: invalid arguments in call
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:236)
	at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:441)
	at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165)
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
	at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:297)
	at oracle.jdbc.xa.client.OracleXADataSource.getPooledConnection(OracleXADataSource.java:472)
	at oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:159)
	at oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:133)
	at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:449)
	... 87 more


Can any one tell where is the issue. Is this issue with JBoss configuration or with data source file.

Thanks

View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4265837#4265837

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4265837



More information about the jboss-user mailing list