Hibernate slow sql not logged

Question

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?

score 3 · Answer 1 · answered Jan 12 '21 at 06:32

3

The problem is known and already open at Hibernate: https://hibernate.atlassian.net/browse/HHH-13741

answered Jan 12 '21 at 06:32

Thomas

I am looking for a work around or any solution https://github.com/hibernate/hibernate-orm/pull/5082#issuecomment-1267281714 – ozkanpakdil Oct 05 '22 at 08:24

Herisson-88 · Accepted Answer · 2023-07-20T14:00:14.977

0

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

edited Jul 20 '23 at 14:00

answered Jul 19 '23 at 15:42

Herisson-88

2 Answers2