I’m using Openfire and editing for customizing my server.
But I faced a critical problem about an Exception.
I’m using MariaDB with my Openfire Server. And When I use my server long time, The active connection pool become 25 and the console said like this
java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 retries. The exception from the last attempt is as follows: java.sql.SQLException: Cannot get a connection, pool error Timeout waiting for idle object
I added more code about accessing database and I closed my resources(ex: rs, pstmt, con etc…) but It still keep connection active fully.
I thought when I close my resources, The connection will be return back active connection to available but It wasn’t
How can I fix it?
I changed max connection 25 → 100 but It fully became active connection pool to 100