Eclipse Community Forums: EclipseLink » SQL statement that createNamedQuery(...) method sent to the database?

Help

Home

Home » Eclipse Projects » EclipseLink » SQL statement that createNamedQuery(...) method sent to the database?

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

SQL statement that createNamedQuery(...) method sent to the database? [message #385460]

Wed, 11 February 2009 17:25

Mohamud

Messages: 1
Registered: July 2009

Junior Member

Hi there,

How do I get the SQL statement that createNamedQuery(...) method sent to
the database?

For debugging purpose, I want to write a log file the SQL statement that
createNamedQuery method sent to the database in order to trace-out what
SQL statement has been sent to the database.

Example:

Query query = em.createNamedQuery("getUserByName");

log.debug(???) What was the SQL statement?

Thanks
Mohamed

Report message to a moderator

Re: SQL statement that createNamedQuery(...) method sent to the database? [message #385461 is a reply to message #385460]

Thu, 12 February 2009 12:37

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

If you set logging to FINE or lower all SQL will be logged. The log is
set using the persistence.xml property,

"eclipselink.logging.level"="FINE"

You can also access the EclipseLink DatabaseQuery from your JPA Query and
get its SQL,

((JpaQuery)query).getDatabaseQuery().prepareCall(session, null);
((JpaQuery)query).getDatabaseQuery().getSQLString();

---
James
http://www.nabble.com/EclipseLink---Users-f26658.html

James : Wiki : Book : Blog : Twitter

Report message to a moderator

Previous Topic:	NPE on concurrent entity manager access
Next Topic:	Persisting thousands of files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 10:50:15 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter