Hikari is Chatty

[kraftp]

Running a simple DBOS program you get spammed with unhelpful Hikari logs:

13:16:58.350 [main] INFO com.zaxxer.hikari.HikariDataSource -- HikariPool-1 - Starting...
13:16:58.596 [main] INFO com.zaxxer.hikari.pool.HikariPool -- HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@37271612
13:16:58.597 [main] INFO com.zaxxer.hikari.HikariDataSource -- HikariPool-1 - Start completed.
13:16:58.606 [main] INFO dev.dbos.transact.migrations.MigrationManager -- Creating 'dbos_java_starter' database
13:16:58.912 [main] INFO com.zaxxer.hikari.HikariDataSource -- HikariPool-1 - Shutdown initiated...
13:16:58.915 [main] INFO com.zaxxer.hikari.HikariDataSource -- HikariPool-1 - Shutdown completed.
13:16:58.915 [main] INFO com.zaxxer.hikari.HikariDataSource -- HikariPool-2 - Starting...
13:16:58.934 [main] INFO com.zaxxer.hikari.pool.HikariPool -- HikariPool-2 - Added connection org.postgresql.jdbc.PgConnection@37858383
13:16:58.935 [main] INFO com.zaxxer.hikari.HikariDataSource -- HikariPool-2 - Start completed.
13:16:58.968 [main] INFO dev.dbos.transact.migrations.MigrationManager -- Applying migration file 001_migration_up.sql
13:16:59.092 [main] INFO com.zaxxer.hikari.HikariDataSource -- HikariPool-2 - Shutdown initiated...
13:16:59.093 [main] INFO com.zaxxer.hikari.HikariDataSource -- HikariPool-2 - Shutdown completed.
13:16:59.095 [main] INFO dev.dbos.transact.DBOS -- Launching DBOS v0.5.330-preview+gba3ab0c
13:16:59.097 [main] INFO dev.dbos.transact.execution.DBOSExecutor -- Executor ID: local
13:16:59.097 [main] INFO dev.dbos.transact.execution.DBOSExecutor -- Application Version: 05e3338528c62d274f7cb598b826b8a092931ea4887e61a247b06b50e226884f
13:16:59.098 [main] INFO com.zaxxer.hikari.HikariDataSource -- HikariPool-3 - Starting...
13:16:59.111 [main] INFO com.zaxxer.hikari.pool.HikariPool -- HikariPool-3 - Added connection org.postgresql.jdbc.PgConnection@1cbb87f3
13:16:59.111 [main] INFO com.zaxxer.hikari.HikariDataSource -- HikariPool-3 - Start completed.
13:16:59.132 [main] INFO dev.dbos.transact.execution.RecoveryService -- No workflows to recover for application version 05e3338528c62d274f7cb598b826b8a092931ea4887e61a247b06b50e226884f
13:16:59.133 [main] INFO dev.dbos.transact.execution.DBOSExecutor -- DBOS started
Step one completed!
Step two completed!
13:17:00.117 [main] INFO dev.dbos.transact.DBOS -- DBOS shut down

Is there any way for us to configure Hikari's logging to be less chatty by default? It's a purely internal thing whose logs probably shouldn't be exposed to users at all.

[devhawk]

The demo apps set the Hikari log level to ERROR via the application.properties file. Is that sufficient or do we need something programmatic?

[kraftp]

I'd like it to be done by default instead of requiring a bunch of custom configuration

[devhawk]

Deleted the default logback.xml file in #220 because it was interfering w/ customer log configurations

[erkieh]

Thanks for the change in #220.

Just to clear things. In my case, I already had a logback.xml in my project and when building the project I received warnings that multiple logback.xml-s were found on the classpath. The configuration in DBOS logback.xml affected our logging, causing new logging output, in a format not compatible with our systems, to appear.