How to debug JPA CriteriaBuilder queries

Question

How can I debug a query built with JPA 2.0 CriteriaBuilder? Is there a way to print out the query that is being executed?

I am developing a web application using NetBeans, MySql, GlassFish. I would avoid starting MySql in debug mode, because it is used also for other applications. JPA provider is EclipseLink.

No prob; check this: http://stackoverflow.com/questions/2374395/is-it-possible-to-output-generated-sql-using-eclipselink-without-having-to-incre — home, Dec 29 '11 at 19:19
@home, since OP indicated GlassFish is being used, I guess EclipseLink would be a safe guess ;) — Arjan Tijms, Dec 29 '11 at 19:20
Similar question: [http://stackoverflow.com/questions/4362876/how-to-view-the-sql-queries-issued-by-jpa][1] [1]: http://stackoverflow.com/questions/4362876/how-to-view-the-sql-queries-issued-by-jpa — Marcus Becker, Dec 12 '13 at 16:26

score 14 · Accepted Answer · edited May 23 '17 at 12:06

The same attributes in persistence.xml that also print the SQL that is generated from regular JPQL queries, should also print the SQL that is generated from Criteria queries.

E.g.

For Hibernate (used by e.g. JBoss AS) it's:

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

For EclipseLink (used by e.g. GlassFish) it's:

<property name="eclipselink.logging.level" value="FINE"/>
<property name="eclipselink.logging.parameters" value="true"/>

Also see: How to view the SQL queries issued by JPA?

score 3 · Answer 2 · edited Sep 19 '22 at 20:27

3

If you are using Java and Spring, under resources, you can adjust your application.properties file and add the line below:

spring.jpa.show-sql=true

edited Sep 19 '22 at 20:27

Laurel

5,965
14
31
57

answered Apr 30 '20 at 10:31

Sithija Piyuman Thewa Hettige

1,768
20
26

How to debug JPA CriteriaBuilder queries

2 Answers2