You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@karaf.apache.org by "Panos Kavalagios (JIRA)" <ji...@apache.org> on 2017/04/19 15:19:41 UTC

[jira] [Created] (KARAF-5098) Oracle pool datasources are missing in Karaf 4.0.9

Panos Kavalagios created KARAF-5098:
---------------------------------------

             Summary: Oracle pool datasources are missing in Karaf 4.0.9
                 Key: KARAF-5098
                 URL: https://issues.apache.org/jira/browse/KARAF-5098
             Project: Karaf
          Issue Type: Bug
          Components: karaf-jdbc
    Affects Versions: 4.0.9
            Reporter: Panos Kavalagios
            Priority: Blocker


The Oracle pool drivers are no longer available in the latest 4.0.9 release. It worked fine up to version 4.0.8. It now provides only the "oracle" driver and not the "oracle-pool" and "oracle-pool-xa". The issue is probably related to KARAF-5068 that upgraded PAX JDBC to 1.0.1. It works fine in 0.9.0.

I have managed to reveal the required drivers by manually installing PAX JDBC version 0.9.0 in Karaf 4.0.9:

{code:none}
karaf@root()> version
4.0.9
karaf@root()> list | grep -i jdbc
 55 | Active |  80 | 1.1.0               | OPS4J Pax JDBC Generic Driver Extender
 58 | Active |  80 | 1.0.0.201505202023  | org.osgi:org.osgi.service.jdbc
 92 | Active |  80 | 4.0.9               | Apache Karaf :: JDBC :: Core
142 | Active |  80 | 1.1.0               | OPS4J Pax JDBC Oracle Driver Adapter
152 | Active |  90 | 0                   | wrap_file__home_panos_.m2_repository_com_oracle_ojdbc7_12.1.0.2.0_ojdbc7-12.1.0.2.0.jar
271 | Active |  80 | 0.9.0               | OPS4J Pax JDBC Pooling Support using Commons-DBCP2
272 | Active |  80 | 0.9.0               | OPS4J Pax JDBC Config
273 | Active |  80 | 0.9.0               | OPS4J Pax JDBC Pooling Support Base
karaf@root()> jdbc:ds-factories 
Name                                                                                            | Class                            | Version
--------------------------------------------------------------------------------------------------------------------------------------------
oracle                                                                                          | oracle.jdbc.OracleDriver         |
oracle-pool-xa                                                                                  | oracle.jdbc.OracleDriver-pool-xa |
oracle-pool                                                                                     | oracle.jdbc.OracleDriver-pool    |
wrap_file__home_panos_.m2_repository_com_oracle_ojdbc7_12.1.0.2.0_ojdbc7-12.1.0.2.0.jar-pool    | oracle.jdbc.OracleDriver-pool    | 0.0.0
wrap_file__home_panos_.m2_repository_com_oracle_ojdbc7_12.1.0.2.0_ojdbc7-12.1.0.2.0.jar-pool-xa | oracle.jdbc.OracleDriver-pool-xa | 0.0.0
wrap_file__home_panos_.m2_repository_com_oracle_ojdbc7_12.1.0.2.0_ojdbc7-12.1.0.2.0.jar         | oracle.jdbc.OracleDriver         | 0.0.0
{code}

Otherwise, the default 4.0.9 installation that includes version 1.0.1 gives the following output:

{code:none}
karaf@root()> version
4.0.9
karaf@root()> list | grep -i jdbc
 55 | Active      |  80 | 1.0.1               | OPS4J Pax JDBC Generic Driver Extender
 56 | Active      |  80 | 1.0.1               | OPS4J Pax JDBC Config
 57 | Active      |  80 | 1.0.1               | OPS4J Pax JDBC Pooling Support Base
 58 | Active      |  80 | 1.0.0.201505202023  | org.osgi:org.osgi.service.jdbc
 92 | Active      |  80 | 4.0.9               | Apache Karaf :: JDBC :: Core
142 | Active      |  80 | 1.0.1               | OPS4J Pax JDBC Oracle Driver Adapter
143 | Active      |  80 | 1.0.1               | OPS4J Pax JDBC Pooling DBCP2
152 | Active      |  90 | 0                   | wrap_file__home_panos_.m2_repository_com_oracle_ojdbc7_12.1.0.2.0_ojdbc7-12.1.0.2.0.jar
karaf@root()> jdbc:ds-factories 
Name                                                                                    | Class                    | Version
----------------------------------------------------------------------------------------------------------------------------
wrap_file__home_panos_.m2_repository_com_oracle_ojdbc7_12.1.0.2.0_ojdbc7-12.1.0.2.0.jar | oracle.jdbc.OracleDriver | 0.0.0
oracle                                                                                  | oracle.jdbc.OracleDriver |
{code}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)