4 Replies Latest reply on Sep 26, 2002 3:12 PM by Dennis Carroll

    Jboss 3.0.2 and Oracle 8i Datasource

    Ahmed EL-serafy Newbie

      I'm using Jboss for the first time, I’m trying to configure it to work with Oracle 8.1.7 (8i).

      I’ve used the downloaded binaries and copied oracle-service.xml file to deploy directory.

      Unfortunately, I’m getting this error:

      13:34:10,894 ERROR [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.jca:service=LocalTxCM,name=OracleDS
      state: CONFIGURED
      I Depend On: jboss.jca:service=LocalTxDS,name=OracleDS
      jboss.jca:service=LocalTxPool,name=OracleDS
      jboss.jca:service=CachedConnectionManager
      jboss.security:service=JaasSecurityManager
      jboss.jca:service=RARDeployer

      Depends On Me: , ObjectName: jboss.jca:service=LocalTxDS,name=OracleDS
      state: CONFIGURED
      I Depend On: jboss.jca:service=RARDeployment,
      name=JBoss LocalTransaction JDBC Wrapper

      Depends On Me: jboss.jca:service=LocalTxCM,name=OracleDS
      ]

        • 1. Re: Jboss 3.0.2 and Oracle 8i Datasource
          koo Newbie

          did you change ?
          jdbc:oracle:thin:@youroraclehost:1521:yoursid
          did you add oracle jdbc driver in run.bat ?
          JBOSS_CLASSPATH=%JBOSS_CLASSPATH%;%JAVAC_JAR%;%RUNJAR%;%JBOSS_HOME%\lib\classes12.zip

          • 2. Re: Jboss 3.0.2 and Oracle 8i Datasource
            Ahmed EL-serafy Newbie

            Thanks a lot for your reply.. :)

            Yes I did.
            Do I need to build Jboss for oracle to work ?

            my oracle-service.xml file:
            <?xml version="1.0" encoding="UTF-8"?>



            <!-- ConnectionManager setup for Oracle dbs -->
            <!-- Build jmx-api (build/build.sh all) and view for config documentation -->
            <!-- Thanks to Steven -->




            <depends optional-attribute-name="ManagedConnectionFactoryName">
            <!--embedded mbean-->


            OracleDS



            <config-property name="ConnectionURL" type="java.lang.String">jdbc:oracle:thin:@localhost:1521:IFLOW</config-property>
            <config-property name="DriverClass" type="java.lang.String">oracle.jdbc.driver.OracleDriver</config-property>
            <config-property name="UserName" type="java.lang.String">caseware</config-property>
            <config-property name="Password" type="java.lang.String">caseware</config-property>




            <!--Below here are advanced properties -->
            <!--hack-->
            <depends optional-attribute-name="OldRarDeployment">
            jboss.jca:service=RARDeployment,
            name=JBoss LocalTransaction JDBC Wrapper




            <depends optional-attribute-name="ManagedConnectionPool">
            <!--embedded mbean-->


            0
            50
            5000
            15
            <!--criteria indicates if Subject (from security domain) or app supplied
            parameters (such as from getConnection(user, pw)) are used to distinguish
            connections in the pool. Choices are
            ByContainerAndApplication (use both),
            ByContainer (use Subject),
            ByApplication (use app supplied params only),
            ByNothing (all connections are equivalent, usually if adapter supports
            reauthentication)-->
            ByContainer



            <depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager

            <depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager

            java:/TransactionManager

            <!--make the rar deploy! hack till better deployment-->
            jboss.jca:service=RARDeployer




            • 3. Re: Jboss 3.0.2 and Oracle 8i Datasource
              koo Newbie

              place the oracle-service.xml in the default/deploy directory you'll see the connection when jboss starts

              • 4. Re: Jboss 3.0.2 and Oracle 8i Datasource
                Dennis Carroll Newbie

                I have also been trying for many hours to get the simplest workbook example (ex04_1) to run with mysql and oracle. Apparently I've been taking on too much for a novice (like trying to get itracker - http://sourceforge.net/projects/itracker installed).

                My setup:
                JBoss distribution - JBoss-3.0.2.zip
                JSDK distribution - j2sdk-1_4_1-windows-i586.exe
                jdbc drivers - mm.mysql-2.0.14-bin.jar and classes12.zip

                These are ALL the changed I made:
                1. added the jdbc drivers to bin/run.bat

                2. changed the ex04_1 build.xml to point directly to the jboss directory (also removed JBOSS_HOME env variable). Just make sure property jboss.home gets set properly.

                3. copied mysql-service.xml from docs/examples/jca to server/default/deploy and removed hsqldb-service.xml. In mysql-service changed the ConnectionURL config-property to jdbc:mysql://localhost:3306/mysql and added the appropriate UserName and Password in their config-property tags.

                4. in server/default/conf/standardjaws.xml changed
                java:/DefaultDS
                <type-mapping>Hypersonic SQL</type-mapping>
                to
                java:/MySqlDS
                <type-mapping>mySQL</type-mapping>

                5. in server/default/conf/standardjbosscmp-jdbc.xml changed
                java:/DefaultDS
                <datasource-mapping>Hypersonic SQL</datasource-mapping>
                to
                java:/MySqlDS
                <datasource-mapping>mySQL</datasource-mapping>

                6. started the server with run.bat (did not use "-c all")

                7. in the ex04_1
                ant
                (sucessfully deployed CabinEJB)
                ant run.client_41a
                (added the master suite record)
                ant run.client_41b
                (added 99 suite records)

                I followed the same procedure to run this agiainst the oracle db.


                Regards,
                Dennis