[jboss-as7-dev] Oracle datasource missing dependencies

paulwerder at fastmail.co.uk paulwerder at fastmail.co.uk
Wed May 4 04:39:52 EDT 2011


Hi JBoss devs,
I'm testing Oracle connectivity using a 10.2 JDBC Driver (ojdbc14.jar).
Seems there are some issues- has anyone managed to connect to an Oracle
DB ?
This is what the server reports:

 report
   New missing/unsatisfied dependencies:
      service jboss.jdbc-driver."oracle.jdbc.driver.OracleDriver".10.2
      (missing)

And my configuration:

<datasource jndi-name="java:/OracleDS" pool-name="OracleDS"
enabled="true" use-java-context="true">
                    <connection-url>
                        jdbc:oracle:thin:@192.168.1.1:1530:ORACLESID
                    </connection-url>
                    <driver-class>
                        oracle.jdbc.driver.OracleDriver
                    </driver-class>
                    <driver>
                        oracle.jdbc.driver.OracleDriver#10.2
                    </driver>
                    <pool>
                        <prefill>
                            true
                        </prefill>
                        <use-strict-min>
                            false
                        </use-strict-min>
                    </pool>
                    <security>
                        <user-name>test</user-name>
                        <password>test</password>
                    </security>
                    <validation>
                        <validate-on-match>
                            false
                        </validate-on-match>
                        <background-validation>
                            false
                        </background-validation>
                        <useFastFail>
                            false
                        </useFastFail>
                    </validation>
                    <statement/>
                </datasource>

I've chosen to install the JDBC driver as a module, so under the
"modules" folder I've added: 
oracle
└───jdbc
    └───main
            module.xml
            ojdbc14.jar
            ojdbc14.jar.index

Last thing, the module.xml:

<module xmlns="urn:jboss:module:1.0" name="oracle.jdbc">
  <resources>
    <resource-root path="ojdbc14.jar"/>
        <!-- Insert resources here -->
  </resources>
  <dependencies>
    <module name="javax.api"/>
  </dependencies>
</module>

Can you find any reason why the driver does not get deployed ?
(I've tried also adding META-INF/services/java.sql.Driver with the
driver class name- it didn't help however).
Thanks a lot
Paul
-- 
  
  paulwerder at fastmail.co.uk

-- 
http://www.fastmail.fm - IMAP accessible web-mail




More information about the jboss-as7-dev mailing list