Hi Paul,
Watch out, there’s an error in your driver class name- when using ojdbc5.jar the driver name is oracle.jdbc.OracleDriver and NOT oracle.jdbc.driver.OracleDriver.
Manifest-Version: 1.0
Ant-Version: Apache Ant 1.6.5
Created-By: 1.5.0_24-rev-b08 (Sun Microsystems Inc.)
Implementation-Vendor: Oracle Corporation
Implementation-Title: JDBC
Implementation-Version: 11.2.0.2.0
Repository-Id: JAVAVM_11.2.0.2.0_LINUX_100812.1
Specification-Vendor: Sun Microsystems Inc.
Specification-Title: JDBC
Specification-Version: 4.0
Main-Class: oracle.jdbc.OracleDriver η=========driver
I got it working with ojdbc5.jar.
Hope it helps,
regards
Francesco Marchioni
>Hello Stefano, which .jar have you used for testing connectivity ?
>I've used ojdbc5.jar but I still get the same error.....
>--
>paulwerder@fastmail.co.uk
>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.
On Wed, 04 May 2011 14:54 +0200, "Stefano Maestri" <smaestri@redhat.com> wrote:
> 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@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@fastmail.co.uk
>>
>> On Wed, 04 May 2011 12:23 +0200, "Heiko Braun" <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@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@fastmail.co.uk
>>>>
>>>> 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
>> --
>> http://www.fastmail.fm - Does exactly what it says on the tin
>>
>>
>> _______________________________________________
>> jboss-as7-dev mailing list
>> jboss-as7-dev@lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
>>
>>
>>
>>
>> --
>> ---
>> Nik