Inactive connectino timeout property of Datasource!
posted 7 years ago
I am facing issue with Datasource on weblogic 10.3, which is using Oracle Thin driver Type 4 as JDBC driver. Initially the application works fine after some time, I get
"weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool ". I have checked my code throughly and there is no leak issue, for sure. I have confirmed this by putting loggers and checking the same in all different possible scneario's.
I had come across a datasource property called "Inactive connection timeout". After setting this properties value as non zero, the application is working fine. Can you please let me know is it good to use this property with non zero value?