topic Re: Debugging: is it possible to trace all executed NXQL? in Nuxeo Forum

Debugging: is it possible to trace all executed NXQL?

promanov_ — Tue, 18 Dec 2012 17:44:51 GMT

Is there a debug flag to activate tracing of executed NXQL queries? I'd like to see the queries with resolved parameters.

In case the params variables don't contain the expected values, the query can return empty result without any errors. These errors aren't easy to spot and analyse.

I was wondering how to trace resulting NXQL queries after EL resolution.

Any idea? Thanks.

Re: Debugging: is it possible to trace all executed NXQL?

Vladimir_Pasqui — Tue, 18 Dec 2012 17:49:08 GMT

Hi,

You can find the log4j xml configuration here: nuxeo/lib

Add these lines, and it should traced all nxql queries:

  <category name="org.nuxeo.ecm.platform.query">
    <priority value="TRACE" />
  </category>

Re: Debugging: is it possible to trace all executed NXQL?

promanov_ — Fri, 21 Dec 2012 16:12:16 GMT

Thanks for the fast response!