powered by Jive Software

Database connection pool overloaded


I have written a plugin for openfire that does a lot of database querying using the org.jivesoftware.database.DbConnectionManager. However, when I have a lot of operations going on with the server the connection pool quickly fills up and I receive errors such as this:

2009.01.20 03:17:05 158268 -053404 (25/25/00) - Couldn’t get connection because we are at maximum connection count and there are none available

Should I be using the DbConnectionManager for my custom database accesses, or what should I know about freeing database resources that can help me avoid this problem?




the default pool should contain 25 connections. So you may want to check your plugin and make sure that you close all resultsets, statements and connections.

There’s a developer forum for such questions.