Cannot find oracle.ucp.jdbc.PoolDataSourceFactory in Oracle ucp

Question

I want to create Oracle UCP using this code: ``` import oracle.ucp.jdbc.PoolDataSource; import oracle.ucp.jdbc.PoolDataSourceFactory; System.out.println("***** OracleDS_UCP -> start init of PoolDataSource"); PoolDataSource pool = PoolDataSourceFactory.getPoolDataSource(); pool.setConnectionFactoryClassName("oracle.jdbc.pool.OracleDataSource"); pool.setURL("jdbc:oracle:thin:@localhost:1521:XE"); pool.setUser("test"); pool.setPassword("test"); pool.setMaxStatements(10); // the maximum number of statements that may be pooled or cached on a connection. pool.setInitialPoolSize(2); pool.setMinPoolSize(1); pool.setMaxPoolSize(50); pool.setLoginTimeout(60); // one minute pool.setConnectionWaitTimeout(60); // one minute pool.setAbandonedConnectionTimeout(30 * 60); // thirty minutes pool.setMaxIdleTime(60 * 60); // one hour and kill inactive or idle connections pool.setInactiveConnectionTimeout(60 * 60); // one hour and kill inactive or idle connections pool.setConnectionWaitTimeout(0); // do n…

Accepted Answer

Peter, I have not worked on UCP. Hence I may not be able to give you a full solution but few hints: - Try using Apache Commons DBCP available as OSGi bundle. - Try removing the Import-Package directive from your BND configuration. BND is intelligent to identify this. Then possible refine your imports later on. Try putting a DynamicImport-Package: * directive to your BND configuration.: * Try the above steps, and possible combine 2 & 3 above, and report back if this works.

Cannot find oracle.ucp.jdbc.PoolDataSourceFactory in Oracle ucp

Solution

Problem