Is it possible to output generated SQL using EclipseLink without having to increase log verbosity?

by

Put the following properties in your persistence.xml:

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

The latter is helpful, so that the values of the parameter are shown.

An alternative is using log4jdbc or log4jdbc-remix.

Related Contents:

  1. What is referencedColumnName used for in JPA?
  2. JPA Enum ORDINAL vs STRING
  3. No operator matches the given name and argument type(s). You might need to add explicit type casts. — Netbeans, Postgresql 8.4 and Glassfish
  4. Are SQL injection attacks possible in JPA?
  5. How to fix the Hibernate “object references an unsaved transient instance – save the transient instance before flushing” error
  6. What’s the difference between JPA and Hibernate? [closed]
  7. How to map a composite key with JPA and Hibernate?
  8. Map enum in JPA with fixed values?
  9. When and why JPA entities should implement the Serializable interface?
  10. Please explain about insertable=false and updatable=false in reference to the JPA @Column annotation
  11. What’s the difference between JPA and Spring Data JPA?
  12. Hibernate Annotations – Which is better, field or property access?
  13. JPA CascadeType.ALL does not delete orphans
  14. What is Persistence Context?
  15. How to annotate MYSQL autoincrement field with JPA annotations
  16. What is the difference between persist() and merge() in JPA and Hibernate?
  17. How to map calculated properties with JPA and Hibernate
  18. JPQL IN clause: Java-Arrays (or Lists, Sets…)?
  19. Do I need elements in persistence.xml?
  20. JPA: How to have one-to-many relation of the same Entity type
  21. Specifying an Index (Non-Unique Key) Using JPA
  22. How to remove entity with ManyToMany relationship in JPA (and corresponding join table rows)?
  23. Parameter in like clause JPQL
  24. Clarifying terminology – What does “hydrating” a JPA or Hibernate entity mean when fetching the entity from the DB
  25. Create JPA EntityManager without persistence.xml configuration file
  26. What is the “owning side” in an ORM mapping?
  27. JPA: how do I persist a String into a database field, type MYSQL Text
  28. Multiple unique constraints in JPA
  29. JPA – Persisting a One to Many relationship
  30. java.lang.IllegalArgumentException: Removing a detached instance com.test.User#5
  31. kotlin data class + bean validation jsr 303
  32. JPA vs ORM vs Hibernate?
  33. What is the solution for the N+1 issue in JPA and Hibernate?
  34. Getting Database connection in pure JPA setup
  35. Difference between @Size, @Length and @Column(length=value) when using JPA and Hibernate
  36. How to clone a JPA entity
  37. Detach an entity from JPA/EJB3 persistence context
  38. JPA passing list to IN clause in named native query
  39. Spring Data JPA And NamedEntityGraphs
  40. How To Define a JPA Repository Query with a Join
  41. How to map a map JSON column to Java Object with JPA
  42. Eclipse does not recognize content of persistence.xml
  43. Disable caching in JPA (eclipselink)
  44. IntelliJ IDEA highlights @Entity class names with “Cannot resolve symbol” in JPQL
  45. JPA/Hibernate Native Queries do not recognize Parameters
  46. JPA Criteria API: how to express literal true and literal false?
  47. Testing an EJB with JUnit
  48. What is the exact meaning of the JPA @Entity annotation?
  49. I found JPA, or alike, don’t encourage DAO pattern
  50. @ManyToMany(mappedBy = “foo”)

Leave a Comment