5 Replies Latest reply on Feb 24, 2014 11:10 AM by wdfink

    Installation Oracle database driver 12c ojdbc7.jar as module

    schlumpf

      Hi all,

       

      I trying to install the oracle database driver ojdbc7.jar as module via jboss-cli.sh.

      But it doesn't work for me.

      The command returned no error and there was new folder in the module-path togeher with module.xml-file,

      But I cannot select the driver for create a new datasource with the administration console.

       

      Sorry for the following questions, but I am I newbie in wildfly 8:

      - Does anybody know which dependencies the ojdbc7.jar needs?

      - Can I inform myself about the installed modules with the CLI or administration console? I am searching for a list, where I can see which module ist installed.

       

      Thanks a lot!

       

      schlumpf

        • 1. Re: Installation Oracle database driver 12c ojdbc7.jar as module
          wdfink

          Could you show your commands and what the result is in your modules directory?

          normally for a db driver you need to have javax.api and javax.transaction.api as dependency

          1 of 1 people found this helpful
          • 2. Re: Installation Oracle database driver 12c ojdbc7.jar as module
            schlumpf

            Hi Wolf-Dieter,

             

            I have used the command 'module add --name=oracle.jdbc --resources=/tmp/ojdbc7.jar --dependencies=javax.api,javax.transaction.api'  resulting in the folder structure (directories) $JBOSS_MODULEPATH/oralce/jdbc/main with the ojdbc7.jar and module.xml file in it.

             

            Then I have started the administration console and wanted to create a new JDBC datasource, but there isn't any Oracle driver to select.

            • 3. Re: Installation Oracle database driver 12c ojdbc7.jar as module
              wdfink

              Not I got it.

               

              You 'only' add the jar as a module to the server directory, nothing more.

               

              Now you need to add the driver and datasource via CLI or console

               

              i.e. try:

              jboss-cli.sh

              >/subsystem=datasources/jdbc-driver=Oracle:add(driver-name="Oracle", driver-module-name="oracle.jdbc", driver-xa-datasource-class-name="oracle.jdbc.xa.client.OracleXADataSource")

              >/subsystem=datasources/data-source=Oracle:add(jndi-name=java:/Oracle, connection-url= jdbc:oracle:thin:@x.x.x.x:1521:orcl, driver-name=Oracle, user-name=X, password=X)

               

              I've looked into the http management but did not found a possiblility to add the driver, maybe it's intentional as you can't add the module from here.

              So ATM you need to add the datasources-drivers-driver by CLI

              • 4. Re: Installation Oracle database driver 12c ojdbc7.jar as module
                schlumpf

                Hi Wolf-Dieter,

                 

                thank you for you help, it works fine.

                • 5. Re: Installation Oracle database driver 12c ojdbc7.jar as module
                  wdfink

                  Hello Knut,

                   

                  great to know that it's working.

                  Could you mark the related answer and the thread as answered to help other find the solution quicker?

                  1 of 1 people found this helpful