[jboss-as7-dev] Oracle datasource missing dependencies

paulwerder at fastmail.co.uk paulwerder at fastmail.co.uk
Wed May 4 09:02:29 EDT 2011


>And the version number is correct for the driver?
It should be...in the META-INF folder of the driver I've found:

Specification-Version:  Oracle JDBC Driver version - "10.2.0.4.0"
Implementation-Version: Oracle JDBC Driver version - "10.2.0.4.0"

I haven't tried with a 11.x driver yet...............
--

[1]paulwerder at fastmail.co.uk

On Wed, 04 May 2011 14:14 +0300, "Nicklas Karlsson"
<nickarls at gmail.com> wrote:

  And the version number is correct for the driver?

On Wed, May 4, 2011 at 1:40 PM, <[2]paulwerder at 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 :-(

--

[3]paulwerder at fastmail.co.uk


On Wed, 04 May 2011 12:23 +0200, "Heiko Braun"
<[4]hbraun at 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, [5]paulwerder at 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
--

[6]paulwerder at fastmail.co.uk

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

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



--
[15]http://www.fastmail.fm - mmm... Fastmail...

_______________________________________________
jboss-as7-dev mailing list
[16]jboss-as7-dev at lists.jboss.org
[17]https://lists.jboss.org/mailman/listinfo/jboss-as7-dev

--
[18]http://www.fastmail.fm - Does exactly what it says on the tin

  _______________________________________________
  jboss-as7-dev mailing list
  [19]jboss-as7-dev at lists.jboss.org
  [20]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. mailto:hbraun at redhat.com
5. mailto:paulwerder at fastmail.co.uk
6. mailto:paulwerder at fastmail.co.uk
7. mailto:nickarls at gmail.com
8. mailto:paulwerder at fastmail.co.uk
9. mailto:paulwerder at fastmail.co.uk
  10. http://www.fastmail.fm/
  11. mailto:jboss-as7-dev at lists.jboss.org
  12. https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
  13. mailto:jboss-as7-dev at lists.jboss.org
  14. https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
  15. http://www.fastmail.fm/
  16. mailto:jboss-as7-dev at lists.jboss.org
  17. https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
  18. http://www.fastmail.fm/
  19. mailto:jboss-as7-dev at lists.jboss.org
  20. https://lists.jboss.org/mailman/listinfo/jboss-as7-dev

-- 
http://www.fastmail.fm - IMAP accessible web-mail

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


More information about the jboss-as7-dev mailing list