Suppress warning message on connection death about hikaricp

[brettwooldridge]

You can suppress these if you want. But you might not get these with the latest version (1.3.8), because the isConnectionAlive() test was allowing some dead connection through, when they should have been terminated before returning them to the user. But you might also want to make sure your maxLifetime in the pool is set to something slightly shorter than the idle timeout configured in your database.

[ams2990]

How do I suppress the warning messages? I didn't see a configuration setting.

[brettwooldridge]

You would do it through your logging framework. For example, in log4j (property file):

log4j.logger.com.zaxxer.hikari.proxy=ERROR

that will suppress logs that are less than ERROR (eg. WARN, INFO, DEBUG) for the classes in package com.zaxxer.hikari.proxy. Most other logging frameworks (java.util.logging) have similar configuration options.

[ams2990]

Is a dead connection the only warning HikariCP will throw?

[brettwooldridge]

The only other one is if you are using the leak detection feature. So, if you want to specifically target that message as much as possible, use:

log4j.logger.com.zaxxer.hikari.proxy.ConnectionProxy=ERROR

The leak detection is logged from another class, so would not be suppressed by that configuration.