<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
The problem is the driver itself. <br>
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.<br>
And it's the only way we are supporting jdbc as module or
deployment. IOW we are just supporting type 4 driver.<br>
<br>
Use Oracle 11g driver, I've tested it and it's working.<br>
<br>
regards<br>
S.<br>
<br>
<br>
On 05/04/2011 01:14 PM, Nicklas Karlsson wrote:
<blockquote
cite="mid:BANLkTimDkjXqnqG=_4weAM_v9R8bmJp_uw@mail.gmail.com"
type="cite">And the version number is correct for the driver?<br>
<br>
<div class="gmail_quote">On Wed, May 4, 2011 at 1:40 PM, <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:paulwerder@fastmail.co.uk">paulwerder@fastmail.co.uk</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">
<div>
<div style="font-family: Arial; font-size: medium;"
dir="ltr">
<div>
<div> Hello Ike,</div>
<div class="im">
<div> >This is just a vague guess, but there used
to be an issue with the OSGI subsystem involved.</div>
<div> >What AS version are you using? The problem I
am referring to should be solved in trunk.</div>
<div> >But if you a running a previous release,
then try commenting out the osgi subsystem .</div>
<div> </div>
</div>
<div> I'm using Beta3 - no luck :-(</div>
<div> </div>
</div>
<div> --</div>
<div> </div>
<div> <a moz-do-not-send="true"
href="mailto:paulwerder@fastmail.co.uk"
target="_blank">paulwerder@fastmail.co.uk</a></div>
<div>
<div class="h5">
<div> </div>
<div>
<div>
<div> On Wed, 04 May 2011 12:23 +0200, "Heiko
Braun" <<a moz-do-not-send="true"
href="mailto:hbraun@redhat.com"
target="_blank">hbraun@redhat.com</a>>
wrote:</div>
<blockquote type="cite"> </blockquote>
</div>
</div>
<div>
<div>
<blockquote type="cite">
<div dir="ltr" style="word-wrap: break-word;">
<div> </div>
<div> </div>
<div> </div>
<div> This is just a vague guess, but there
used to be an issue with the OSGI subsystem
involved.</div>
<div> What AS version are you using? The
problem I am referring to should be solved
in trunk.</div>
<div> But if you a running a previous release,
then try commenting out the osgi subsystem .</div>
<div> </div>
<div> Ike</div>
<br>
<div>
<div> On May 4, 2011, at 12:02 PM, <a
moz-do-not-send="true"
href="mailto:paulwerder@fastmail.co.uk"
target="_blank">paulwerder@fastmail.co.uk</a>
wrote:</div>
<br>
<blockquote type="cite">
<div style="padding: 1ex; margin: 0px;
font-family: sans-serif; font-size:
small;">
<div dir="ltr" style="font-family:
Arial; font-size: medium;">
<div>
<div> <span style="border-collapse:
separate; font-family:
Helvetica; font-style: normal;
font-variant: normal;
font-weight: normal;
letter-spacing: normal;
line-height: normal;
text-indent: 0px;
text-transform: none;
white-space: normal;
word-spacing: 0px; font-size:
medium;">Hello,</span></div>
<div> <span style="border-collapse:
separate; font-family:
Helvetica; font-style: normal;
font-variant: normal;
font-weight: normal;
letter-spacing: normal;
line-height: normal;
text-indent: 0px;
text-transform: none;
white-space: normal;
word-spacing: 0px; font-size:
medium;">>do you have a </span></div>
<div> <span style="border-collapse:
separate; font-family:
Helvetica; font-style: normal;
font-variant: normal;
font-weight: normal;
letter-spacing: normal;
line-height: normal;
text-indent: 0px;
text-transform: none;
white-space: normal;
word-spacing: 0px; font-size:
medium;"> </span></div>
<div> <span style="border-collapse:
separate; font-family:
Helvetica; font-style: normal;
font-variant: normal;
font-weight: normal;
letter-spacing: normal;
line-height: normal;
text-indent: 0px;
text-transform: none;
white-space: normal;
word-spacing: 0px; font-size:
medium;"> >
<drivers></span></div>
<div> <span style="border-collapse:
separate; font-family:
Helvetica; font-style: normal;
font-variant: normal;
font-weight: normal;
letter-spacing: normal;
line-height: normal;
text-indent: 0px;
text-transform: none;
white-space: normal;
word-spacing: 0px; font-size:
medium;">
<driver
module="oracle.jdbc"/></span></div>
<div> <span style="border-collapse:
separate; font-family:
Helvetica; font-style: normal;
font-variant: normal;
font-weight: normal;
letter-spacing: normal;
line-height: normal;
text-indent: 0px;
text-transform: none;
white-space: normal;
word-spacing: 0px; font-size:
medium;"> >
</drivers></span></div>
<div> <span style="border-collapse:
separate; font-family:
Helvetica; font-style: normal;
font-variant: normal;
font-weight: normal;
letter-spacing: normal;
line-height: normal;
text-indent: 0px;
text-transform: none;
white-space: normal;
word-spacing: 0px; font-size:
medium;"> </span></div>
<div> <span style="border-collapse:
separate; font-family:
Helvetica; font-style: normal;
font-variant: normal;
font-weight: normal;
letter-spacing: normal;
line-height: normal;
text-indent: 0px;
text-transform: none;
white-space: normal;
word-spacing: 0px; font-size:
medium;">>in your
configuration at datasources
subsystem?</span></div>
<div> <span style="border-collapse:
separate; font-family:
Helvetica; font-style: normal;
font-variant: normal;
font-weight: normal;
letter-spacing: normal;
line-height: normal;
text-indent: 0px;
text-transform: none;
white-space: normal;
word-spacing: 0px; font-size:
medium;"> </span></div>
<div> <span style="border-collapse:
separate; font-family:
Helvetica; font-style: normal;
font-variant: normal;
font-weight: normal;
letter-spacing: normal;
line-height: normal;
text-indent: 0px;
text-transform: none;
white-space: normal;
word-spacing: 0px; font-size:
medium;">yes I have inserted it,
exaclty as you typed it. (sorry
I forgot to mention it before.)</span></div>
<div> <span style="border-collapse:
separate; font-family:
Helvetica; font-style: normal;
font-variant: normal;
font-weight: normal;
letter-spacing: normal;
line-height: normal;
text-indent: 0px;
text-transform: none;
white-space: normal;
word-spacing: 0px; font-size:
medium;"> </span></div>
<div> <span style="border-collapse:
separate; font-family:
Helvetica; font-style: normal;
font-variant: normal;
font-weight: normal;
letter-spacing: normal;
line-height: normal;
text-indent: 0px;
text-transform: none;
white-space: normal;
word-spacing: 0px; font-size:
medium;">might it be a specific
issue with this JDBC driver ?</span></div>
<div> <span style="border-collapse:
separate; font-family:
Helvetica; font-style: normal;
font-variant: normal;
font-weight: normal;
letter-spacing: normal;
line-height: normal;
text-indent: 0px;
text-transform: none;
white-space: normal;
word-spacing: 0px; font-size:
medium;">regards</span></div>
<div> <span style="border-collapse:
separate; font-family:
Helvetica; font-style: normal;
font-variant: normal;
font-weight: normal;
letter-spacing: normal;
line-height: normal;
text-indent: 0px;
text-transform: none;
white-space: normal;
word-spacing: 0px; font-size:
medium;">Paul</span></div>
</div>
<div> <span style="border-collapse:
separate; font-family: Helvetica;
font-style: normal; font-variant:
normal; font-weight: normal;
letter-spacing: normal;
line-height: normal; text-indent:
0px; text-transform: none;
white-space: normal; word-spacing:
0px; font-size: medium;">--</span></div>
<div> <span style="border-collapse:
separate; font-family: Helvetica;
font-style: normal; font-variant:
normal; font-weight: normal;
letter-spacing: normal;
line-height: normal; text-indent:
0px; text-transform: none;
white-space: normal; word-spacing:
0px; font-size: medium;"> </span></div>
<div> <span style="border-collapse:
separate; font-family: Helvetica;
font-style: normal; font-variant:
normal; font-weight: normal;
letter-spacing: normal;
line-height: normal; text-indent:
0px; text-transform: none;
white-space: normal; word-spacing:
0px; font-size: medium;"><a
moz-do-not-send="true"
href="mailto:paulwerder@fastmail.co.uk"
target="_blank">paulwerder@fastmail.co.uk</a></span></div>
<div> <span style="border-collapse:
separate; font-family: Helvetica;
font-style: normal; font-variant:
normal; font-weight: normal;
letter-spacing: normal;
line-height: normal; text-indent:
0px; text-transform: none;
white-space: normal; word-spacing:
0px; font-size: medium;"> </span></div>
<div>
<div>
<div> <span
style="border-collapse:
separate; font-family:
Helvetica; font-style: normal;
font-variant: normal;
font-weight: normal;
letter-spacing: normal;
line-height: normal;
text-indent: 0px;
text-transform: none;
white-space: normal;
word-spacing: 0px; font-size:
medium;">On Wed, 04 May 2011
12:54 +0300, "Nicklas
Karlsson" <<a
moz-do-not-send="true"
href="mailto:nickarls@gmail.com"
target="_blank">nickarls@gmail.com</a>>
wrote:</span></div>
<blockquote style="margin: 0px;
border-left: 2px solid rgb(20,
79, 174); padding-left: 1em;"
type="cite">
<div> <span
style="border-collapse:
separate; font-family:
Helvetica; font-style:
normal; font-variant:
normal; font-weight: normal;
letter-spacing: normal;
line-height: normal;
text-indent: 0px;
text-transform: none;
white-space: normal;
word-spacing: 0px;
font-size: medium;">do you
have a </span></div>
<div> <span
style="border-collapse:
separate; font-family:
Helvetica; font-style:
normal; font-variant:
normal; font-weight: normal;
letter-spacing: normal;
line-height: normal;
text-indent: 0px;
text-transform: none;
white-space: normal;
word-spacing: 0px;
font-size: medium;"> </span></div>
<div> <span
style="border-collapse:
separate; font-family:
Helvetica; font-style:
normal; font-variant:
normal; font-weight: normal;
letter-spacing: normal;
line-height: normal;
text-indent: 0px;
text-transform: none;
white-space: normal;
word-spacing: 0px;
font-size: medium;">
<drivers></span></div>
<div> <span
style="border-collapse:
separate; font-family:
Helvetica; font-style:
normal; font-variant:
normal; font-weight: normal;
letter-spacing: normal;
line-height: normal;
text-indent: 0px;
text-transform: none;
white-space: normal;
word-spacing: 0px;
font-size: medium;">
<driver
module="oracle.jdbc"/></span></div>
<div> <span
style="border-collapse:
separate; font-family:
Helvetica; font-style:
normal; font-variant:
normal; font-weight: normal;
letter-spacing: normal;
line-height: normal;
text-indent: 0px;
text-transform: none;
white-space: normal;
word-spacing: 0px;
font-size: medium;">
</drivers></span></div>
<div> <span
style="border-collapse:
separate; font-family:
Helvetica; font-style:
normal; font-variant:
normal; font-weight: normal;
letter-spacing: normal;
line-height: normal;
text-indent: 0px;
text-transform: none;
white-space: normal;
word-spacing: 0px;
font-size: medium;"> </span></div>
<div> <span
style="border-collapse:
separate; font-family:
Helvetica; font-style:
normal; font-variant:
normal; font-weight: normal;
letter-spacing: normal;
line-height: normal;
text-indent: 0px;
text-transform: none;
white-space: normal;
word-spacing: 0px;
font-size: medium;">in your
configuration at datasources
subsystem?</span></div>
<br>
<div> <span
style="border-collapse:
separate; font-family:
Helvetica; font-style:
normal; font-variant:
normal; font-weight: normal;
letter-spacing: normal;
line-height: normal;
text-indent: 0px;
text-transform: none;
white-space: normal;
word-spacing: 0px;
font-size: medium;">On Wed,
May 4, 2011 at 11:39 AM,<span> </span><span
dir="ltr"><<a
moz-do-not-send="true"
href="mailto:paulwerder@fastmail.co.uk"
target="_blank">paulwerder@fastmail.co.uk</a>></span><span> </span>wrote:</span><br>
<blockquote style="margin: 0pt
0pt 0pt 0.8ex; border-left:
1px solid rgb(204, 204,
204); padding-left: 1ex;"> <span
style="border-collapse:
separate; font-family:
Helvetica; font-style:
normal; font-variant:
normal; font-weight:
normal; letter-spacing:
normal; line-height:
normal; text-indent: 0px;
text-transform: none;
white-space: normal;
word-spacing: 0px;
font-size: medium;">Hi
JBoss devs,<br>
I'm testing Oracle
connectivity using a 10.2
JDBC Driver (ojdbc14.jar).<br>
Seems there are some
issues- has anyone managed
to connect to an Oracle<br>
DB ?<br>
This is what the server
reports:<br>
<br>
report<br>
New missing/unsatisfied
dependencies:<br>
service
jboss.jdbc-driver."oracle.jdbc.driver.OracleDriver".10.2<br>
(missing)<br>
<br>
And my configuration:<br>
<br>
<datasource
jndi-name="java:/OracleDS"
pool-name="OracleDS"<br>
enabled="true"
use-java-context="true"><br>
<connection-url><br>
<a class="moz-txt-link-abbreviated" href="mailto:jdbc:oracle:thin:@192.168.1.1:1530:ORACLESID">jdbc:oracle:thin:@192.168.1.1:1530:ORACLESID</a><br>
</connection-url><br>
<driver-class><br>
oracle.jdbc.driver.OracleDriver<br>
</driver-class><br>
<driver><br>
oracle.jdbc.driver.OracleDriver#10.2<br>
</driver><br>
<pool><br>
<prefill><br>
true<br>
</prefill><br>
<use-strict-min><br>
false<br>
</use-strict-min><br>
</pool><br>
<security><br>
<user-name>test</user-name><br>
<password>test</password><br>
</security><br>
<validation><br>
<validate-on-match><br>
false<br>
</validate-on-match><br>
<background-validation><br>
false<br>
</background-validation><br>
<useFastFail><br>
false<br>
</useFastFail><br>
</validation><br>
<statement/><br>
</datasource><br>
<br>
I've chosen to install the
JDBC driver as a module,
so under the<br>
"modules" folder I've
added:<br>
oracle<br>
└───jdbc<br>
└───main<br>
module.xml<br>
ojdbc14.jar<br>
ojdbc14.jar.index<br>
<br>
Last thing, the
module.xml:<br>
<br>
<module
xmlns="urn:jboss:module:1.0"
name="oracle.jdbc"><br>
<resources><br>
<resource-root
path="ojdbc14.jar"/><br>
<!-- Insert
resources here --><br>
</resources><br>
<dependencies><br>
<module
name="javax.api"/><br>
</dependencies><br>
</module><br>
<br>
Can you find any reason
why the driver does not
get deployed ?<br>
(I've tried also adding
META-INF/services/java.sql.Driver
with the<br>
driver class name- it
didn't help however).<br>
Thanks a lot<br>
Paul<br>
--<br>
<br>
<a moz-do-not-send="true"
href="mailto:paulwerder@fastmail.co.uk" target="_blank">paulwerder@fastmail.co.uk</a><br>
<br>
<span style="color:
rgb(136, 136, 136);">--<br>
<a
moz-do-not-send="true"
href="http://www.fastmail.fm" target="_blank">http://www.fastmail.fm</a><span> </span>-
IMAP accessible web-mail<br>
<br>
<br>
_______________________________________________<br>
jboss-as7-dev mailing
list<br>
<a
moz-do-not-send="true"
href="mailto:jboss-as7-dev@lists.jboss.org" target="_blank">jboss-as7-dev@lists.jboss.org</a><br>
<a
moz-do-not-send="true"
href="https://lists.jboss.org/mailman/listinfo/jboss-as7-dev"
target="_blank">https://lists.jboss.org/mailman/listinfo/jboss-as7-dev</a></span></span></blockquote>
</div>
<br>
<br clear="all">
<br>
<span style="border-collapse:
separate; font-family:
Helvetica; font-style: normal;
font-variant: normal;
font-weight: normal;
letter-spacing: normal;
line-height: normal;
text-indent: 0px;
text-transform: none;
white-space: normal;
word-spacing: 0px; font-size:
medium;">--<br>
---<br>
Nik</span><br>
<pre><span style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; font-size: medium;">_______________________________________________
jboss-as7-dev mailing list
<a moz-do-not-send="true" href="mailto:jboss-as7-dev@lists.jboss.org" target="_blank">jboss-as7-dev@lists.jboss.org</a>
<a moz-do-not-send="true" href="https://lists.jboss.org/mailman/listinfo/jboss-as7-dev" target="_blank">https://lists.jboss.org/mailman/listinfo/jboss-as7-dev</a>
</span></pre>
</blockquote>
</div>
</div>
<div> <span style="border-collapse:
separate; font-family: Helvetica;
font-style: normal; font-variant:
normal; font-weight: normal;
letter-spacing: normal;
line-height: normal; text-indent:
0px; text-transform: none;
white-space: normal; word-spacing:
0px; font-size: medium;"> </span></div>
</div>
<pre><span style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; font-size: medium;">--
<a moz-do-not-send="true" href="http://www.fastmail.fm" target="_blank">http://www.fastmail.fm</a> - mmm... Fastmail...
</span></pre>
<span style="border-collapse: separate;
font-family: Helvetica; font-style:
normal; font-variant: normal;
font-weight: normal; letter-spacing:
normal; line-height: normal;
text-indent: 0px; text-transform:
none; white-space: normal;
word-spacing: 0px; font-size: medium;">_______________________________________________<br>
jboss-as7-dev mailing list<br>
<a moz-do-not-send="true"
href="mailto:jboss-as7-dev@lists.jboss.org"
target="_blank">jboss-as7-dev@lists.jboss.org</a><br>
<a moz-do-not-send="true"
href="https://lists.jboss.org/mailman/listinfo/jboss-as7-dev"
target="_blank">https://lists.jboss.org/mailman/listinfo/jboss-as7-dev</a></span></div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
<font color="#888888">
<pre>--
<a moz-do-not-send="true" href="http://www.fastmail.fm" target="_blank">http://www.fastmail.fm</a> - Does exactly what it says on the tin
</pre>
</font></div>
<br>
_______________________________________________<br>
jboss-as7-dev mailing list<br>
<a moz-do-not-send="true"
href="mailto:jboss-as7-dev@lists.jboss.org">jboss-as7-dev@lists.jboss.org</a><br>
<a moz-do-not-send="true"
href="https://lists.jboss.org/mailman/listinfo/jboss-as7-dev"
target="_blank">https://lists.jboss.org/mailman/listinfo/jboss-as7-dev</a><br>
<br>
</blockquote>
</div>
<br>
<br clear="all">
<br>
-- <br>
---<br>
Nik<br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
jboss-as7-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:jboss-as7-dev@lists.jboss.org">jboss-as7-dev@lists.jboss.org</a>
<a class="moz-txt-link-freetext" href="https://lists.jboss.org/mailman/listinfo/jboss-as7-dev">https://lists.jboss.org/mailman/listinfo/jboss-as7-dev</a>
</pre>
</blockquote>
<br>
</body>
</html>