Eclipse Community Forums: EclipseLink

Help

Home

Home » Eclipse Projects » EclipseLink » Logging JPQL

Show: Today's Messages :: Show Polls :: Message Navigator

Logging JPQL [message #759896]

Wed, 30 November 2011 13:50

Mauro

Messages: 79
Registered: July 2009

Member

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.

Report message to a moderator

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

Mon, 05 December 2011 18:26

James Sutherland

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

Report message to a moderator

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 [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 11:55:58 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter