We have an app using WLS 10.3.5.
We have set the following:
100/100 for Initial/MAX capacity
JDBC THIN NON-XA
Statement Cache: LRU
cache Size: 10
TEST CONNECTIONS ON RESERVE: TRUE
TEST FREQ: 0
SECONDS TO TRUST IDLE POOL: 0
Shrink Freq: 0
Connection Creation Retry Freq: 10
Inactive Connect Timeout: 180
maximum waiting for connection: 2147483647
Connection reserve timeout: 0
Ignore In-Use Connections: TRUE
Pinned-To Thread: FALSE
REMOVE INFECTED CONNECTIONS ENABLED: SELECTED
WRAP DATA TYPES: SELECTED
on NO LOAD, when browsing the app, we would get:
"The data source is unavailable. Please wait a few seconds and try again".
On WLS server logs:
<Sep 24, 2012 12:00:24 AM CDT> <Warning> <JDBC> <BEA-001153> <Forcibly releasing inactive connection "weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection@399e" back into the connection pool "JDBC Data Source-0", currently reserved by: java.lang.Exception
The above can probably be a warning message...of course.