7 Replies Latest reply on Apr 14, 2004 2:00 AM by jackytang

    configure oracle 9.2.0.4 datasoure on Jboss error

    jackytang

      Jboss on Windows 2000(localhost)
      DB:Oracle 9.2.0.4 on RedHat AS2.1(172.30.1.6)

      JBOSS_HOME = D:\jboss-3.2.3
      Java_Home = C:\j2sdk1.4.1_02

      I did copy the class12.zip, ojdbc14.jar to my
      JBOSS_HOME\server\default\lib

      and make change of some xmls files "jboss-service.xml",
      "login-config.xml", "standardjbosscmp-jdbc.xml", "standardjaws.xml" in the JBOSS_HOME\server\default\conf folder

      *************************************************************
      ------------------jobss-service.xml-----------------------------
      <!-- ==================================================================== -->
      <!-- Transactions -->
      <!--============================================================= -->
      <!-- The configurable Xid factory. For use with Oracle, set pad to true -->

      true

      ------------------jobss-service.xml-----------------------------

      *************************************************************
      ------------------login-config.xml-------------------------------
      <application-policy name = "FirebirdDBRealm">

      <login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule"
      flag = "required">
      <module-option name = "principal">sysdba</module-option>
      <module-option name = "userName">sysdba</module-option>
      <module-option name = "password">masterkey</module-option>
      <module-option name = "managedConnectionFactoryName">jboss.jca:service=XaTxCM,name=FirebirdDS</module-option>
      </login-module>

      </application-policy>
      ------------------login-config.xml-------------------------------

      ************************************************************

      ------------------standardjbosscmp-jdbc.xml------------------
      <!-- ===================================================================== -->
      <!-- -->
      <!-- Standard JBossCMP-JDBC Configuration -->
      <!-- -->
      <!-- ===================================================================== -->

      <!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.34 2003/11/25 01:48:16 ejort Exp $ -->

      <jbosscmp-jdbc>


      java:/OracleDS
      <datasource-mapping>Oracle</datasource-mapping>

      </jbosscmp-jdbc>
      ------------------standardjbosscmp-jdbc.xml------------------

      ************************************************************

      ------------------standardjaws.xml-------------------------------
      <!-- ===================================================================== -->
      <!-- -->
      <!-- Standard Jaws Configuration -->
      <!-- -->
      <!-- ===================================================================== -->

      <!-- $Id: standardjaws.xml,v 1.30 2002/06/27 19:26:28 dsundstrom Exp $ -->


      java:/OracleDS
      <type-mapping>Oracle</type-mapping>


      ------------------standardjaws.xml------------------------------------

      ************************************************************

      make change of some xmls files "oracle-xa-ds.xml" in the JBOSS_HOME\server\default\deploy folder

      ************************************************************

      ------------------oracle-xa-ds.xml-------------------------------

      <xa-datasource>
      <jndi-name>OracleDS</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:@172.30.1.6:1521:geo3pl</xa-datasource-property>
      <xa-datasource-property name="User">nhweb</xa-datasource-property>
      <xa-datasource-property name="Password">29178022</xa-datasource-property>


      <depends optional-attribute-name="TransactionManagerService">jboss:service=TransactionManager



      ------------------oracle-xa-ds.xml------------------------------------

      ************************************************************

      make change of some xmls files "oracle-jdbc2-service.xml" in the JBOSS_HOME\server\default\deploy\jms folder

      ------------------oracle-jdbc2-service.xml-------------------------------


      <depends optional-attribute-name="ConnectionManager">jboss.jca:service=LocalTxCM,name=OracleDS

      ------------------oracle-jdbc2-service.xml-------------------------------

      ************************************************************


      2004-04-13 13:41:06,867 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] MBeanException: Exception in MBean operation 'checkIncompleteDeployments()'
      Cause: Incomplete Deployment listing:
      Packages waiting for a deployer:

      Incompletely deployed packages:

      MBeans waiting for classes:

      MBeans waiting for other MBeans:
      [ObjectName: jboss.mq:service=InvocationLayer,type=HTTP
      state: CONFIGURED
      I Depend On: jboss.mq:service=Invoker
      jboss.web:service=WebServer

      Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=testTopic
      state: CONFIGURED
      I Depend On: jboss.mq:service=DestinationManager
      jboss.mq:service=SecurityManager

      Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=securedTopic
      state: CONFIGURED
      I Depend On: jboss.mq:service=DestinationManager
      jboss.mq:service=SecurityManager

      Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=testDurableTopic
      state: CONFIGURED
      I Depend On: jboss.mq:service=DestinationManager
      jboss.mq:service=SecurityManager

      Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=testQueue
      state: CONFIGURED
      I Depend On: jboss.mq:service=DestinationManager
      jboss.mq:service=SecurityManager

      Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=A
      state: CONFIGURED
      I Depend On: jboss.mq:service=DestinationManager

      Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=B
      state: CONFIGURED
      I Depend On: jboss.mq:service=DestinationManager

      Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=C
      state: CONFIGURED
      I Depend On: jboss.mq:service=DestinationManager

      Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=D
      state: CONFIGURED
      I Depend On: jboss.mq:service=DestinationManager

      Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=ex
      state: CONFIGURED
      I Depend On: jboss.mq:service=DestinationManager

      Depends On Me: , ObjectName: jboss.mq:service=Invoker
      state: CONFIGURED
      I Depend On: jboss.mq:service=TracingInterceptor

      Depends On Me: jboss.mq:service=InvocationLayer,type=HTTP
      jboss.mq:service=InvocationLayer,type=JVM
      jboss.mq:service=InvocationLayer,type=OIL
      jboss.mq:service=InvocationLayer,type=OIL2
      jboss.mq:service=InvocationLayer,type=RMI
      jboss.mq:service=InvocationLayer,type=UIL2
      , ObjectName: jboss.mq:service=TracingInterceptor
      state: CONFIGURED
      I Depend On: jboss.mq:service=SecurityManager

      Depends On Me: jboss.mq:service=Invoker
      , ObjectName: jboss.mq:service=SecurityManager
      state: CONFIGURED
      I Depend On: jboss.mq:service=DestinationManager

      Depends On Me: jboss.mq.destination:service=Topic,name=testTopic
      jboss.mq.destination:service=Topic,name=securedTopic
      jboss.mq.destination:service=Topic,name=testDurableTopic
      jboss.mq.destination:service=Queue,name=testQueue
      jboss.mq:service=TracingInterceptor
      jboss.mq.destination:service=Queue,name=DLQ
      , ObjectName: jboss.mq.destination:service=Queue,name=DLQ
      state: CONFIGURED
      I Depend On: jboss.mq:service=DestinationManager
      jboss.mq:service=SecurityManager

      Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=JVM
      state: CONFIGURED
      I Depend On: jboss.mq:service=Invoker

      Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=OIL
      state: CONFIGURED
      I Depend On: jboss.mq:service=Invoker

      Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=OIL2
      state: CONFIGURED
      I Depend On: jboss.mq:service=Invoker

      Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=RMI
      state: CONFIGURED
      I Depend On: jboss.mq:service=Invoker

      Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=UIL2
      state: CONFIGURED
      I Depend On: jboss.mq:service=Invoker

      Depends On Me: ]
      2004-04-13 13:41:06,877 INFO [org.jboss.deployment.scanner.URLDeploymentScanner] Started jboss.deployment:type=DeploymentScanner,flavor=URL
      2004-04-13 13:41:06,907 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/jboss-3.2.3/server/default/conf/jboss-service.xml
      2004-04-13 13:41:06,907 INFO [org.jboss.system.server.Server] JBoss (MX MicroKernel) [3.2.3 (build: CVSTag=JBoss_3_2_3 date=200311301445)] Started in 14s:621ms

        • 1. Re: configure oracle 9.2.0.4 datasoure on Jboss3.2.3 error
          jackytang

           

          "jackytang" wrote:
          Jboss3.2.3 on Windows 2000(localhost)
          DB:Oracle 9.2.0.4 on RedHat AS2.1(172.30.1.6)

          JBOSS_HOME = D:\jboss-3.2.3
          Java_Home = C:\j2sdk1.4.1_02

          I did copy the class12.zip, ojdbc14.jar to my
          JBOSS_HOME\server\default\lib

          and make change of some xmls files "jboss-service.xml",
          "login-config.xml", "standardjbosscmp-jdbc.xml", "standardjaws.xml" in the JBOSS_HOME\server\default\conf folder

          *************************************************************
          ------------------jobss-service.xml-----------------------------
          <!-- ==================================================================== -->
          <!-- 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>
          ------------------jobss-service.xml-----------------------------

          *************************************************************
          ------------------login-config.xml-------------------------------
          <application-policy name = "FirebirdDBRealm">
          <authentication>
          <login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule"
          flag = "required">
          <module-option name = "principal">sysdba</module-option>
          <module-option name = "userName">sysdba</module-option>
          <module-option name = "password">masterkey</module-option>
          <module-option name = "managedConnectionFactoryName">jboss.jca:service=XaTxCM,name=FirebirdDS</module-option>
          </login-module>
          </authentication>
          </application-policy>
          ------------------login-config.xml-------------------------------

          ************************************************************

          ------------------standardjbosscmp-jdbc.xml------------------
          <!-- ===================================================================== -->
          <!-- -->
          <!-- Standard JBossCMP-JDBC Configuration -->
          <!-- -->
          <!-- ===================================================================== -->

          <!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.34 2003/11/25 01:48:16 ejort Exp $ -->

          <jbosscmp-jdbc>

          <defaults>
          <datasource>java:/OracleDS</datasource>
          <datasource-mapping>Oracle</datasource-mapping>
          </defaults>
          </jbosscmp-jdbc>
          ------------------standardjbosscmp-jdbc.xml------------------

          ************************************************************

          ------------------standardjaws.xml-------------------------------
          <!-- ===================================================================== -->
          <!-- -->
          <!-- Standard Jaws Configuration -->
          <!-- -->
          <!-- ===================================================================== -->

          <!-- $Id: standardjaws.xml,v 1.30 2002/06/27 19:26:28 dsundstrom Exp $ -->

          <jaws>
          <datasource>java:/OracleDS</datasource>
          <type-mapping>Oracle</type-mapping>
          </jaws>

          ------------------standardjaws.xml------------------------------------

          ************************************************************

          make change of some xmls files "oracle-xa-ds.xml" in the JBOSS_HOME\server\default\deploy folder

          ************************************************************

          ------------------oracle-xa-ds.xml-------------------------------
          <datasources>
          <xa-datasource>
          <jndi-name>OracleDS</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:@172.30.1.6:1521:geo3pl</xa-datasource-property>
          <xa-datasource-property name="User">nhweb</xa-datasource-property>
          <xa-datasource-property name="Password">29178022</xa-datasource-property>

          <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>
          ------------------oracle-xa-ds.xml------------------------------------

          ************************************************************

          make change of some xmls files "oracle-jdbc2-service.xml" in the JBOSS_HOME\server\default\deploy\jms folder

          ------------------oracle-jdbc2-service.xml-------------------------------

          <mbean code="org.jboss.mq.pm.jdbc2.PersistenceManager"
          name="jboss.mq:service=PersistenceManager">
          <depends optional-attribute-name="ConnectionManager">jboss.jca:service=LocalTxCM,name=OracleDS</depends>

          ------------------oracle-jdbc2-service.xml-------------------------------

          ************************************************************


          2004-04-13 13:41:06,867 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] MBeanException: Exception in MBean operation 'checkIncompleteDeployments()'
          Cause: Incomplete Deployment listing:
          Packages waiting for a deployer:
          <none>
          Incompletely deployed packages:
          <none>
          MBeans waiting for classes:
          <none>
          MBeans waiting for other MBeans:
          [ObjectName: jboss.mq:service=InvocationLayer,type=HTTP
          state: CONFIGURED
          I Depend On: jboss.mq:service=Invoker
          jboss.web:service=WebServer

          Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=testTopic
          state: CONFIGURED
          I Depend On: jboss.mq:service=DestinationManager
          jboss.mq:service=SecurityManager

          Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=securedTopic
          state: CONFIGURED
          I Depend On: jboss.mq:service=DestinationManager
          jboss.mq:service=SecurityManager

          Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=testDurableTopic
          state: CONFIGURED
          I Depend On: jboss.mq:service=DestinationManager
          jboss.mq:service=SecurityManager

          Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=testQueue
          state: CONFIGURED
          I Depend On: jboss.mq:service=DestinationManager
          jboss.mq:service=SecurityManager

          Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=A
          state: CONFIGURED
          I Depend On: jboss.mq:service=DestinationManager

          Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=B
          state: CONFIGURED
          I Depend On: jboss.mq:service=DestinationManager

          Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=C
          state: CONFIGURED
          I Depend On: jboss.mq:service=DestinationManager

          Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=D
          state: CONFIGURED
          I Depend On: jboss.mq:service=DestinationManager

          Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=ex
          state: CONFIGURED
          I Depend On: jboss.mq:service=DestinationManager

          Depends On Me: , ObjectName: jboss.mq:service=Invoker
          state: CONFIGURED
          I Depend On: jboss.mq:service=TracingInterceptor

          Depends On Me: jboss.mq:service=InvocationLayer,type=HTTP
          jboss.mq:service=InvocationLayer,type=JVM
          jboss.mq:service=InvocationLayer,type=OIL
          jboss.mq:service=InvocationLayer,type=OIL2
          jboss.mq:service=InvocationLayer,type=RMI
          jboss.mq:service=InvocationLayer,type=UIL2
          , ObjectName: jboss.mq:service=TracingInterceptor
          state: CONFIGURED
          I Depend On: jboss.mq:service=SecurityManager

          Depends On Me: jboss.mq:service=Invoker
          , ObjectName: jboss.mq:service=SecurityManager
          state: CONFIGURED
          I Depend On: jboss.mq:service=DestinationManager

          Depends On Me: jboss.mq.destination:service=Topic,name=testTopic
          jboss.mq.destination:service=Topic,name=securedTopic
          jboss.mq.destination:service=Topic,name=testDurableTopic
          jboss.mq.destination:service=Queue,name=testQueue
          jboss.mq:service=TracingInterceptor
          jboss.mq.destination:service=Queue,name=DLQ
          , ObjectName: jboss.mq.destination:service=Queue,name=DLQ
          state: CONFIGURED
          I Depend On: jboss.mq:service=DestinationManager
          jboss.mq:service=SecurityManager

          Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=JVM
          state: CONFIGURED
          I Depend On: jboss.mq:service=Invoker

          Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=OIL
          state: CONFIGURED
          I Depend On: jboss.mq:service=Invoker

          Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=OIL2
          state: CONFIGURED
          I Depend On: jboss.mq:service=Invoker

          Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=RMI
          state: CONFIGURED
          I Depend On: jboss.mq:service=Invoker

          Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=UIL2
          state: CONFIGURED
          I Depend On: jboss.mq:service=Invoker

          Depends On Me: ]
          2004-04-13 13:41:06,877 INFO [org.jboss.deployment.scanner.URLDeploymentScanner] Started jboss.deployment:type=DeploymentScanner,flavor=URL
          2004-04-13 13:41:06,907 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/jboss-3.2.3/server/default/conf/jboss-service.xml
          2004-04-13 13:41:06,907 INFO [org.jboss.system.server.Server] JBoss (MX MicroKernel) [3.2.3 (build: CVSTag=JBoss_3_2_3 date=200311301445)] Started in 14s:621ms


          • 2. Re: configure oracle 9.2.0.4 datasoure on Jboss3.2.3 error
            jackytang

            Jboss3.2.3 on Windows 2000(localhost)
            DB:Oracle 9.2.0.4 on RedHat AS2.1(172.30.1.6)

            JBOSS_HOME = D:\jboss-3.2.3
            Java_Home = C:\j2sdk1.4.1_02

            I did copy the class12.zip, ojdbc14.jar to my
            JBOSS_HOME\server\default\lib

            and make change of some xmls files "jboss-service.xml",
            "login-config.xml", "standardjbosscmp-jdbc.xml", "standardjaws.xml" in the JBOSS_HOME\server\default\conf folder

            *************************************************************
            ------------------jobss-service.xml-----------------------------
            <!-- ==================================================================== -->
            <!-- Transactions -->
            <!--============================================================= -->
            <!-- The configurable Xid factory. For use with Oracle, set pad to true -->

            true

            ------------------jobss-service.xml-----------------------------

            *************************************************************
            ------------------login-config.xml-------------------------------
            <application-policy name = "FirebirdDBRealm">

            <login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule"
            flag = "required">
            <module-option name = "principal">sysdba</module-option>
            <module-option name = "userName">sysdba</module-option>
            <module-option name = "password">masterkey</module-option>
            <module-option name = "managedConnectionFactoryName">jboss.jca:service=XaTxCM,name=FirebirdDS</module-option>
            </login-module>

            </application-policy>
            ------------------login-config.xml-------------------------------

            ************************************************************

            ------------------standardjbosscmp-jdbc.xml------------------
            <!-- ===================================================================== -->
            <!-- -->
            <!-- Standard JBossCMP-JDBC Configuration -->
            <!-- -->
            <!-- ===================================================================== -->

            <!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.34 2003/11/25 01:48:16 ejort Exp $ -->

            <jbosscmp-jdbc>


            java:/OracleDS
            <datasource-mapping>Oracle</datasource-mapping>

            </jbosscmp-jdbc>
            ------------------standardjbosscmp-jdbc.xml------------------

            ************************************************************

            ------------------standardjaws.xml-------------------------------
            <!-- ===================================================================== -->
            <!-- -->
            <!-- Standard Jaws Configuration -->
            <!-- -->
            <!-- ===================================================================== -->

            <!-- $Id: standardjaws.xml,v 1.30 2002/06/27 19:26:28 dsundstrom Exp $ -->


            java:/OracleDS
            <type-mapping>Oracle</type-mapping>


            ------------------standardjaws.xml------------------------------------

            ************************************************************

            make change of some xmls files "oracle-xa-ds.xml" in the JBOSS_HOME\server\default\deploy folder

            ************************************************************

            ------------------oracle-xa-ds.xml-------------------------------

            <xa-datasource>
            <jndi-name>OracleDS</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:@172.30.1.6:1521:geo3pl</xa-datasource-property>
            <xa-datasource-property name="User">nhweb</xa-datasource-property>
            <xa-datasource-property name="Password">29178022</xa-datasource-property>


            <depends optional-attribute-name="TransactionManagerService">jboss:service=TransactionManager



            ------------------oracle-xa-ds.xml------------------------------------

            ************************************************************

            make change of some xmls files "oracle-jdbc2-service.xml" in the JBOSS_HOME\server\default\deploy\jms folder

            ------------------oracle-jdbc2-service.xml-------------------------------


            <depends optional-attribute-name="ConnectionManager">jboss.jca:service=LocalTxCM,name=OracleDS

            ------------------oracle-jdbc2-service.xml-------------------------------

            ************************************************************


            2004-04-13 13:41:06,867 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] MBeanException: Exception in MBean operation 'checkIncompleteDeployments()'
            Cause: Incomplete Deployment listing:
            Packages waiting for a deployer:

            Incompletely deployed packages:

            MBeans waiting for classes:

            MBeans waiting for other MBeans:
            [ObjectName: jboss.mq:service=InvocationLayer,type=HTTP
            state: CONFIGURED
            I Depend On: jboss.mq:service=Invoker
            jboss.web:service=WebServer

            Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=testTopic
            state: CONFIGURED
            I Depend On: jboss.mq:service=DestinationManager
            jboss.mq:service=SecurityManager

            Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=securedTopic
            state: CONFIGURED
            I Depend On: jboss.mq:service=DestinationManager
            jboss.mq:service=SecurityManager

            Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=testDurableTopic
            state: CONFIGURED
            I Depend On: jboss.mq:service=DestinationManager
            jboss.mq:service=SecurityManager

            Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=testQueue
            state: CONFIGURED
            I Depend On: jboss.mq:service=DestinationManager
            jboss.mq:service=SecurityManager

            Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=A
            state: CONFIGURED
            I Depend On: jboss.mq:service=DestinationManager

            Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=B
            state: CONFIGURED
            I Depend On: jboss.mq:service=DestinationManager

            Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=C
            state: CONFIGURED
            I Depend On: jboss.mq:service=DestinationManager

            Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=D
            state: CONFIGURED
            I Depend On: jboss.mq:service=DestinationManager

            Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=ex
            state: CONFIGURED
            I Depend On: jboss.mq:service=DestinationManager

            Depends On Me: , ObjectName: jboss.mq:service=Invoker
            state: CONFIGURED
            I Depend On: jboss.mq:service=TracingInterceptor

            Depends On Me: jboss.mq:service=InvocationLayer,type=HTTP
            jboss.mq:service=InvocationLayer,type=JVM
            jboss.mq:service=InvocationLayer,type=OIL
            jboss.mq:service=InvocationLayer,type=OIL2
            jboss.mq:service=InvocationLayer,type=RMI
            jboss.mq:service=InvocationLayer,type=UIL2
            , ObjectName: jboss.mq:service=TracingInterceptor
            state: CONFIGURED
            I Depend On: jboss.mq:service=SecurityManager

            Depends On Me: jboss.mq:service=Invoker
            , ObjectName: jboss.mq:service=SecurityManager
            state: CONFIGURED
            I Depend On: jboss.mq:service=DestinationManager

            Depends On Me: jboss.mq.destination:service=Topic,name=testTopic
            jboss.mq.destination:service=Topic,name=securedTopic
            jboss.mq.destination:service=Topic,name=testDurableTopic
            jboss.mq.destination:service=Queue,name=testQueue
            jboss.mq:service=TracingInterceptor
            jboss.mq.destination:service=Queue,name=DLQ
            , ObjectName: jboss.mq.destination:service=Queue,name=DLQ
            state: CONFIGURED
            I Depend On: jboss.mq:service=DestinationManager
            jboss.mq:service=SecurityManager

            Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=JVM
            state: CONFIGURED
            I Depend On: jboss.mq:service=Invoker

            Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=OIL
            state: CONFIGURED
            I Depend On: jboss.mq:service=Invoker

            Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=OIL2
            state: CONFIGURED
            I Depend On: jboss.mq:service=Invoker

            Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=RMI
            state: CONFIGURED
            I Depend On: jboss.mq:service=Invoker

            Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=UIL2
            state: CONFIGURED
            I Depend On: jboss.mq:service=Invoker

            Depends On Me: ]
            2004-04-13 13:41:06,877 INFO [org.jboss.deployment.scanner.URLDeploymentScanner] Started jboss.deployment:type=DeploymentScanner,flavor=URL
            2004-04-13 13:41:06,907 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/jboss-3.2.3/server/default/conf/jboss-service.xml
            2004-04-13 13:41:06,907 INFO [org.jboss.system.server.Server] JBoss (MX MicroKernel) [3.2.3 (build: CVSTag=JBoss_3_2_3 date=200311301445)] Started in 14s:621ms

            • 3. Re: configure oracle 9.2.0.4 datasoure on Jboss3.2.3 error
              jackytang

               

              "jackytang" wrote:
              Jboss3.2.3 on Windows 2000(localhost)
              DB:Oracle 9.2.0.4 on RedHat AS2.1(172.30.1.6)

              JBOSS_HOME = D:\jboss-3.2.3
              Java_Home = C:\j2sdk1.4.1_02

              I did copy the class12.zip, ojdbc14.jar to my
              JBOSS_HOME\server\default\lib

              and make change of some xmls files "jboss-service.xml",
              "login-config.xml", "standardjbosscmp-jdbc.xml", "standardjaws.xml" in the JBOSS_HOME\server\default\conf folder

              *************************************************************
              ------------------jobss-service.xml-----------------------------
              <!-- ==================================================================== -->
              <!-- 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>
              ------------------jobss-service.xml-----------------------------

              *************************************************************
              ------------------login-config.xml-------------------------------
              <application-policy name = "FirebirdDBRealm">
              <authentication>
              <login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule"
              flag = "required">
              <module-option name = "principal">sysdba</module-option>
              <module-option name = "userName">sysdba</module-option>
              <module-option name = "password">masterkey</module-option>
              <module-option name = "managedConnectionFactoryName">jboss.jca:service=XaTxCM,name=FirebirdDS</module-option>
              </login-module>
              </authentication>
              </application-policy>
              ------------------login-config.xml-------------------------------

              ************************************************************

              ------------------standardjbosscmp-jdbc.xml------------------
              <!-- ===================================================================== -->
              <!-- -->
              <!-- Standard JBossCMP-JDBC Configuration -->
              <!-- -->
              <!-- ===================================================================== -->

              <!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.34 2003/11/25 01:48:16 ejort Exp $ -->

              <jbosscmp-jdbc>

              <defaults>
              <datasource>java:/OracleDS</datasource>
              <datasource-mapping>Oracle</datasource-mapping>
              </defaults>
              </jbosscmp-jdbc>
              ------------------standardjbosscmp-jdbc.xml------------------

              ************************************************************

              ------------------standardjaws.xml-------------------------------
              <!-- ===================================================================== -->
              <!-- -->
              <!-- Standard Jaws Configuration -->
              <!-- -->
              <!-- ===================================================================== -->

              <!-- $Id: standardjaws.xml,v 1.30 2002/06/27 19:26:28 dsundstrom Exp $ -->

              <jaws>
              <datasource>java:/OracleDS</datasource>
              <type-mapping>Oracle</type-mapping>
              </jaws>

              ------------------standardjaws.xml------------------------------------

              ************************************************************

              make change of some xmls files "oracle-xa-ds.xml" in the JBOSS_HOME\server\default\deploy folder

              ************************************************************

              ------------------oracle-xa-ds.xml-------------------------------
              <datasources>
              <xa-datasource>
              <jndi-name>OracleDS</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:@172.30.1.6:1521:geo3pl</xa-datasource-property>
              <xa-datasource-property name="User">nhweb</xa-datasource-property>
              <xa-datasource-property name="Password">29178022</xa-datasource-property>

              <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>
              ------------------oracle-xa-ds.xml------------------------------------

              ************************************************************

              make change of some xmls files "oracle-jdbc2-service.xml" in the JBOSS_HOME\server\default\deploy\jms folder

              ------------------oracle-jdbc2-service.xml-------------------------------

              <mbean code="org.jboss.mq.pm.jdbc2.PersistenceManager"
              name="jboss.mq:service=PersistenceManager">
              <depends optional-attribute-name="ConnectionManager">jboss.jca:service=LocalTxCM,name=OracleDS</depends>

              ------------------oracle-jdbc2-service.xml-------------------------------

              ************************************************************


              2004-04-13 13:41:06,867 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] MBeanException: Exception in MBean operation 'checkIncompleteDeployments()'
              Cause: Incomplete Deployment listing:
              Packages waiting for a deployer:
              <none>
              Incompletely deployed packages:
              <none>
              MBeans waiting for classes:
              <none>
              MBeans waiting for other MBeans:
              [ObjectName: jboss.mq:service=InvocationLayer,type=HTTP
              state: CONFIGURED
              I Depend On: jboss.mq:service=Invoker
              jboss.web:service=WebServer

              Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=testTopic
              state: CONFIGURED
              I Depend On: jboss.mq:service=DestinationManager
              jboss.mq:service=SecurityManager

              Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=securedTopic
              state: CONFIGURED
              I Depend On: jboss.mq:service=DestinationManager
              jboss.mq:service=SecurityManager

              Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=testDurableTopic
              state: CONFIGURED
              I Depend On: jboss.mq:service=DestinationManager
              jboss.mq:service=SecurityManager

              Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=testQueue
              state: CONFIGURED
              I Depend On: jboss.mq:service=DestinationManager
              jboss.mq:service=SecurityManager

              Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=A
              state: CONFIGURED
              I Depend On: jboss.mq:service=DestinationManager

              Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=B
              state: CONFIGURED
              I Depend On: jboss.mq:service=DestinationManager

              Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=C
              state: CONFIGURED
              I Depend On: jboss.mq:service=DestinationManager

              Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=D
              state: CONFIGURED
              I Depend On: jboss.mq:service=DestinationManager

              Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=ex
              state: CONFIGURED
              I Depend On: jboss.mq:service=DestinationManager

              Depends On Me: , ObjectName: jboss.mq:service=Invoker
              state: CONFIGURED
              I Depend On: jboss.mq:service=TracingInterceptor

              Depends On Me: jboss.mq:service=InvocationLayer,type=HTTP
              jboss.mq:service=InvocationLayer,type=JVM
              jboss.mq:service=InvocationLayer,type=OIL
              jboss.mq:service=InvocationLayer,type=OIL2
              jboss.mq:service=InvocationLayer,type=RMI
              jboss.mq:service=InvocationLayer,type=UIL2
              , ObjectName: jboss.mq:service=TracingInterceptor
              state: CONFIGURED
              I Depend On: jboss.mq:service=SecurityManager

              Depends On Me: jboss.mq:service=Invoker
              , ObjectName: jboss.mq:service=SecurityManager
              state: CONFIGURED
              I Depend On: jboss.mq:service=DestinationManager

              Depends On Me: jboss.mq.destination:service=Topic,name=testTopic
              jboss.mq.destination:service=Topic,name=securedTopic
              jboss.mq.destination:service=Topic,name=testDurableTopic
              jboss.mq.destination:service=Queue,name=testQueue
              jboss.mq:service=TracingInterceptor
              jboss.mq.destination:service=Queue,name=DLQ
              , ObjectName: jboss.mq.destination:service=Queue,name=DLQ
              state: CONFIGURED
              I Depend On: jboss.mq:service=DestinationManager
              jboss.mq:service=SecurityManager

              Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=JVM
              state: CONFIGURED
              I Depend On: jboss.mq:service=Invoker

              Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=OIL
              state: CONFIGURED
              I Depend On: jboss.mq:service=Invoker

              Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=OIL2
              state: CONFIGURED
              I Depend On: jboss.mq:service=Invoker

              Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=RMI
              state: CONFIGURED
              I Depend On: jboss.mq:service=Invoker

              Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=UIL2
              state: CONFIGURED
              I Depend On: jboss.mq:service=Invoker

              Depends On Me: ]
              2004-04-13 13:41:06,877 INFO [org.jboss.deployment.scanner.URLDeploymentScanner] Started jboss.deployment:type=DeploymentScanner,flavor=URL
              2004-04-13 13:41:06,907 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/jboss-3.2.3/server/default/conf/jboss-service.xml
              2004-04-13 13:41:06,907 INFO [org.jboss.system.server.Server] JBoss (MX MicroKernel) [3.2.3 (build: CVSTag=JBoss_3_2_3 date=200311301445)] Started in 14s:621ms


              • 4. Re: configure oracle 9.2.0.4 datasoure on Jboss error

                You have created an XA connection manager for the xa datasource,
                but you are referencing a non-existent local connection manager in you
                oracle-jdbc2-service.xml

                Change LocalTxCM to XATxCM

                You don't need an XADataSource for JMS persistence (there is only ever one
                branch in the transaction).

                Regards,
                Adrian

                • 5. Re: configure oracle 9.2.0.4 datasoure on Jboss error
                  jackytang

                   

                  "adrian@jboss.org" wrote:
                  You have created an XA connection manager for the xa datasource,
                  but you are referencing a non-existent local connection manager in you
                  oracle-jdbc2-service.xml

                  Change LocalTxCM to XATxCM

                  You don't need an XADataSource for JMS persistence (there is only ever one
                  branch in the transaction).

                  Regards,
                  Adrian


                  Thanks for your reply.
                  I try to change LocalTxCM to XaTxCM, it still come out the same error message when Jboss start up.
                  As below are my setting files

                  Jboss on Windows 2000(localhost)
                  DB:Oracle 9.2.0.4 on RedHat AS2.1(172.30.1.6)

                  JBOSS_HOME = D:\jboss-3.2.3
                  Java_Home = C:\j2sdk1.4.1_02

                  I did copy the class12.zip, ojdbc14.jar to my
                  JBOSS_HOME\server\default\lib

                  and make change of some xmls files "jboss-service.xml",
                  "login-config.xml", "standardjbosscmp-jdbc.xml", "standardjaws.xml" in the JBOSS_HOME\server\default\conf directory

                  *************************************************************
                  ------------------jobss-service.xml-----------------------------
                  <!-- ==================================================================== -->
                  <!-- Transactions -->
                  <!-- ==================================================================== -->
                  <!-- The configurable Xid factory. For use with Oracle, set pad to true -->
                  <mbeancode="org.jboss.tm.XidFactory"name="jboss:service=XidFactory">true


                  ------------------jobss-service.xml-----------------------------

                  *************************************************************
                  ------------------login-config.xml-------------------------------
                  <application-policy name = "OracleDbRealm">

                  <login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule"
                  flag = "required">
                  <module-option name = "principal">nhweb</module-option>
                  <module-option name = "userName">nhweb</module-option>
                  <module-option name = "password">29178022</module-option>
                  <module-option name="managedConnectionFactoryName">jboss.jca:service=XaTxCM,name=OracleDS</module-option>
                  </login-module>

                  </application-policy>
                  ------------------login-config.xml-------------------------------

                  ************************************************************

                  ------------------standardjbosscmp-jdbc.xml------------------
                  <!-- ===================================================================== -->
                  <!-- -->
                  <!-- Standard JBossCMP-JDBC Configuration -->
                  <!-- -->
                  <!-- ===================================================================== -->

                  <!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.34 2003/11/25 01:48:16 ejort Exp $ -->

                  <jbosscmp-jdbc>


                  java:/OracleDS
                  <datasource-mapping>Oracle</datasource-mapping>

                  </jbosscmp-jdbc>
                  ------------------standardjbosscmp-jdbc.xml------------------

                  ************************************************************
                  ------------------standardjaws.xml-------------------------------
                  <!-- ===================================================================== -->
                  <!-- -->
                  <!-- Standard Jaws Configuration -->
                  <!-- -->
                  <!-- ===================================================================== -->

                  <!-- $Id: standardjaws.xml,v 1.30 2002/06/27 19:26:28 dsundstrom Exp $ -->


                  java:/OracleDS
                  <type-mapping>Oracle</type-mapping>


                  ------------------standardjaws.xml------------------------------------

                  ************************************************************

                  make change of some xmls files "oracle-xa-ds.xml" in the JBOSS_HOME\server\default\deploy folder

                  ************************************************************

                  ------------------oracle-xa-ds.xml-------------------------------

                  <xa-datasource>
                  <jndi-name>OracleDS</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:@172.30.1.6:1521:geo3pl</xa-datasource-property>
                  <xa-datasource-property name="User">nhweb</xa-datasource-property>
                  <xa-datasource-property name="Password">29178022</xa-datasource-property>


                  <depends optional-attribute-name="TransactionManagerService">jboss:service=TransactionManager



                  ------------------oracle-xa-ds.xml------------------------------------

                  ************************************************************

                  make change of "oracle-jdbc2-service.xml" in the JBOSS_HOME\server\default\deploy\jms folder

                  ------------------oracle-jdbc2-service.xml-------------------------------
                  <mbean code="org.jboss.mq.pm.jdbc2.PersistenceManager"name="jboss.mq:service=PersistenceManager">
                  <depends optional-attribute
                  name="ConnectionManager">jboss.jca:service=XaTxCM,name=OracleDS

                  ------------------oracle-jdbc2-service.xml-------------------------------

                  ************************************************************




                  • 6. Re: configure oracle 9.2.0.4 datasoure on Jboss error
                    jackytang

                    I also try to use oracle-ds.xml to replace oracle-xa-ds.xml file. And I make change of files as below and got the same error message

                    ---------------oracle-ds.xml--------------------------

                    <local-tx-datasource>
                    <jndi-name>DefaultDS</jndi-name>
                    <connection-url>jdbc:oracle:thin:@172.30.1.6:1521:geo3pl</connection-url>
                    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
                    <user-name>nhweb</user-name>
                    29178022
                    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>

                    </local-tx-datasource>



                    ---------------oracle-ds.xml--------------------------

                    ******************************************
                    ------------------jobss-service.xml---------------------
                    <!-- ==================================================================== -->
                    <!-- Transactions -->
                    <!-- ==================================================================== -->
                    <!-- The configurable Xid factory. For use with Oracle, set pad to true -->
                    <mbeancode="org.jboss.tm.XidFactory"name="jboss:service=XidFactory">true


                    ------------------jobss-service.xml---------------------

                    ******************************************
                    ------------------login-config.xml-----------------------
                    <application-policy name = "OracleDbRealm">

                    <login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule"
                    flag = "required">
                    <module-option name = "principal">nhweb</module-option>
                    <module-option name = "userName">nhweb</module-option>
                    <module-option name = "password">29178022</module-option>
                    <module-option name="managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=OracleDS</module-option>
                    </login-module>

                    </application-policy>
                    ------------------login-config.xml-----------------------

                    ******************************************

                    ------------------standardjbosscmp-jdbc.xml------------------
                    <!-- ===================================================================== -->
                    <!-- -->
                    <!-- Standard JBossCMP-JDBC Configuration -->
                    <!-- -->
                    <!-- ===================================================================== -->

                    <!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.34 2003/11/25 01:48:16 ejort Exp $ -->

                    <jbosscmp-jdbc>


                    java:/OracleDS
                    <datasource-mapping>Oracle</datasource-mapping>

                    </jbosscmp-jdbc>
                    ------------------standardjbosscmp-jdbc.xml------------------

                    ************************************************************
                    ------------------standardjaws.xml-------------------------------
                    <!-- ===================================================================== -->
                    <!-- -->
                    <!-- Standard Jaws Configuration -->
                    <!-- -->
                    <!-- ===================================================================== -->

                    <!-- $Id: standardjaws.xml,v 1.30 2002/06/27 19:26:28 dsundstrom Exp $ -->


                    java:/OracleDS
                    <type-mapping>Oracle</type-mapping>


                    ------------------standardjaws.xml---------------------
                    ************************************************************

                    make change of "oracle-jdbc2-service.xml" in the JBOSS_HOME\server\default\deploy\jms directory

                    ------------------oracle-jdbc2-service.xml-------------------------------
                    <mbean code="org.jboss.mq.pm.jdbc2.PersistenceManager"name="jboss.mq:service=PersistenceManager">
                    <depends optional-attribute
                    name="ConnectionManager">jboss.jca:service=LocalTxCM,name=OracleDS

                    ------------------oracle-jdbc2-service.xml-------------
                    ******************************************

                    • 7. Re: configure oracle 9.2.0.4 datasoure on Jboss error
                      jackytang

                      I have tried everthing I can, finally I copy the oracle-jdbc2-service.xml again from /doc/examples/jms then there is no more error message.
                      So I think the problem is that I have edited the file of oracle-jdbc2-service.xml by the wordpad and save it as text style.