访问Weblogic发生以下异常:
2013-08-20 10:15:11 ERROR [ExceptionConvertOnlyFilter] doFilter (line:70) Could not open JDBC Connection for transaction; nested exception is weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool BILLING_DS to allocate to applications, please increase the size of the pool and retry..
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool BILLING_DS to allocate to applications, please increase the size of the pool and retry..
解决办法:
在weblogic后台:Services->Data Sources-><select the particular Data source> -> Control
this will shows the conditions of the Data source in all servers it has been targeted. Now check the respective server with overloaded issue and do STOP - CLEAR THE CONNECTION CACHE -- START
this is only a workaround. for complete resolution you have to monitor the DB usage and according to that you have to tune the connection pool parameters.