3 Replies Latest reply on Nov 17, 2008 9:33 AM by Paul Robertson

    Using an Oracle DataSource

    Paul Robertson Newbie

      I am currently trying to set up an Oracle datasource to be used.


      I have configured the following in the file jboss-4.2.2.GA\server\default\conf\jboss-service.xml

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


      I have also added the Oracle drivers to jboss-4.2.2.GA\server\default\lib

      When I try to use the following datasource I get an error
      <xa-datasource>
      <jndi-name>HuonDB_DH</jndi-name>
      <use-java-context>false</use-java-context>
      <track-connection-by-tx>true</track-connection-by-tx>
      <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:@[REMOVED URL]:[REMOVED PORT]:[REMOVED SID]</xa-datasource-property>
      <xa-datasource-property name="User">xxxx</xa-datasource-property>
      <xa-datasource-property name="Password">xxxx</xa-datasource-property>
      <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
      <no-tx-separate-pools/>
      </xa-datasource>
      
      <mbean code="org.jboss.resource.adapter.jdbc.xa.oracle.OracleXAExceptionFormatter" name="jboss.jca:service=OracleXAExceptionFormatter">
      <depends optional-attribute-name="TransactionManagerService">jboss:service=TransactionManager</depends>
      </mbean>
      


      The error is:
      10:53:56,593 ERROR [MainDeployer] Could not create deployment: file:/C:/XAware511/jboss-4.2.2.GA/server/default/deploy/XAwareConnections-ds.xml

      org.jboss.deployment.DeploymentException: No ClassLoaders found for: org.jboss.resource.adapter.jdbc.xa.oracle.OracleXAExceptionFormatter; - nested throwable:
      (java.lang.ClassNotFoundException: No ClassLoaders found for: org.jboss.resource.adapter.jdbc.xa.oracle.OracleXAExceptionFormatter)

      The same thing also happens for org.jboss.resource.adapter.jdbc.xa.oracle.OracleXAExceptionFormatter

      Any help is greatly appreciated