Logging SQL statements in Spring Boot + jdbi

Question

I'm using datasource with DBI:

@Autowired
DataSource dataSource;

@Bean
public DBI dbiBean() {
    DBI dbi = new DBI(dataSource);
    return dbi;
}

I have no idea how to configure logging framework to log SQL statements. I tried:

logging:
 level: 
   org.hibernate: TRACE
   org.skife.jdbi: TRACE
   java.sql: TRACE

but it doesn't work.

In which class did you create `Bean` object?, I think it should be set in `*Application` class which contains main method. — harshavmb, Apr 07 '17 at 11:53
In one of spring @Config class. I found how to log SQL statements, but my solution not show SQL params — Marcin Wiśniewski, Apr 07 '17 at 12:11
Have seen that https://stackoverflow.com/questions/23564383/how-to-print-the-sqlquery-annotation-in-jdbi-sql-api ? — Vladislav Kysliy, May 23 '17 at 10:06

score 4 · Accepted Answer · answered Aug 27 '21 at 15:39

Starting from JDBI version 3.2.0, SqlLogger interface should be used:

  Jdbi jdbi;
  jdbi.setSqlLogger(new Slf4JSqlLogger());

As documentation says, Slf4JSqlLogger is a simple SqlLogger that emits some diagnostic information about Jdbi usage. You can provide existing instance of Slf4J Logger class to the Slf4JSqlLogger constructor then the provided logger will be used to log SQL statements, otherwise, if no-args constructor is used, a logger called org.jdbi.sql will be created and used.

SQL statements are logged with debug log level, so in order to see them it might be necessary to set the root level of the logging framework to debug.

score 3 · Answer 2 · answered Mar 17 '20 at 15:44

3

Add the line to set the SQL log like this. Use either SLF4JLog or another logger there.

@Bean
public DBI dbiBean() {
    DBI dbi = new DBI(dataSource);
    dbi.setSQLLog(new SLF4JLog());
    return dbi;
}

answered Mar 17 '20 at 15:44

Paul Vickery

31
2

1

I think this is specific to JDBI 2. Doesn't work with JDBI 3. – TechSpellBound Aug 07 '20 at 14:31

Logging SQL statements in Spring Boot + jdbi

2 Answers2