Exception - com.ibm.as400.access.ConnectionPoolException: Maximum configured number of connections has been reached.

[safuanmansor]

Hi ,

Is there any way we can tune the max connection poll value from 100 to 200 maybe?

The error keep coming multple times a day and gone by it self yet it enough to annoy the engineering team. While on other system it only show 3 to 4 rows of connection.

if (pool == null) {
AS400JDBCConnectionPoolDataSource dataSource = new AS400JDBCConnectionPoolDataSource(system, userID, password);
dataSource.setSecure(true);
dataSource.setSocketTimeout(120000);////(60000 millisec == 1 min)- required when pool is trying to connect to a system that was shutdown after pool was opened.. in that case without timeout connection will hang
dataSource.setThreadUsed(false);
pool = new AS400JDBCConnectionPool(dataSource);
pool.setMaxConnections(100);
SecureJDBCPool.put(system, pool);

Thanks.

[fcuerno001]

Hi everyone, someone can resolved this issue i'm same problem