[ 
https://issues.apache.org/jira/browse/KARAF-5098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Christian Schneider closed KARAF-5098.
--------------------------------------
    Resolution: Not A Bug
      Assignee: Christian Schneider

We upgraded karaf to use pax-jdbc 1.x now. In this version the handling of 
DataSources changed.

See:
https://ops4j1.jira.com/wiki/display/PAXJDBC/Pooling+and+XA+support+in+1.0.0

Does that work for you?

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

Reply via email to