[jboss-as7-dev] Oracle datasource missing dependencies

[paulwerder at fastmail.co.uk]

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
--

[1]paulwerder at fastmail.co.uk

On Wed, 04 May 2011 12:54 +0300, "Nicklas Karlsson"
<nickarls at 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, <[2]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
  --
   [3]paulwerder at fastmail.co.uk
  --
  [4]http://www.fastmail.fm - IMAP accessible web-mail
  _______________________________________________
  jboss-as7-dev mailing list
  [5]jboss-as7-dev at lists.jboss.org
  [6]https://lists.jboss.org/mailman/listinfo/jboss-as7-dev

  --
  ---
  Nik
_______________________________________________
jboss-as7-dev mailing list
jboss-as7-dev at lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-as7-dev

References

1. mailto:paulwerder at fastmail.co.uk
2. mailto:paulwerder at fastmail.co.uk
3. mailto:paulwerder at fastmail.co.uk
4. http://www.fastmail.fm/
5. mailto:jboss-as7-dev at lists.jboss.org
6. https://lists.jboss.org/mailman/listinfo/jboss-as7-dev

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-as7-dev/attachments/20110504/5421b3ac/attachment-0001.html