Re: [jboss-as7-dev] Oracle datasource missing dependencies

>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(a)pride.it On Wed, 04 May 2011 16:53 +0200, "Marchioni Francesco" <f.marchioni(a)pride.it&gt; 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..... > > >-- > > > > &gt;paulwerder(a)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(a)redhat.com&gt; 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(a)fastmail.co.uk&gt; 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 > > >> > > >> On Wed, 04 May 2011 12:23 +0200, "Heiko Braun" <hbraun(a)redhat.com&gt; 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 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 > > >>>> > > >>>> On Wed, 04 May 2011 12:54 +0300, "Nicklas Karlsson" <nickarls(a)gmail.com&gt; 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&gt; 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 > > >>>>> > > >>>>> -- > > >>>>> http://www.fastmail.fm - IMAP accessible web-mail > > >>>>> > > >>>>> > > >>>>> _______________________________________________ > > >>>>> jboss-as7-dev mailing list > > >>>>> jboss-as7-dev(a)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 > > >>>>> > > >>>> > > >>>> -- > > >>>> http://www.fastmail.fm - mmm... Fastmail... > > >>>> _______________________________________________ > > >>>> jboss-as7-dev mailing list > > >>>> jboss-as7-dev(a)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 > > >> 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(a)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(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-as7-dev