[jboss-as7-dev] Oracle datasource missing dependencies

paulwerder at fastmail.co.uk paulwerder at fastmail.co.uk
Wed May 4 10:50:43 EDT 2011 

>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.
>And it's the only way we are supporting jdbc as module or
deployment. IOW we are just supporting type 4 >driver.
>Use Oracle 11g driver, I've tested it and it's working.

Hello Stefano, which .jar have you used for testing connectivity
?
I've used ojdbc5.jar but I still get the same error.....
--

[1]paulwerder at fastmail.co.uk

On Wed, 04 May 2011 14:54 +0200, "Stefano Maestri"
<smaestri at redhat.com> wrote:

The problem is the driver itself.
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.
And it's the only way we are supporting jdbc as module or
deployment. IOW we are just supporting type 4 driver.
Use Oracle 11g driver, I've tested it and it's working.
regards
S.
On 05/04/2011 01:14 PM, Nicklas Karlsson 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>

  [9]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
  --
   [10]paulwerder at fastmail.co.uk
  --
  [11]http://www.fastmail.fm - IMAP accessible web-mail
  _______________________________________________
  jboss-as7-dev mailing list
  [12]jboss-as7-dev at lists.jboss.org
  [13]https://lists.jboss.org/mailman/listinfo/jboss-as7-dev

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



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

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

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

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


  --
  ---
  Nik



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

_______________________________________________
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:jdbc:oracle:thin:@192.168.1.1:1530:ORACLESID
  10. mailto:paulwerder at fastmail.co.uk
  11. http://www.fastmail.fm/
  12. mailto:jboss-as7-dev at lists.jboss.org
  13. https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
  14. mailto:jboss-as7-dev at lists.jboss.org
  15. https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
  16. http://www.fastmail.fm/
  17. mailto:jboss-as7-dev at lists.jboss.org
  18. https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
  19. http://www.fastmail.fm/
  20. mailto:jboss-as7-dev at lists.jboss.org
  21. https://lists.jboss.org/mailman/listinfo/jboss-as7-dev
  22. mailto:jboss-as7-dev at lists.jboss.org
  23. https://lists.jboss.org/mailman/listinfo/jboss-as7-dev

-- 
http://www.fastmail.fm - Email service worth paying for. Try it for free

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

More information about the jboss-as7-dev mailing list