Hello,>do you have a> <drivers><driver module="oracle.jdbc"/>> </drivers>>in your configuration at datasources subsystem?yes I have inserted it, exaclty as you typed it. (sorry I forgot to mention it before.)might it be a specific issue with this JDBC driver ?regardsPaul--On Wed, 04 May 2011 12:54 +0300, "Nicklas Karlsson" <nickarls@gmail.com> wrote:do you have a<drivers><driver module="oracle.jdbc"/></drivers>in your configuration at datasources subsystem?On Wed, May 4, 2011 at 11:39 AM, <paulwerder@fastmail.co.uk> wrote: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@fastmail.co.uk
--
http://www.fastmail.fm - IMAP accessible web-mail
_______________________________________________
jboss-as7-dev mailing list
jboss-as7-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
--
---
Nik_______________________________________________ jboss-as7-dev mailing list jboss-as7-dev@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-as7-dev-- http://www.fastmail.fm - mmm... Fastmail..._______________________________________________
jboss-as7-dev mailing list
jboss-as7-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-as7-dev