
<!--/*SC*/DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"/*EC*/-->

<html><head><title></title><style type="text/css"><!-- body{padding:1ex;margin:0;font-family:sans-serif;font-size:small}a[href]{color:-moz-hyperlinktext!important;text-decoration:-moz-anchor-decoration}blockquote{margin:0;border-left:2px solid #144fae;padding-left:1em}blockquote blockquote{border-color:#006312}blockquote blockquote blockquote{border-color:#540000} --></style></head><body><div style="font-family: Arial; font-size: medium;" dir="ltr"><div>

        <div>

                Hello,</div>

        <div>

                &gt;do you have a&nbsp;</div>

        <div>

                &nbsp;</div>

        <div>

                &nbsp;&nbsp; &gt; &nbsp; &nbsp; &nbsp; &nbsp; &lt;drivers&gt;</div>

        <div>

                &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;driver module=&quot;oracle.jdbc&quot;/&gt;</div>

        <div>

                &nbsp;&nbsp; &gt;&nbsp; &nbsp; &nbsp; &lt;/drivers&gt;</div>

        <div>

                &nbsp;</div>

        <div>

                &gt;in your configuration at datasources subsystem?</div>

        <div>

                &nbsp;</div>

        <div>

                yes I have inserted it, exaclty as you typed it. (sorry I forgot to mention it before.)</div>

        <div>

                &nbsp;</div>

        <div>

                might it be a specific issue with this JDBC driver ?</div>

        <div>

                regards</div>

        <div>

                Paul</div>

</div>

<div>

        --</div>

<div>

        &nbsp;</div>

<div>

        <a href="mailto:paulwerder@fastmail.co.uk">paulwerder@fastmail.co.uk</a></div>

<div>

        &nbsp;</div>

<div class="defangedMessage">

        <div id="me06274">

                <div>

                        On Wed, 04 May 2011 12:54 +0300, &quot;Nicklas Karlsson&quot; &lt;nickarls@gmail.com&gt; wrote:</div>

                <blockquote class="me06274QuoteMessage" type="cite">

                        <div>

                                do you have a&nbsp;</div>

                        <div>

                                &nbsp;</div>

                        <div>

                                &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;drivers&gt;</div>

                        <div>

                                &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;driver module=&quot;oracle.jdbc&quot;/&gt;</div>

                        <div>

                                &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/drivers&gt;</div>

                        <div>

                                &nbsp;</div>

                        <div>

                                in your configuration at datasources subsystem?</div>

                        <br />

                        <div class="me06274gmail_quote">

                                On Wed, May 4, 2011 at 11:39 AM, <span dir="ltr">&lt;<a href="mailto:paulwerder@fastmail.co.uk">paulwerder@fastmail.co.uk</a>&gt;</span> wrote:<br />

                                <blockquote class="me06274gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">

                                        Hi JBoss devs,<br />

                                        I&#39;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 />

                                        &nbsp;report<br />

                                        &nbsp; New missing/unsatisfied dependencies:<br />

                                        &nbsp; &nbsp; &nbsp;service jboss.jdbc-driver.&quot;oracle.jdbc.driver.OracleDriver&quot;.10.2<br />

                                        &nbsp; &nbsp; &nbsp;(missing)<br />

                                        <br />

                                        And my configuration:<br />

                                        <br />

                                        &lt;datasource jndi-name=&quot;java:/OracleDS&quot; pool-name=&quot;OracleDS&quot;<br />

                                        enabled=&quot;true&quot; use-java-context=&quot;true&quot;&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;connection-url&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;jdbc:oracle:thin:@192.168.1.1:1530:ORACLESID<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;/connection-url&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;driver-class&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;oracle.jdbc.driver.OracleDriver<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;/driver-class&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;driver&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;oracle.jdbc.driver.OracleDriver#10.2<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;/driver&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;pool&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;prefill&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;true<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;/prefill&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;use-strict-min&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;false<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;/use-strict-min&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;/pool&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;security&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;user-name&gt;test&lt;/user-name&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;password&gt;test&lt;/password&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;/security&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;validation&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;validate-on-match&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;false<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;/validate-on-match&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;background-validation&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;false<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;/background-validation&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;useFastFail&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;false<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;/useFastFail&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;/validation&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;statement/&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;/datasource&gt;<br />

                                        <br />

                                        I&#39;ve chosen to install the JDBC driver as a module, so under the<br />

                                        &quot;modules&quot; folder I&#39;ve added:<br />

                                        oracle<br />

                                        └───jdbc<br />

                                        &nbsp; &nbsp;└───main<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;module.xml<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ojdbc14.jar<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ojdbc14.jar.index<br />

                                        <br />

                                        Last thing, the module.xml:<br />

                                        <br />

                                        &lt;module xmlns=&quot;urn:jboss:module:1.0&quot; name=&quot;oracle.jdbc&quot;&gt;<br />

                                        &nbsp;&lt;resources&gt;<br />

                                        &nbsp; &nbsp;&lt;resource-root path=&quot;ojdbc14.jar&quot;/&gt;<br />

                                        &nbsp; &nbsp; &nbsp; &nbsp;&lt;!-- Insert resources here --&gt;<br />

                                        &nbsp;&lt;/resources&gt;<br />

                                        &nbsp;&lt;dependencies&gt;<br />

                                        &nbsp; &nbsp;&lt;module name=&quot;javax.api&quot;/&gt;<br />

                                        &nbsp;&lt;/dependencies&gt;<br />

                                        &lt;/module&gt;<br />

                                        <br />

                                        Can you find any reason why the driver does not get deployed ?<br />

                                        (I&#39;ve tried also adding META-INF/services/java.sql.Driver with the<br />

                                        driver class name- it didn&#39;t help however).<br />

                                        Thanks a lot<br />

                                        Paul<br />

                                        --<br />

                                        <br />

                                        &nbsp;<a href="mailto:paulwerder@fastmail.co.uk">paulwerder@fastmail.co.uk</a><br />

                                        <br />

                                        <span style="color: rgb(136, 136, 136);"> --<br />

                                        <a href="http://www.fastmail.fm" target="_blank">http://www.fastmail.fm</a> - IMAP accessible web-mail<br />

                                        <br />

                                        <br />

                                        _______________________________________________<br />

                                        jboss-as7-dev mailing list<br />

                                        <a href="mailto:jboss-as7-dev@lists.jboss.org">jboss-as7-dev@lists.jboss.org</a><br />

                                        <a href="https://lists.jboss.org/mailman/listinfo/jboss-as7-dev" target="_blank">https://lists.jboss.org/mailman/listinfo/jboss-as7-dev</a><br />

                                        </span></blockquote>

                        </div>

                        <br />

                        <br clear="all" />

                        <br />

                        --<br />

                        ---<br />

                        Nik<br />

                        <pre>

_______________________________________________

jboss-as7-dev mailing list

jboss-as7-dev@lists.jboss.org

https://lists.jboss.org/mailman/listinfo/jboss-as7-dev


</pre>

                </blockquote>

        </div>

</div>

<div>

        &nbsp;</div>

</div><pre>

-- 

http://www.fastmail.fm - mmm... Fastmail...

</pre>

</body></html>