Log4jdbc Spring Boot Starter

The Log4jdbc Spring Boot Starter facilitates the quick and easy use of log4jdbc in Spring Boot projects.

Log4jdbc is particularly handy as it can log SQL that is ready to run. Instead of logging SQL with '?' where parameter values need to be inserted (like, for example, what spring.jpa.properties.hibernate.show_sql=true does), log4jdbc can log SQL with those place holders substituted with their actual values. So instead of select name from User where id = ? the log will say select name from User where id = 5.

Quick Start

• Minimum requirements — You'll need Java 1.8+ and Spring Boot 2.1+.
• Download — Depend on this library using, for example, Maven:

  <dependency>
    <groupId>com.integralblue</groupId>
    <artifactId>log4jdbc-spring-boot-starter</artifactId>
    <version>[INSERT VERSION HERE]</version>
  </dependency>

• Configure — In application.properties, enable a logger (for example, logging.level.jdbc.sqlonly=ERROR). See Loggers for details.

Configuration

Use application.properties to configure log4jdbc. There is Spring configuration meta-data for IDE autocompletion; see spring-configuration-metadata.json. Supported settings are:

Loggers

Note that, by default, nothing will be logged. In fact, if all the loggers are disabled (which is the default), then log4jdbc doesn't even wrap the java.sql.Connection returned by javax.sql.DataSource.getConnection() (which is useful for production configurations).

To set a logger's level, use application.properties in the same way any other log level is configured (see the Spring Boot Logging Guide for reference). For example, logging.level.jdbc.sqlonly=DEBUG