6 Replies Latest reply on Jul 12, 2012 5:51 AM by Wolf-Dieter Fink

    New missing/unsatisfied dependencies:service jboss.jdbc-driver.oracle_ojdbc (missing)

    Patrick Mingard Newbie

      Hi,

      I do try to migrate a JBoss 5.1.0.GA project to JBoss 7.0.2.FINAL. I'm currently stuck on the Oracle datasource (11g) configuration. I saw many people saying this configuration was working for them. I guess I made a small mistake somewhere but cannot figure what it is.

       

      I created an oracle/ojdbc folder under the modules folder of the JBoss install. In it, I placed my ojdbc6-11.2.0.jar file.

      Here is my module.xml file :

       

      <?xml version="1.0" encoding="UTF-8"?>
      <module xmlns="urn:jboss:module:1.0" name="oracle.ojdbc">
        <resources>
          <resource-root path="ojdbc6-11.2.0.jar"/>
        </resources>
        <dependencies>
          <module name="javax.api"/>
        </dependencies>
      </module>
      

       

      I'm using the standalone configuration for my JBoss, then I edited the standalone.xml file. I added a <system-properties> section that perfectly works.

       

      Here is my standalone.xml file (I removed most sections I did not modify) :

       

       

       <server xmlns="urn:jboss:domain:1.0">
      
          <extensions>
              <extension module="org.jboss.as.clustering.infinispan"/>
              <extension module="org.jboss.as.connector"/>
              <extension module="org.jboss.as.deployment-scanner"/>
              <extension module="org.jboss.as.ee"/>
              <extension module="org.jboss.as.ejb3"/>
              <extension module="org.jboss.as.jaxrs"/>
              <extension module="org.jboss.as.jmx"/>
              <extension module="org.jboss.as.jpa"/>
              <extension module="org.jboss.as.logging"/>
              <extension module="org.jboss.as.naming"/>
              <extension module="org.jboss.as.osgi"/>
              <extension module="org.jboss.as.pojo"/>
              <extension module="org.jboss.as.remoting"/>
              <extension module="org.jboss.as.sar"/>
              <extension module="org.jboss.as.security"/>
              <extension module="org.jboss.as.threads"/>
              <extension module="org.jboss.as.transactions"/>
              <extension module="org.jboss.as.web" />
              <extension module="org.jboss.as.weld" />
          </extensions>
      
          <system-properties>
              ....
          </system-properties>
      
          <management>
              ....
          </management>
      
          <profile>
              ....
              <subsystem xmlns="urn:jboss:domain:datasources:1.0">
                  <datasources>
                      <datasource jndi-name="java:jboss/datasources/ExampleDS" enabled="true" use-java-context="true" pool-name="H2DS">
                          <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url>
                          <driver>h2</driver>
                          <pool></pool>
                          <security>
                              <user-name>sa</user-name>
                              <password>sa</password>
                          </security>
                      </datasource>
                      <datasource jndi-name="java:/PrestOracleDS" pool-name="OracleDS">
                          <connection-url>jdbc:oracle:thin:@##HOST##:##PORT##:##SID##</connection-url>
                          <driver>oracle.ojdbc</driver>
                          <pool>
                              <min-pool-size>5</min-pool-size>
                              <max-pool-size>100</max-pool-size>
                              <prefill>true</prefill>
                          </pool>
                          <security>
                              <user-name>##USER##</user-name>
                              <password>##PASS##</password>
                          </security>
                      </datasource>
                      <drivers>
                          <driver name="oracle.ojdbc" module="oracle.ojdbc">
                              <xa-datasource-class>oracle.jdbc.driver.OracleDriver</xa-datasource-class>
                          </driver>
                          <driver name="h2" module="com.h2database.h2">
                              <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
                          </driver>
                      </drivers>
                  </datasources>
              </subsystem>
              ....
          </profile>
      
          <interfaces>
              ....
          </interfaces>
      
          <socket-binding-group name="standard-sockets" default-interface="public">
              ....
          </socket-binding-group>
      
      </server>
      

       

      At startup (without any deployment), I always receive :

       

      13:52:07,144 INFO  [org.jboss.as.controller] (Controller Boot Thread) Service status report

         New missing/unsatisfied dependencies:

            service jboss.jdbc-driver.oracle_ojdbc (missing)

       

      At startup (with deployment), I do receive :

       

      14:13:50,001 ERROR [org.jboss.as.deployment] (DeploymentScanner-threads - 1) {"Composite operation failed and was rolled back. Steps that failed:" => {"Operation step-2" => "Operation handler failed to complete"}}

       

      Any help would be greatly appreciated.

       

      Thanks in advance !

       

      Edit : added the version of Oracle I am using (11g)

       

      Edit2: I tried these configurations for the <driver> section :

       

       

      <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
      

       

      <xa-datasource-class>oracle.jdbc.xa.OracleXADataSource</xa-datasource-class>
      

       

      <driver-class>oracle.jdbc.driver.OracleDriver></driver-class>
      

       

      <driver-class>oracle.jdbc.OracleDriver></driver-class>
      

       

      And almost any combination of one of the two first with one of the two last...

       

      Edit3 : I'm completely desperate... I tried all the same configurations again with ojdbc14.jar, the older version of the driver... the message still stay strictly the same... I start to wonder if I'm looking the right direction...