[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