Database adapter cannot be loaded when external connection pooling is used

Last updated on JULY 22, 2009

Applies to:

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

Cause