Eclipse Community Forums: EclipseLink

Home » Eclipse Projects » EclipseLink » Logging JPQL

Wed, 30 November 2011 08:50

Eclipse User

It is possible to log the SQL queries generated by a JPQL query setting the property:

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

How can I log JPQL query itself?

I would like to see the JPQL that generated each set of SQL queries.

The purpose is to turn on this log in an existing application and analyse which JPQL is not optimized.

I tried setting to ALL the level of log4j, even so the JPQL was not shown.

Is it possible, or I should change every code of my application to log explicitly the JPQL ?

Thanks. Mauro.

Re: Logging JPQL [message #760975 is a reply to message #759896]

Mon, 05 December 2011 13:26

Eclipse User

I think if you set the log level to finest then the query is logged, and the query should print the JPQL when it is printed, at least on the latest EclipseLink release.

Otherwise, you could add a SessionEventListener and dump the JPQL from the preExecuteQuery event.

Previous Topic:	NPE in AbstractRecord.get() after failed insert
Next Topic:	How to get a ref cursor/resultset from a StoredFunctionCall or StoredProcedureCall

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Aug 31 13:17:46 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter