Unable To Set "Factoryproperties" When Creating A "Datasource connection pool" Via admin_client.jar utility (Doc ID 1317597.1)

Last updated on FEBRUARY 24, 2017

Applies to:

Oracle Containers for J2EE - Version 10.1.3.1.0 to 10.1.3.5.0 [Release AS10gR3]
Information in this document applies to any platform.

Symptoms

Using the OC4J admin_client.jar Utility to add a Data Source Connection Pool with Connection Pool properties fails;

Here is an  example:

> java -jar admin_client.jar deployer:oc4j:opmn://<OAS-host>:<opmn-request-port>/TestOC4J oc4jadmin <oas-password> -addDataSourceConnectionPool -applicationName TestApp -name MyCP -factoryClass oracle.jdbc.pool.OracleDataSource -dbUser foo1 -dbPassword bar1 -url jdbc:oracle:thin:@//localhost:1521/ORCL -factoryProperties max-connections 3


The following entry is added successfully into ( $OH/j2ee/TestOC4J/application-deployments/TestApp/data-sources.xml ) :

<connection-pool name="MyCP ">
<connection-factory factory-class="oracle.jdbc.pool.OracleDataSource" user="foo1" password="bar1" url="jdbc:oracle:thin:@//localhost:1521/ORCL"/>
</connection-pool>


However the command prints the error message:

addDataSourceConnectionPool error: addDataSourceConnectionPool failed: MBeanException creating JDBC connection pool: Exception thrown in RequiredModelMBean while trying to invoke operation addConnectionFactoryProperty : null

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms