Java Connection pool exhausted error

Asked Apr 23 '13 at 05:07

Active Apr 23 '13 at 05:09

Viewed 2,025 times

I know normally if the error happened, i mean org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted, which means the conenction is overloaded. but in this case, I pretty sure there's no connection to my local mysql server(I used 'show processlist' command).

is there any other place can cause this error?

bellow is my code:

try {
    // Obtain a connection
    InitialContext ctx = new InitialContext();
    DataSource ds = (DataSource) ctx.lookup(jndiSrc);
    _log.info("==============" + jndiSrc + " is bound to " + ds + "=====================");
    return ds.getConnection(); 
}

edited Apr 23 '13 at 05:09

bsiamionau

8,099
4
46
73

asked Apr 23 '13 at 05:07

Lihong Qiu

2

Are you closing the connections you retrieve from the connection source? – Thihara Apr 23 '13 at 05:10
Also, what is the pool size you have set in the `DataSource`? – Pradeep Pati Apr 23 '13 at 05:13

Java Connection pool exhausted error

0 Answers0