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(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>
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>
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> 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> 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>
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
>>>>
>>>>
>>>>
>>>>
>>>
> --
>>>> ---
>>>> Nik
>>>> _______________________________________________
>>>> jboss-as7-dev mailing list
>>>> jboss-as7-dev(a)lists.jboss.org
>>>>
>>>
>>> --
>>>
http://www.fastmail.fm - mmm... Fastmail...
>>> _______________________________________________
>>> jboss-as7-dev mailing list
>>> jboss-as7-dev(a)lists.jboss.org
> --
>
http://www.fastmail.fm - Does exactly what it says on the tin
>
>
> _______________________________________________
> jboss-as7-dev mailing list
> jboss-as7-dev(a)lists.jboss.org
>
>
>
>
> --
> ---
> 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.
--------------------------------------------------------------------------------------------------------