[jboss-as7-dev] Oracle datasource missing dependencies
Marchioni Francesco
f.marchioni at pride.it
Wed May 4 10:53:22 EDT 2011
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 at 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 at 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 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
>>
>> On Wed, 04 May 2011 12:23 +0200, "Heiko Braun"
<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 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
>>>>
>>>> On Wed, 04 May 2011 12:54 +0300, "Nicklas Karlsson"
<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>
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
>>>>>
>>>>> --
>>>>> http://www.fastmail.fm - IMAP accessible web-mail
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> jboss-as7-dev mailing list
>>>>> 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
>>>>>
>>>>
>>>> --
>>>> http://www.fastmail.fm - mmm... Fastmail...
>>>> _______________________________________________
>>>> jboss-as7-dev mailing list
>>>> 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
>> https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
>>
>>
>>
>>
>> --
>> ---
>> Nik
--------------------------------------------------------------------------------------------------------
Le informazioni trasmesse possono contenere documenti confidenziali e/o materiale riservato; sono
quindi da intendersi esclusivamente ad uso della persona e/o societa a cui sono indirizzate.
Qualsiasi modifica, inoltro, diffusione o altro utilizzo, relativo alle informazioni trasmesse, da parte
di persone e/o societa diversi dai destinatari indicati, e proibito ai sensi della legge 196/2003.
Qualora questa mail fosse stata ricevuta per errore, si prega di contattare il mittente e cancellarne
il contenuto.
--
Privileged/Confidential Information may be contained in this message. If you are not the addressee
indicated in this message (or responsible for delivery of the message to such person), you may not
copy or deliver this message to anyone. In such case, you should destroy this message and kindly
notify the sender by reply email. Please advise immediately if you or your employer does not consent
to Internet email for messages of this kind. Opinions, conclusions and other information in this
message that do not relate to the official business of my firm shall be understood as neither given
nor endorsed by it.
--------------------------------------------------------------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-as7-dev/attachments/20110504/b1f42291/attachment-0001.html
More information about the jboss-as7-dev
mailing list