4 Replies Latest reply on Oct 11, 2017 11:56 AM by davidcorino

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

    loredana

      Hello,

       

      I am trying create Oracle database connection, but without success for about two days :((((((  I am using jboss 7.1.1 Final

      Below is a part of my configuration files:

       

       

      standalone.xml

      <subsystem xmlns="urn:jboss:domain:datasources:1.0">

           <datasources>

                      <datasource jndi-name="java:jboss/datasources/DefaultDS" pool-name="DefaultDS_pool" enabled="true" use-java-context="true">           

                          <connection-url>jdbc:oracle:thin:@XXX</connection-url>

                          <driver>ojdbc6</driver>

                          <security>

                              <user-name>XXX</user-name>

                              <password>XXX</password>

                          </security>

                      </datasource>

                      <drivers>

                          <driver name="ojdbc6" module="com.oracle.ojdbc6">

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

                          </driver>

                      </drivers>

           <datasources>

      </subsystem>

       

      <subsystem xmlns="urn:jboss:domain:ee:1.0">

           <global-modules>

                <module name="com.oracle.ojdbc6" slot="main" />

           </global-modules>

      </subsystem>

       

      module.xml

      <module xmlns="urn:jboss:module:1.1" name="com.oracle.ojdbc6">

          <resources>

              <resource-root path="ojdbc6.jar"/>

          </resources>

          <dependencies>

              <module name="javax.api"/>

              <module name="javax.transaction.api"/>

          </dependencies>  

      </module>

       

      The  module.xml and ojdbc6.jar files are put in jboss/modules/com/oracle/main folder. When I start jboss the following error is thrown:

       

      New missing/unsatisfied dependencies:

            service jboss.jdbc-driver.ojdbc6 (missing) dependents: [service jboss.data-source.java:jboss/datasources/DefaultDS]

       

      When Jboss is going to shutdown the following message appears:

       

      JBAS014776:    Newly corrected services:

            service jboss.jdbc-driver.ojdbc6 (new available)

       

       

      Do have any ideea how to fix this?  I would appreciate your help. Thank you.


        • 1. Re: New missing/unsatisfied dependencies:  service jboss.jdbc-driver.ojdbc6 (missing)
          loredana

          Thanks to Stefano MAESTRI who posted the article http://www.javalinux.it/wordpress/2011/07/14/how-to-create-an-manage-datasources-in-as7/, I have succeeded in configuring oracle datasource.

           

          Here is part of my configuration files:

          standalone.xml

          <subsystem xmlns="urn:jboss:domain:datasources:1.0">

               <datasources>

                          <datasource jndi-name="java:jboss/datasources/DefaultDS" pool-name="DefaultDS_pool" enabled="true" use-java-context="true">           

                              <connection-url>jdbc:oracle:thin:@localhost:1521:C3S</connection-url>

                              <driver>oracle</driver>

                              <security>

                                  <user-name>jboss</user-name>

                                  <password>sysadm</password>

                              </security>

                          </datasource>

                          <drivers>

                              <driver name="oracle" module="com.oracle.jdbc">

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

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

                              </driver>

                          </drivers>

                      </datasources>

          </subsystem>

          In  $JBOSS_HOME/modules/com/oracle/jdbc/main I have copied the ojdbc6.jar and created the module.xml file.

          module.xml

          <?xml version="1.0" encoding="UTF-8"?>

          <module xmlns="urn:jboss:module:1.0" name="com.oracle.jdbc">

            <resources>

              <resource-root path="ojdbc6.jar"/>

            </resources>

            <dependencies>

              <module name="javax.api"/>

              <module name="javax.transaction.api"/>

            </dependencies>

          </module>

          • 2. Re: New missing/unsatisfied dependencies:  service jboss.jdbc-driver.ojdbc6 (missing)
            latha

            Hi, i am getting same exceptions.....I have followed what you posted  but still shows same error....Specified JDBC Driver oracle.jdbc.OracleDriver class not found

            03:11:32,954 INFO  [org.hibernate.cfg.Configuration] (MSC service thread 1-2) HHH000041: Configured SessionFactory: null

            03:11:33,217 INFO  [org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl] (MSC service thread 1-2) HHH000402: Using Hibernate built-in connection pool (not for production use!)

            03:11:33,225 ERROR [stderr] (MSC service thread 1-2) org.hibernate.service.classloading.spi.ClassLoadingException: Specified JDBC Driver oracle.jdbc.OracleDriver class not found.

             

             

            Can you please help me..................thanks in advance...

            • 3. Re: New missing/unsatisfied dependencies:  service jboss.jdbc-driver.ojdbc6 (missing)
              mayerw01

              You should install the driver either via a regular deployment or as a module (DataSource configuration - JBoss AS 7.1 - Project Documentation Editor)

              The preferred approach is to install the driver as a module.

              You might also find this link helpful (JDBC Driver / DataSource Setup | HAL Management Console)

              • 4. Re: New missing/unsatisfied dependencies:  service jboss.jdbc-driver.ojdbc6 (missing)
                davidcorino

                Try the follow command:

                 

                module add \

                  --name=com.timesten.jdbc.TimesTenDriver \

                  --resources= $(path)/ttjdbc8.jar \

                  --dependencies=javax.api \

                  --slot=main

                 

                /profile=$name_profile/subsystem=datasources/jdbc-driver=$name_driver/:add(driver-module-name=com.timesten.jdbc.TimesTenDriver,driver-name=oratt,jdbc-compliant=true,driver-datasource-class-name=com.timesten.jdbc.TimesTenDriver)