How can I get sql string from hibernate criteria?

Question

I work in mysql, and using hibernate criteria to build query. But I don't know how to get sql query from that criteria, so any one can help me, that could be grate, many thanks ?

tungosper

https://stackoverflow.com/questions/554481/how-to-get-sql-from-hibernate-criteria-api-not-for-logging — Rana_S, Jun 24 '17 at 03:41

score 3 · Answer 1 · edited Jun 23 '17 at 18:46

3

Just go to hibernate config.xml and add

<property name="show_sql">true</property>

You can see SQL query in your console after executing criteria or any hibernate query now.

edited Jun 23 '17 at 18:46

Blackbam

17,496
26
97
150

answered Jun 23 '17 at 16:46

Pradip Wawge

133
4

How can I get sql string from hibernate criteria?

1 Answers1