7:54 a.m.
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(a)fastmail.co.uk
<mailto:paulwerder@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(a)fastmail.co.uk <mailto:paulwerder@fastmail.co.uk>
On Wed, 04 May 2011 12:23 +0200, "Heiko Braun" <hbraun(a)redhat.com
<mailto:hbraun@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(a)fastmail.co.uk
> <mailto:paulwerder@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(a)fastmail.co.uk <mailto:paulwerder@fastmail.co.uk>
>> On Wed, 04 May 2011 12:54 +0300, "Nicklas Karlsson"
>> <nickarls(a)gmail.com <mailto: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(a)fastmail.co.uk
>>> <mailto: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(a)fastmail.co.uk <mailto:paulwerder@fastmail.co.uk>
>>>
>>> --
>>> http://www.fastmail.fm- IMAP accessible web-mail
>>>
>>>
>>> _______________________________________________
>>> jboss-as7-dev mailing list
>>> jboss-as7-dev(a)lists.jboss.org
>>> <mailto:jboss-as7-dev@lists.jboss.org>
>>> https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
>>>
>>>
>>>
>>>
>>> --
>>> ---
>>> Nik
>>> _______________________________________________
>>> jboss-as7-dev mailing list
>>> jboss-as7-dev(a)lists.jboss.org
<mailto: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(a)lists.jboss.org <mailto:jboss-as7-dev@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(a)lists.jboss.org <mailto:jboss-as7-dev@lists.jboss.org>
https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
--
---
Nik
_______________________________________________
jboss-as7-dev mailing list
jboss-as7-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-as7-dev