karaf-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Panos Kavalagios (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (KARAF-5098) Oracle pool datasources are missing in Karaf 4.0.9
Date Mon, 24 Apr 2017 12:41:04 GMT

    [ 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)

Mime
View raw message