Search code examples
jpaeclipselinkorm

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

I want to output the SQL generated by EclipseLink to the console, during development. However, I could only do so using the logging level FINE. I have a complex domain model composed of many classes, so much that deployment takes a considerable ammount of time when the log verbosity is on the FINE level, since EclipseLink outputs its analysis of the whole model.

Is there a way to get the SQL without resorting to log level FINE (like Hibernate does)?

Solution

  • 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.