How can I debug Hibernate criteria queries?

I'm having trouble with my Hibernate criteria queries. How can I debug them?

Debugging Hibernate criteria queries can be tricky. First, ensure that your criteria is correctly constructed. What specific issue are you facing?

I think my query is returning incorrect results. How can I check the generated SQL?

You can enable SQL logging in Hibernate by setting the property hibernate.show_sql to true in your configuration. This will show the generated SQL in the console.

That helps! Is there a way to see the parameters being passed to the query?

Yes, you can use hibernate.format_sql to format the SQL output, and also log the parameters by using a logging framework like Log4j.

Thanks! Any tips for optimizing my criteria queries?

Consider using projections to fetch only the necessary fields, and avoid fetching large collections unless needed. Also, check for N+1 select issues.