Skip to main content

Posts

Showing posts from August, 2019

JDBC Connection Leak in ADF app on a WebLogic Server

It's an old topic but worthy to post as it happens frequent enough in codes that I observed. The bottom line of the issue that I am going to describe here is a coding issue, to it applies to WebLogic 11g as well as 12c. An ADF app deployed on a remote WebLogic Server went to an error page frequently. Checking the log, I found it's complaining on "JBO-26061: Error while opening JDBC connection". The next thing I did is checking the data source of the ADF App configured on the WebLogic Server console. On the Data Source -> Monitoring -> Statistics, the "Active Connection Average Count", "Active Connections Current Count" and "Active Connection High Count" all showed "15", which is the default max capacity of a connection pool. This shows all the connections are taken and no more connection available. I go to Monitoring -> Testing, select on the affected server and click on "Test Data Source", such error w