[jboss-as7-dev] Oracle datasource missing dependencies
Stefano Maestri
smaestri at redhat.com
Wed May 4 08:54:59 EDT 2011
The problem is the driver itself.
Oracle 10.2 jdbc driver is type 3 driver and it can't be loaded by
java.util.ServiceLoader using the META-INF/services directory in the jar.
And it's the only way we are supporting jdbc as module or deployment.
IOW we are just supporting type 4 driver.
Use Oracle 11g driver, I've tested it and it's working.
regards
S.
On 05/04/2011 01:14 PM, Nicklas Karlsson wrote:
> And the version number is correct for the driver?
>
> On Wed, May 4, 2011 at 1:40 PM, <paulwerder at fastmail.co.uk
> <mailto:paulwerder at fastmail.co.uk>> wrote:
>
> Hello Ike,
> >This is just a vague guess, but there used to be an issue with
> the OSGI subsystem involved.
> >What AS version are you using? The problem I am referring to
> should be solved in trunk.
> >But if you a running a previous release, then try commenting out
> the osgi subsystem .
> I'm using Beta3 - no luck :-(
> --
> paulwerder at fastmail.co.uk <mailto:paulwerder at fastmail.co.uk>
> On Wed, 04 May 2011 12:23 +0200, "Heiko Braun" <hbraun at redhat.com
> <mailto:hbraun at redhat.com>> wrote:
>> This is just a vague guess, but there used to be an issue with
>> the OSGI subsystem involved.
>> What AS version are you using? The problem I am referring to
>> should be solved in trunk.
>> But if you a running a previous release, then try commenting out
>> the osgi subsystem .
>> Ike
>>
>> On May 4, 2011, at 12:02 PM, paulwerder at fastmail.co.uk
>> <mailto:paulwerder at fastmail.co.uk> wrote:
>>
>>> 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 ?
>>> regards
>>> Paul
>>> --
>>> paulwerder at fastmail.co.uk <mailto:paulwerder at fastmail.co.uk>
>>> On Wed, 04 May 2011 12:54 +0300, "Nicklas Karlsson"
>>> <nickarls at gmail.com <mailto:nickarls at 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 at fastmail.co.uk
>>>> <mailto:paulwerder at 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 at fastmail.co.uk <mailto:paulwerder at fastmail.co.uk>
>>>>
>>>> --
>>>> http://www.fastmail.fm- IMAP accessible web-mail
>>>>
>>>>
>>>> _______________________________________________
>>>> jboss-as7-dev mailing list
>>>> jboss-as7-dev at lists.jboss.org
>>>> <mailto:jboss-as7-dev at lists.jboss.org>
>>>> https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> ---
>>>> Nik
>>>> _______________________________________________
>>>> jboss-as7-dev mailing list
>>>> jboss-as7-dev at lists.jboss.org <mailto:jboss-as7-dev at 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 at lists.jboss.org <mailto:jboss-as7-dev at lists.jboss.org>
>>> https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
>
> --
> http://www.fastmail.fm - Does exactly what it says on the tin
>
>
> _______________________________________________
> jboss-as7-dev mailing list
> jboss-as7-dev at lists.jboss.org <mailto:jboss-as7-dev at lists.jboss.org>
> https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
>
>
>
>
> --
> ---
> Nik
>
>
> _______________________________________________
> jboss-as7-dev mailing list
> jboss-as7-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-as7-dev/attachments/20110504/1c63cc5c/attachment-0001.html
More information about the jboss-as7-dev
mailing list