How to configure max number of connection attempts/retries?

Openfire Openfire Support
1

When something in configuration is wrong then log is spammed with a ton of identical messages:

org.jivesoftware.database.DbConnectionManager - Unable to get a connection from the database pool (attempt 0 out of 10).
…
org.jivesoftware.database.DbConnectionManager - Unable to get a connection from the database pool (attempt 10 out of 10).
…
java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 retries

How I can configure max retries?
I think I need to write something in openfire.xml in database->defaultProvider section, but what?
(PS: I need to set it to just one retry.)
Thanks.

2

Try setting this in openfire.xml:

<jive>
    ...
    <database>
        <maxRetries>5</maxRetries>
        <retryDelay>250</retryDelay>
        ...
    </database>
3

guus, thank You. Perfect!
Maybe you’ll add this settings to default conf for next release? Maybe someone needed too.
After reading this message close the topic as solved.

4

maxRetries works partially:

org.jivesoftware.openfire.XMPPServer - java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 retries