My Oracle Support Banner

Database adapter cannot be loaded when external connection pooling is used (Doc ID 412762.1)

Last updated on APRIL 23, 2019

Applies to:

Oracle(R) BPEL Process Manager 10g - Version 10.1.2.0.2 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

Resource adapter cannot be loaded error occurred during BPEL startup when both "usesExternalConnectionPooling" and "shouldCacheAllStatements" property are set to true in oc4j-ra.xml file.

Example

<connector-factory location="eis/DB/Connection1" connector-name="Connection1">
<config-property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
<config-property name="connectionString" value=""/>
<config-property name="userName" value=""/>
<config-property name="password" value=""/>
<config-property name="minConnections" value=""/>
<config-property name="maxConnections" value=""/>
<config-property name="minReadConnections" value=""/>
<config-property name="maxReadConnections" value=""/>
<config-property name="usesExternalConnectionPooling" value="true"/>
<config-property name="dataSourceName" value="jdbc/Connection1"/>
<config-property name="usesExternalTransactionController" value="true"/>
<config-property name="platformClassName" value="oracle.toplink.internal.databaseaccess.DatabasePlatform"/>
<config-property name="usesNativeSequencing" value="true"/>
<config-property name="sequencePreallocationSize" value="50"/>
<config-property name="tableQualifier" value=""/>
<config-property name="defaultNChar" value="false"/>
<config-property name="usesBatchWriting" value="true"/>
<config-property name="shouldCacheAllStatements" value="true"/>
</connector-factory>

Start the BPEL Server, you will get the the following error.


ERROR MESSAGE
Resource adapter deployed as stand-alone cannot be loaded due to this error:
config-property named shouldCacheAllStatements specified in oc4j-ra.xml does not exist in ra.xml

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.