在 Oracle ucp 中找不到 oracle.ucp.jdbc.PoolDataSourceFactory

Question

我想使用以下代码创建Oracle UCP：

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 not wait for a used connection to be released by a client.
            pool.setConnectionHarvestTriggerCount(40);
            pool.setConnectionHarvestMaxCount(10);

我正在使用

<plugin>
            <groupId>org.apache.felix</groupId>
            <artifactId>maven-bundle-plugin</artifactId>
            <version>2.4.0</version>
            <extensions>true</extensions>
            <configuration>
                <instructions>
                    <Embed-Dependency>ucp,ojdbc6</Embed-Dependency>
                    <Import-Package>
                        org.osgi.framework,
                        javax.sql,
                        javax.naming,
                        oracle.jdbc.pool.OracleDataSource,
                        oracle.ucp.jdbc.PoolDataSourceFactory,
                        oracle.ucp.jdbc.PoolDataSourceImpl,
                        javax.naming.spi,
                        javax.management,
                        javax.management.modelmbean,
                        oracle.jdbc.pool
                    </Import-Package>
                    <Include-Resource>
                        ucp-11.2.0.3.jar,
                        ojdbc6-11.2.0.3.jar
                    </Include-Resource>
                    <Bundle-ClassPath>
                        ucp-11.2.0.3.jar,
                        ojdbc6-11.2.0.3.jar,
                        .
                    </Bundle-ClassPath>
                    <Bundle-SymbolicName>${project.artifactId}</Bundle-SymbolicName>
                    <Bundle-Activator>org.test.ucp.activator.Activator</Bundle-Activator>
                </instructions>
            </configuration>
        </plugin>

但是当我在独立捆绑包中启动代码时，我收到以下错误消息：

    Test Oracle UCP
ERROR: Bundle ucpTest [21] Error starting inputstream:ucpTest-1.0.jar (org.osgi.framework.BundleExce
ption: Activator start error in bundle ucpTest [21].)
java.lang.IllegalArgumentException: interface oracle.ucp.jdbc.LabelableConnection is not visible fro
m class loader
        at java.lang.reflect.Proxy$ProxyClassFactory.apply(Unknown Source)
        at java.lang.reflect.Proxy$ProxyClassFactory.apply(Unknown Source)
        at java.lang.reflect.WeakCache$Factory.get(Unknown Source)
        at java.lang.reflect.WeakCache.get(Unknown Source)
        at java.lang.reflect.Proxy.getProxyClass0(Unknown Source)
        at java.lang.reflect.Proxy.newProxyInstance(Unknown Source)
        at oracle.ucp.jdbc.proxy.ConnectionProxyFactory.createConnectionProxy(ConnectionProxyFactory
.java:78)
        at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:919)
        at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:863)
        at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:855)
        at org.test.osgi.ucp.impl.OracleDS_UCP.getConnection(OracleDS_UCP.java:26)
        at org.test.ucp.activator.Activator.testOracleUCP(Activator.java:41)
        at org.test.ucp.activator.Activator.start(Activator.java:17)
        at org.apache.felix.framework.util.SecureAction.startActivator(SecureAction.java:645)
        at org.apache.felix.framework.Felix.activateBundle(Felix.java:1977)
        at org.apache.felix.framework.Felix.startBundle(Felix.java:1895)
        at org.apache.felix.framework.Felix.setActiveStartLevel(Felix.java:1191)
        at org.apache.felix.framework.FrameworkStartLevelImpl.run(FrameworkStartLevelImpl.java:295)
        at java.lang.Thread.run(Unknown Source)

也许我没有正确配置 UCP。你能帮忙解决这个问题吗？

Answer 1

彼得，我没有在UCP上工作过。因此，我可能无法为您提供完整的解决方案，但有一些提示：

1. 尝试使用作为OSGi捆绑包提供的Apache Commons DBCP。
2. 尝试从 BND 配置中删除导入包指令。BND很聪明地识别这一点。然后以后可能会优化您的导入。

3. 尝试将 DynamicImport-Package： * 指令放入您的 BND 配置：

   *

尝试上述步骤，并可能结合上面的2和3，并报告是否有效。