带UCP的Mule OracleXADataSource和PoolXADataSourceImpl

Question

目前，我有一个使用带UCP的Oracle连接池的mule流。在本地，该流在执行时没有任何意外。

​

<spring:beans>
<spring:bean id="oracleDataSource" name="Oracle_Configuration" class="oracle.ucp.jdbc.PoolXADataSourceImpl">
        <spring:property name="URL" value="${oracle.jdbc.url}" />
        <spring:property name="user" value="${oracle.jdbc.user}" />
        <spring:property name="password" value="${oracle.jdbc.user}" />
        <spring:property name="connectionFactoryClassName" value="oracle.jdbc.xa.client.OracleXADataSource" />
        <spring:property name="connectionPoolName" value="connectionsPool" />
        <spring:property name="minPoolSize" value="5" />
        <spring:property name="maxPoolSize" value="10" />
        <spring:property name="connectionWaitTimeout" value="10000" />
        <spring:property name="validateConnectionOnBorrow" value="true" />
        <spring:property name="connectionProperties">
            <spring:props merge="default">
                <spring:prop key="AutoCommit">true</spring:prop>
            </spring:props>
        </spring:property>
    </spring:bean>
</spring:bean>

我在Oracle11中使用ojdbc6.jar和ucp.jar库

当我们在单机版中执行部署时，我遇到了这样的错误：

The method is disabled (java.sql.SQLException) oracle.ucp.util.UCPErrorHandler:488 (null)
java.sql.SQLException: The method is disabled (org.mule.module.db.sqlexecutor.connection.ConnectionCreationException)

Root Exception stack trace:
java.sql.SQLException: The method is disabled
at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:488)
at     oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:163)
at  oracle.ucp.jdbc.PoolXADataSourceImpl.getConnection(PoolXADataSourceImpl.java:108)
+ 3 more (set debug level logging or '-Dmule.verbose.exceptions=true' for everything)

感谢您的支持

Answer 1

连接属性"AutoCommit“可能已禁用。我不确定。我尝试了下面的数据源配置，它起作用了。

<spring:bean id="oraDataSource" class="oracle.ucp.jdbc.PoolXADataSourceImpl"> <spring:property name="URL" value="${jdbc.url}" /> <spring:property name="user" value="${jdbc.user}" /> <spring:property name="password" value="${jdbc.pass}" /> <spring:property name="connectionFactoryClassName" value="oracle.jdbc.xa.client.OracleXADataSource" /> <spring:property name="minPoolSize" value="1" /> <spring:property name="maxPoolSize" value="200" /> <spring:property name="connectionWaitTimeout" value="300" /> </spring:bean>