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

eclipselink, jpa, orm

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.

Problem

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)?

Original source