Dear Tom,

I am using Oracle 11g Database, a Production Java Web Application is using, which is written in Jdeveloper 11.1.1.5.0.

When the system is performing simple UI record updating, there is no. of Leaked Connection Count generated after saving.

Briefing:

After reviewing the log, there is error show as below:

<XX_XXX> <[ACTIVE] ExecuteThread: '13' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <fb12d27fe30e4542:6dc3ab72:17780cd0503:-8000-0000000000042df2> <1612946549483> <BEA-001153> <Forcibly releasing inactive connection "weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection@9b65" back into the connection pool "xxx_nonXA", currently reserved by: java.lang.Exception

:

at xxxx.xx.xxx.xxx.xxx.bean.RoleCommonBean.commitSaveUpdate(RoleCommonBean.java:256)

=> For ((RoleCommonBean.java:256) , it is showing "operationBinding.execute()

=> In Oracle Weblogic Server, the parameter "Inactive Connection Timeout" has set to Zero and

the "Remove Infected Connections Enabled" has also enabled.

Question raise:

Q1) Is there any "Exception handling" or else need to improve at Java program in order to reduce this error? any example?

Q2) Do we need to adjust the setting of above parameter mentioned? What is the use of these 2 parameters?

Q3) What is connection pooling? Would you mind giving an example(s) that show thorough understanding of the JDBC application connections to the oracle database?

Q4) Any directions provided to me in order to reduce "Leaked Connection Count"?

Thank you for your kind attention

Best Regards

David

public ... MyDbRoutine(Connection c, .....)
{
   c = [initiate a connection]
}