2 Replies Latest reply on Feb 19, 2019 10:49 AM by ctomc

    Oracle JDBC7 doesn't work

    spinalsc

      Hello !

       

      I'm trying figure out how solve this problem.

      I create a brand new Wildfly 14.0.1 using Centos 7 64 Bits.

      almost perfect..

       

      1) jdbc

      I get my jodbc7.jar from oracle website ...

      File = /opt/wildfly-14.0.1.Final/modules/system/layers/base/com/oracle/ojdbc7/main/ojdbc7.jar

       

      Module.xml (im this same folder)

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

        <resources>

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

        </resources>

        <dependencies>

          <module name="javax.api"/>

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

        </dependencies>

      </module>

       

      2) Standalone.xml

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

                  <datasources>

                     <datasource jndi-name="java:/OracleDS" pool-name="OracleDS" enabled="true">

                          <connection-url>jdbc:oracle:thin:@192.168.0.242:1521:kiarroz</connection-url>

                          <driver>oracle</driver>

                          <pool>

                              <min-pool-size>10</min-pool-size>

                              <max-pool-size>100</max-pool-size>

                              <prefill>true</prefill>

                          </pool>

                          <security>

                              <user-name>sac</user-name>

                              <password>****</password>

                          </security>

                      </datasource>

                      <drivers>

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

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

                          </driver>

                      </drivers>

                  </datasources>

       

      Here is my problem.. when I start the wildfly service.. some messages appears...

       

      message 1)

      15:04:36,048 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 41) WFLYCTL0013: Operation ("add") failed - address: ([

          ("subsystem" => "datasources"),

          ("jdbc-driver" => "oracle")

      ]) - failure description: "WFLYJCA0115: Module for driver [com.oracle] or one of it dependencies is missing: [com.oracle]"

       

      message 2)

       

      15:04:41,194 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([

          ("subsystem" => "datasources"),

          ("data-source" => "OracleDS")

      ]) - failure description: {

          "WFLYCTL0412: Required services that are not installed:" => ["jboss.jdbc-driver.oracle"],

          "WFLYCTL0180: Services with missing/unavailable dependencies" => [

              "jboss.driver-demander.java:/OracleDS is missing [jboss.jdbc-driver.oracle]",

              "org.wildfly.data-source.OracleDS is missing [jboss.jdbc-driver.oracle]"

          ]

      }

      15:04:41,211 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([

          ("subsystem" => "datasources"),

          ("data-source" => "OracleDS")

      ]) - failure description: {

          "WFLYCTL0412: Required services that are not installed:" => [

              "jboss.jdbc-driver.oracle",

              "jboss.jdbc-driver.oracle"

          ],

          "WFLYCTL0180: Services with missing/unavailable dependencies" => [

              "jboss.driver-demander.java:/OracleDS is missing [jboss.jdbc-driver.oracle]",

              "org.wildfly.data-source.OracleDS is missing [jboss.jdbc-driver.oracle]",

              "org.wildfly.data-source.OracleDS is missing [jboss.jdbc-driver.oracle]"

          ]

      }

       

      I searched deep inside all foruns.. I tried using the web console.. but with no lucky

      I would apreciate all your help!

      Tks