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/24 12:41:04 UTC
[jira] [Commented] (KARAF-5098) Oracle pool datasources are missing
in Karaf 4.0.9
[ https://issues.apache.org/jira/browse/KARAF-5098?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15981102#comment-15981102 ]
Panos Kavalagios commented on KARAF-5098:
-----------------------------------------
Yes, we confirm that adding the following parameters:
{code:none}
pool=dbcp2
xa=true
{code}
in our org.ops4j.datasource.cfg with the plain "oracle" datasource, it gives the same behaviour of "oracle-pool-xa" and resolves the issue.
> 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
> Assignee: Christian Schneider
> Priority: Blocker
> Labels: regression
>
> 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)