[jboss-as7-dev] Oracle datasource missing dependencies
paulwerder at fastmail.co.uk
paulwerder at fastmail.co.uk
Wed May 4 11:03:19 EDT 2011
>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
Thanks, that's amazing, it works now! Sorry for my stupid
mistake!
--
[1]f.marchioni at pride.it
On Wed, 04 May 2011 16:53 +0200, "Marchioni Francesco"
<f.marchioni at pride.it> wrote:
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.
--------------------------------------------------------------
------------------------------------------
_______________________________________________
jboss-as7-dev mailing list
jboss-as7-dev at lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
References
1. mailto:f.marchioni at pride.it
--
http://www.fastmail.fm - One of many happy users:
http://www.fastmail.fm/docs/quotes.html
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-as7-dev/attachments/20110504/3dff8a5f/attachment-0001.html
More information about the jboss-as7-dev
mailing list