Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Logging JPQL
Logging JPQL [message #759896] Wed, 30 November 2011 13:50 Go to next message
Mauro is currently offline MauroFriend
Messages: 79
Registered: July 2009
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 18:26 Go to previous message
James Sutherland is currently offline James SutherlandFriend
Messages: 1939
Registered: July 2009
Location: Ottawa, Canada
Senior Member

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.

James : Wiki : Book : Blog : Twitter
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:

Current Time: Fri Jun 22 05:51:14 GMT 2018

Powered by FUDForum. Page generated in 0.01849 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top