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
Historical Number
PRI16882
Product Synonym
[<p><b>]Fact[</b><p>];Sterling Integrator[<br/>] SCI91968 [<br/>] A new database pool added
Was this topic helpful?
Document Information
Modified date:
11 February 2020
UID
swg21525309