Is There a JDBC Connection Pool Limit Set or Enforced in WebLogic Server (WLS)? [ID 1292587.1]

There are no such limit for the number of data sources in a single WLS domain.
WLS also imposes no practical limit to the number of connections. From a practical perspective, the number of connections will typically be limited by what the DBMS can tolerate/provide. The only practical WebLogic limits will involve JVM memory, which is provoked most by the number of statements cached with a pooled connection, particularly for Oracle connections. For the Oracle thin driver in their latest versions, we suggest turning WebLogic’s statement caching off, and turning on the driver-level statement caching by adding the appropriate driver properties to the list in the WebLogic pool definition.

Leave a Reply