Getting SQL from Criteria

Question

I'm working with hibnernate and I've a piece of code like:

    Criteria criteria = getCurrentSession().createCriteria(objectClass);
    criteria.add(Restrictions.isNull("myFields"));
    System.out.println("SQL: " + criteria.getSQL()); <-- How can I do this?
    return criteria.list();

I'd like to print the SQL (or HQL) to the console, for debugging, but I can't find any method to get this kind of information.

I've already seen many answers on stackoverflow like this and this but those are old questions and I dosen't find any useful answer.

Can anyone help me? Thanks

score 4 · Accepted Answer · answered May 12 '17 at 13:00

The easiest way to do this -- edit your Hibernate configuration.

You can set up

hibernate.show_sql = true

to enable the logging of all the generated SQL statements to the console.

Moreover you can set up

hibernate.format_sql = true
hibernate.use_sql_comments = true

to make it more readable

Read more about Hibernate configuration here

score 2 · Answer 2 · answered May 12 '17 at 12:52

2

if you use persistance.xml then you add property

<property name="hibernate.show_sql" value="true"/>

answered May 12 '17 at 12:52

Piotr Rogowski

3,642
19
24

Ooooh very interesting... could you please tell me where can I find this file? Thank you – Alessandro May 12 '17 at 12:54
@Alessandro how the way do you choise, jpa + persistance or hibernare.cfg and xml ? – Piotr Rogowski May 12 '17 at 12:55
It's an existing project, I only have to do a little fix – Alessandro May 12 '17 at 12:57
try find file `persistance.xml` in project catalog – Piotr Rogowski May 12 '17 at 12:59

Getting SQL from Criteria

2 Answers2