How to get SQL from Hibernate Criteria API in Hibernate 6?

Asked May 23 '23 at 11:48

Active May 24 '23 at 04:23

Viewed 171 times

I'd like to get the sql string from a CriteriaQuery using Hibernate 6.

Query.getQueryString() does no longer work in Hibernate 6 for CriteriaQuery.
SQLExtractor.from() dos not work either because it just uses reflection to call Query.getQueryString()
How to get SQL from Hibernate Criteria API (*not* for logging) only works for hibernate versions up to 5.
logging the sql statements is not enough in my use case. I need to store them in a string for processing.

Any ideas?

edited May 24 '23 at 04:23

asked May 23 '23 at 11:48

BetaRide

Have you checked the [`SQLExtractor`](https://github.com/vladmihalcea/hypersistence-utils/blob/20e64bb04257364db3446148d7ad6fe8739579a6/hypersistence-utils-hibernate-62/src/main/java/io/hypersistence/utils/hibernate/query/SQLExtractor.java) from [this article](https://vladmihalcea.com/get-sql-from-jpql-or-criteria/)? It has a hibernate 6 as well as 6.2 version. – XtremeBaumer May 23 '23 at 12:19
Yes. `SQLExtractor` uses reflection to call `Query.getQueryString()` which does not work for CriteriaQuery in hibernate 6. Added `SQLExtractor` to the negative list. – BetaRide May 24 '23 at 04:22
Hello @BetaRide, could you please share the solution if you managed to find it? – Egor Aug 04 '23 at 15:18
1

Nothing to share so far :-(. – BetaRide Aug 07 '23 at 05:42

0 Answers0