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

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

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

Wed, 11 February 2009 12:25

Eclipse User

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

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

Thu, 12 February 2009 07:37

Eclipse User

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

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

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Jul 13 06:50:48 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter