3 Replies Latest reply on Feb 27, 2002 3:51 AM by jian gao

    Oracle configuration

    Lionel Lavallee Newbie

      I get the following exception when I attempt to deploy on JBoss:

      [AutoDeployer] org.jboss.deployment.J2eeDeploymentException: Error while starting shopping.jar: Could not deploy file:/C:/JBoss-2.4.3/tmp/deploy/Default/shopping.jar, Cause: org.jboss.ejb.DeploymentException: Could not deploy file:/C:/JBoss-2.4.3/tmp/deploy/Default/shopping.jar, Cause:org.jboss.ejb.DeploymentException:
      jdbc:oracle:thin:@localhost:1521:mml not bound


      I know this connection string is valid, since I've done some JUnit tests on code not EJB related in the application.

      Here's the JBoss.jcml configuration that the documentation recommends:


      300
      <!-- Use this attribute if you need to use a specific Xid
      implementation-->
      oracle.jdbc.xa.OracleXid


      .
      .
      .

      <!-- ==================================================================== -->
      <!-- JDBC -->
      <!-- ==================================================================== -->
      <!-- Oracle Configuration -->

      oracle.jdbc.driver.OracleDriver


      OracleDB
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl[JBoss 2.4]
      jdbc:oracle:thin:@localhost:1521:mml
      lionel
      tahiti02

      <!-- Oracle Configuration -->

      As specified, I've commented out the default hpyersonic, etc. default database. Any ideas?

        • 1. Re: Oracle configuration
          Allen Fogleson Newbie

          I dont really see anything wrong, except you should not specify the oracle XID class in the XID attribute. place it in the jboss.properties file. here is my entry in jboss.properties:

          jboss.xa.xidclass=oracle.jdbc.xa.OracleXid

          And my Jboss.jcml entry: (first make sure it is in the drivers)


          oracle.jdbc.driver.OracleDriver,org.hsqldb.jdbcDriver



          Then the datasource mbean:


          multiDS
          org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl

          jdbc:oracle:thin:@quasar:1521:dbo
          1200000
          scott
          10
          tiger
          false
          false
          false
          true
          120000
          1800000
          false
          false
          1.0
          0


          Hope this helps.

          Al

          • 2. Re: Oracle configuration
            jian gao Newbie

            Hello: fogLesa.
            I am also intrested in this ,I did as you wrote, but when I make a jndi lookup for
            "java;/MultiDS", I got javax.naming.NameNotFoundException.

            But when I lookup "java:/InstantDB" (the existing tag in jboss.jcml), I succeed.

            Is there still anything for make the Oracle Datasource available for jndi lookup ? Thanks

            • 3. Re: Oracle configuration
              jian gao Newbie

              I have known it, I found that I have configured the wrong file.
              Because I use jboss-tomcat, so I should configure the jboss.jcml on \conf\tomcat ,not the file with same name on \conf\default