Search code examples
sqloraclehibernatehikaricp

Hibernate slow sql not logged

Problem with logging sql statement wrapped with Hikari.

I have hibernate property:

hibernate.session.events.log.LOG_QUERIES_SLOWER_THAN_MS=50
logging.level.org.hibernate.SQL_SLOW" level="info

but in log I get only class names instead of query

SlowQuery: 64 milliseconds. SQL: 'HikariProxyPreparedStatement@1310910690 wrapping oracle.jdbc.driver.OraclePreparedStatementWrapper@33cffb6d

how can I log slow query statement wrapped by hikari?

Solution

  • https://github.com/hibernate/hibernate-orm/pull/7030 An Hibernate Leader's PR today solve the issue. Merged on Hibernate.main, will be available on next 6.3