[jboss-as7-dev] Oracle datasource missing dependencies

[Nicklas Karlsson]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-as7-dev/attachments/20110504/4a4045be/attachment.html