2 Replies Latest reply on Apr 19, 2010 5:01 AM by Kobi Ianko

    Oracle XADatasource in JBoss

    sreekumar Newbie

      Hi,

      I am facing a lot of problems in configuring OracleXADatasource in Jboss3.2.3 / 3.0.7 Please help me out in getting a solution...


      The files I have configures are...

      1) Oracle-xa-ds.xml in server/default/deploy

      <datasources>
      
      <xa-datasource>
       <jndi-name>XAOracleDS</jndi-name>
       <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:@196.12.44.86:1521:ora8i</xa-datasource-property>
       <xa-datasource-property name="User">AIS</xa-datasource-property>
       <xa-datasource-property name="Password">AIS</xa-datasource-property>
       <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
      </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>
      
      </datasources >


      2)login-config.xml in server/default/conf

      <application-policy name="OracleDbRealm">
      <authentication>
      <login-module code="org.jboss.resource.security.ConfiguredIdentityLoginModule" flag="required">
      <module-option name="principal">AIS</module-option>
      <module-option name="userName">AIS</module-option>
      <module-option name="password">AIS</module-option>
      <module-option name="managedConnectionFactoryName">jboss.jca:service=XaTxCM,name=XAOracleDS</module-option>
      </login-module>
      </authentication>
      </application-policy>


      3)standardjaws.xml in server/default/conf

      <datasource>java:/XAOracleDS</datasource>
       <type-mapping>Oracle8</type-mapping>


      4)standardjbosscmp-jdbc.xml in server/default/conf


      <defaults>
       <datasource>java:/XAOracleDS</datasource>
       <datasource-mapping>Oracle8</datasource-mapping>
       <create-table>true</create-table>
       <remove-table>false</remove-table>
       <read-only>false</read-only>
       <time-out>300</time-out>
       <pk-constraint>true</pk-constraint>
       <fk-constraint>false</fk-constraint>
       <row-locking>false</row-locking>
       <preferred-relation-mapping>foreign-key</preferred-relation-mapping>
       <read-ahead>
       <strategy>on-load</strategy>
       <page-size>1000</page-size>
       <eager-load-group>*</eager-load-group>
       </read-ahead>
       <list-cache-max>1000</list-cache-max>
      </defaults>


      Finally I am getting the following errors...


      10:12:26,000 INFO [MainDeployer] Deployment of package: file:/H:/jboss-3.0.7_jakarta-tomcat-4.1.24/server/default/deploy/oracle-xa-ds.xml is waiting for an appropriate deployer.
      10:12:26,000 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean operation 'checkIncompleteDeployments()'
      Cause: Incomplete Deployment listing:
      Packages waiting for a deployer:
      [org.jboss.deployment.DeploymentInfo@90381b83 { url=file:/H:/jboss-3.0.7_jakarta-tomcat-4.1.24/server/default/deploy/oracle-xa-ds.xml }
      deployer: null
      status: null
      state: INIT_WAITING_DEPLOYER

      watch: file:/H:/jboss-3.0.7_jakarta-tomcat-4.1.24/server/default/deploy/oracle-xa-ds.xml
      lastDeployed: 1084336946000
      lastModified: 1084336945984
      mbeans:
      ]Incompletely deployed packages:
      [org.jboss.deployment.DeploymentInfo@90381b83 { url=file:/H:/jboss-3.0.7_jakarta
      -tomcat-4.1.24/server/default/deploy/oracle-xa-ds.xml }
      deployer: null
      status: null
      state: INIT_WAITING_DEPLOYER
      watch: file:/H:/jboss-3.0.7_jakarta-tomcat-4.1.24/server/default/deploy/oracle
      -xa-ds.xml
      lastDeployed: 1084336946000
      lastModified: 1084336945984
      mbeans:
      ]MBeans waiting for classes:

      MBeans waiting for other MBeans:




      Please let me know what could be the reasons for the above error...

      Thanks in Advance.