IBM Support

SI fails to startup with error: "Invalid pool name 'NewPool_oraclePool' while getting a database connection. Please check for consistency of the properties files or BPML" (SCI91968)

Troubleshooting


Problem

SI fails to startup with error: "Invalid pool name 'oraclePool' while getting a database connection. Please check for consistency of the properties files or BPML" (SCI91968)

Symptom

SI fails to startup with error: "Invalid pool name 'NewPool_oraclePool' while getting a database connection. Please check for consistency of the properties files or BPML."

Cause

Resolving The Problem

verify new pool configuration in the jdbc_customer.properties for any erroneous configuration or extra characters, see examples below:



Wrong configuration:



NewPool_oraclePool.props=jdbcServiceCustomer
NewPool_orac lePool.maxsize=10;
NewPool_oraclePool.initsize= 0;
NewPool_oraclePool.class=com.sterlingcommerc e.woodstock.util.frame.jdbc.DBPoolLoader
NewPool_oraclePool.onEm pty=new



Correct configuration:


NewPool_oraclePool.props=jdbcServiceCustomer
NewPool_oraclePool.maxsize=10


NewPool_oraclePool.initsize=0
NewPool_oraclePool.class=com.sterlingcommerce.woodstock.util.frame. jdbc.DBPoolLoader
NewPool_oraclePool.onEmpty=new

[{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

PRI16882

Product Synonym

[<p><b>]Fact[</b><p>];Sterling Integrator[<br/>] SCI91968 [<br/>] A new database pool added

Document Information

Modified date:
11 February 2020

UID

swg21525309