java - How I can configure StatementInspector in Hibernate?

Question

https://docs.jboss.org/hibernate/orm/5.2/javadocs/org/hibernate/Interceptor.html says that onPrepareStatement(String sql) is Deprecated. Supply a StatementInspector instead, if you wish to inspect and alter SQL statements.

But I am not clear how I can configure StatementInspector in Hibernate at application level (i don't want to set it at each hibernate session level).

Answer 1

Don't do like that )

You need only two things:

1. Add property to persistence.xml:

property name="hibernate.session_factory.statement_inspector" value="full-qualified class name"

2. Write your listener class by implementing interface org.hibernate.resource.jdbc.spi.StatementInspector.

Profit!