3 Replies Latest reply on Mar 5, 2013 3:38 AM by Stefano Maestri

    ojdbc6.jar installation

    sammie88 Newbie

      Hi,

       

      I installed the oracle driver, ojdbc.jar by simply deploying it.  My standalone.xml looks like

       

      <datasource jndi-name="java:/TestXX" pool-name="TestXX" enabled="true" use-java-context="true">

                          <connection-url>jdbc:oracle:thin:@122.810.99.11:1522:test5</connection-url>

                          <driver>ojdbc6.jar</driver>

                          <pool>

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

                              <max-pool-size>50</max-pool-size>

                              <prefill>true</prefill>

                              <use-strict-min>false</use-strict-min>

                              <flush-strategy>FailingConnectionOnly</flush-strategy>

                          </pool>

                          <security>

                              <user-name>xxxx</user-name>

                              <password>xxxxxxxx</password>

                          </security>

                          <timeout>

                              <idle-timeout-minutes>1</idle-timeout-minutes>

                          </timeout>

                      </datasource>

       

      When deploying I get the ff error/msg:

       

      JBAS014775:    New missing/unsatisfied dependencies:

            service jboss.jdbc-driver.ojdbc6_jar (missing) dependents: [service jboss.data-source.java ------

      -----

      -----

      -----

       

      JBAS014776:    Newly corrected services:

            service jboss.jdbc-driver.ojdbc6_jar (no longer required)

       

      When I try to connect to the db, everything seems to work. I'm just wondering why I get the messages above.  Im using jboss-as-7.1.1.Final

       

      Thanks!

        • 1. Re: ojdbc6.jar installation
          Nicklas Karlsson Master

          Perhaps it's just a temporary glitch when a new dependency becomes available and is not yet used? There was a related error with the name of the driver deployed as a jar but I don't think it affected 7.1.1.

          • 2. Re: ojdbc6.jar installation
            Frank Langelage Master

            You first start JBoss AS7 with config as as shown above and then deploy ojdbc6.jar by copying it to the $JBOSS_HOME/standalone/deployments?

            Then this is normal. Standalone.xml is referencing a datasource not yet available.

            If if this shown after stop and during the new again, I think JBoss should not show these messages, may be it's just a problem of deployment order.

             

            I remember such that I saw such messages too.

            But now I have my datasources defined not in standalone.xml itself but in -ds.xml files like with server version before.

            And at least 7.2.0 does not show such mesages then.

            • 3. Re: ojdbc6.jar installation
              Stefano Maestri Expert

              Let me remark that -ds.xml has some limitation, and the main one is that DSes defined this way is not maneageable. The most correct approach is to deploy driver as module and define driver and DSes in standalone.xml.

              Note also that defining driver in standalone make it maneageable too and moreover it could be define more option there (the most important one is xa-datasource-class definition at driver level instead of define it in every DSes).

               

              Your approach is not wrong, but you are accepting limitation and making DSes definition more complex (you need 2 deploy instead of a centralized configuration) especially if you swith to domain mode.

               

              Just a precisation to give you the full context, hoping it could be useful

               

              regards

              S.