在Oracle ucp中找不到oracle.ucp.jdbc.PoolDataSourceFactory [英] Cannot find oracle.ucp.jdbc.PoolDataSourceFactory in Oracle ucp

问题描述

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

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

但是当我在独立捆绑包中启动代码时，出现以下错误消息:

But when I start the code in a standalone bundle I get this error message:

    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.您可以帮助解决此问题吗?

Maybe I'm not configured the UCP correctly. Can you help to fix this issue?

推荐答案

Peter，我尚未从事UCP工作.因此，我可能无法为您提供完整的解决方案，但提示很少:

Peter, I have not worked on UCP. Hence I may not be able to give you a full solution but few hints:

1. 尝试使用Apache Commons DBCP，它以 DynamicImport-Package 放入*:BND配置指令:

1. Try using Apache Commons DBCP available as OSGi bundle.
2. Try removing the Import-Package directive from your BND configuration. BND is intelligent to identify this. Then possible refine your imports later on.

3. Try putting a DynamicImport-Package: * directive to your BND configuration.:

< DynamicImport-Package> *</DynamicImport-Package>

<DynamicImport-Package>*</DynamicImport-Package>

尝试上述步骤，并可能结合使用2& 3，然后举报是否可行.

Try the above steps, and possible combine 2 & 3 above, and report back if this works.

这篇关于在Oracle ucp中找不到oracle.ucp.jdbc.PoolDataSourceFactory的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！