Zheng Tech Blog

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...

Here I am describing JDBC Data Sources and Connection Pooling using a few slides that I borrowed from Oracle Weblogic 12c BootCamp. 1. What's JDBC Data Source? 2.  Scope of Data Source: system or application.  All JDBC configurations must conform to the new weblogic-jdbc.xsd schema. IDE can validate the JDBC modules based on the schema. 3.  What’s a Connection Pooling? 4. How Connection Pooling works? 5. Benefits of Connection Pooling? 6. How Data Source Connection Pooling is used? 7. Connection Pooling Configuration 8. Connection Pooling Hints