How to view the SQL queries issued by JPA?

by

Logging options are provider-specific. You need to know which JPA implementation do you use.

  • Hibernate (see here):

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

  • EclipseLink (see here):

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

  • OpenJPA (see here):

    <property name="openjpa.Log" value="DefaultLevel=WARN,Runtime=INFO,Tool=INFO,SQL=TRACE"/>

  • DataNucleus (see here):

    Set the log category DataNucleus.Datastore.Native to a level, like DEBUG.

More Related Contents:

  1. Do I need elements in persistence.xml?
  2. The JPA hashCode() / equals() dilemma
  3. Spring JPA selecting specific columns
  4. What is the “owning side” in an ORM mapping?
  5. What is the difference between persist() and merge() in JPA and Hibernate?
  6. JPQL Create new Object In Select Statement – avoid or embrace?
  7. Hibernate, @SequenceGenerator and allocationSize
  8. What is the difference between Unidirectional and Bidirectional JPA and Hibernate associations?
  9. “detached entity passed to persist error” with JPA/EJB code
  10. Spring Data JPA – “No Property Found for Type” Exception
  11. JPA/Hibernate Native Queries do not recognize Parameters
  12. Please explain about insertable=false and updatable=false in reference to the JPA @Column annotation
  13. What is the easiest way to ignore a JPA field during persistence?
  14. @Transactional method called from another method doesn’t obtain a transaction
  15. Hibernate bidirectional @ManyToOne, updating the not owning side not working
  16. Spring boot JPA insert in TABLE with uppercase name with Hibernate
  17. Single DAO & generic CRUD methods (JPA/Hibernate + Spring)
  18. Is there such thing CASE expression in JPQL?
  19. JPA Criteria builder IN clause query
  20. When are connections returned to the connection pool with Spring JPA (Hibernate) Entity Manager?
  21. How to map a map JSON column to Java Object with JPA
  22. JPA Native Query select and cast object
  23. JPA: JOIN in JPQL
  24. How to create a JPA query with LEFT OUTER JOIN
  25. Java: Hibernate @OneToOne mapping
  26. Hibernate, spring, JPS & isolation – custom isolation not supported
  27. JSR303 custom validators being called twice
  28. database sort vs. programmatic java sort
  29. JPA Criteria Tutorial [closed]
  30. How to map one class with multiple tables in Hibernate/javax.persistance?

Leave a Comment