7 Replies Latest reply on Oct 1, 2002 4:57 AM by Christoph Grimm

    Oracle9i DataSource Configuration

    Yannick HIERSO Newbie

      Hi,

      I have read some threads about DataSource Configuration but still could not solve my probleme ( I hope a classic one ).

      My oracle-service.xml file :


      OracleDbRealm
      java:/TransactionManager
      <depends optional-attribute-name="ManagedConnectionFactoryName">

      OracleDS


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


      <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper


      <depends optional-attribute-name="ManagedConnectionPool">

      0
      5
      5000
      15
      ByContainer


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



      My addition in the login-config.xml file :
      <application-policy name = "OracleDbRealm">

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

      </application-policy>

      I copy the classes12.jar in server/lib and add the jar to the server classpath.

      In the JBoss Management I have :
      service=LocalTxPool,name=OracleDS ( status = STARTED )
      service=LocalTxDS,name=OracleDS
      service=LocalTxCM,name=OracleDS ( status = FAILED )
      and nothing in Jndi View.

      Finally my error :
      At startup :
      The MBeans waiting for MBeans thing.
      When I try to start the LocalTxCM from console :
      javax.naming.NameNotFoundException: TransactionManager not bound

      Last detail, I have my own Server Environnement.

      If someone could help, thanks in advance.

        • 1. Re: Oracle9i DataSource Configuration
          Christoph Grimm Newbie

          i have never used the oracle realm stuff, but my config to access oracle 9i looks like this:





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


          WORK_DS



          <config-property name="ConnectionURL" type="java.lang.String">jdbc:oracle:thin:@myserver:myport:myservice</config-property>
          <config-property name="DriverClass" type="java.lang.String">oracle.jdbc.driver.OracleDriver</config-property>
          <config-property name="UserName" type="java.lang.String">...myuser...</config-property>
          <config-property name="Password" type="java.lang.String">...mypassword...</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
          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




          ps:

          be aware to use the newest oracle classes12.zip and put it in the server/lib dir

          elder versions of classes12.zip that worked well with 8.x do not work anymore with 9.x

          • 2. Re: Oracle9i DataSource Configuration
            Yannick HIERSO Newbie

            Hi,

            Thank you very much for your answer but same bad result for
            me.

            How can I be sure that it's not the fault of my Database Server ? My listener is running and registered my database instance, my login is ok in oracle-service.xml; but now I would like to be sure that it's just a configuration problem in JBoss and not a database setup problem.

            • 3. Re: Oracle9i DataSource Configuration
              Yannick HIERSO Newbie

              Hi,

              Thank you very much for your answer but same bad result for
              me.

              How can I be sure that it's not the fault of my Database Server ? My listener is running and registered my database instance, my login is ok in oracle-service.xml; but now I would like to be sure that it's just a configuration problem in JBoss and not a database setup problem.

              • 4. Re: Oracle9i DataSource Configuration
                Yannick HIERSO Newbie

                Hi,

                Thank you very much for your answer but same bad result for
                me.

                How can I be sure that it's not the fault of my Database Server ? My listener is running and registered my database instance, my login is ok in oracle-service.xml; but now I would like to be sure that it's just a configuration problem in JBoss and not a database setup problem.

                • 5. Re: Oracle9i DataSource Configuration
                  Yannick HIERSO Newbie

                  Hi,

                  Thank you very much for your answer but same bad result for
                  me.

                  How can I be sure that it's not the fault of my Database Server ? My listener is running and registered my database instance, my login is ok in oracle-service.xml; but now I would like to be sure that it's just a configuration problem in JBoss and not a database setup problem.

                  • 6. Re: Oracle9i DataSource Configuration
                    Yannick HIERSO Newbie

                    Sorry for all this, I didn't see my reply just after its addition so I keep trying until feed up.

                    • 7. Re: Oracle9i DataSource Configuration
                      Christoph Grimm Newbie

                      to find out if it's the fault of your sserver, you may
                      create a little test program accessing your database directly via jdbc
                      with the same DriverClass, ConnectionURL, UserName and Password.

                      run the testprogram in the same enviroment as the jboss server