search

IBM / nagios-for-i

MIT License
19 stars 20 forks source link

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

Open safuanmansor opened 3 years ago

safuanmansor commented 3 years ago

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.

image

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 commented 1 year ago

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