Search code examples
javahibernatelogbackslf4j

Hibernate - Selectively print queries in the logs

I saw this link which has the details of printing sql query along with parameters. Is there a way to selectively print the queries using any configuration in logback - say for example I want to just print insert and update statements and not select or print only operations done to certain tables.

Similarly I also see the below being printed. I want the log statement to start from "insert into". Is there a way to exclude any before the actual sql statement without having to build custom appenders?

batching 1 statements: 0: insert into.....

Solution

  • Use regex fitlering

    https://logback.qos.ch/manual/filters.html#matcher

    Should be doable to discinct SELECT from INSERT