Database connection pool overloaded

Openfire Openfire Support
1

Hi,

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?

Thanks,

Max

2

Hi,

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.

LG