[jboss-as7-dev] Oracle datasource missing dependencies
Jim Tyrrell
jtyrrell at redhat.com
Mon May 9 16:36:18 EDT 2011
Looking at this thread, I am confused/concerned that this should have resulted in a ClassNotFoundException, yet that was caught and "buried" in our own exception handling, is my take on this correct? If so can this be fixed?
Now maybe there is not enough info in the cut and paste:
report
New missing/unsatisfied dependencies:
service jboss.jdbc-driver."oracle.jdbc.driver.OracleDriver".10.2
(missing)
But I would think the CFNE was captured and "swallowed", and I thinking that is not a good thing.
Thoughts?
Jim Tyrrell
Senior JBoss Solutions Architect
Did you see RHT on CNBC's Mad Money?
http://www.cnbc.com/id/39401056
On May 4, 2011, at 9:03 AM, paulwerder at fastmail.co.uk wrote:
> >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!
>
> --
>
> 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
>>
>
>
> --
> http://www.fastmail.fm - One of many happy users:
> http://www.fastmail.fm/docs/quotes.html
> _______________________________________________
> 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/20110509/8f3f4ee6/attachment-0001.html
More information about the jboss-as7-dev
mailing list