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)
