Oracle Weblogic Server (MOSC)

MOSC Banner

PoolLimitSQLException

edited Dec 12, 2014 10:01AM in Oracle Weblogic Server (MOSC) 1 commentAnswered

I'm using weblogic 10.3.5.  My current configurations are the default ones

Initial Capacity: 1

Maximum Capacity: 15

Capacity Increment: 1

I got the below errors.  I have a process that will query a database every minute using JDBC in java.  This is the only process that will access this database.   In my code I close the connections already once I'm done with it.

Right now I increased the Maximum Capacity to 150.  My question is what is the appropriate pool size that I should put in? Thanks

weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool VentasCnn to allocate to applications, please increase the size of the pool and retry..

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center