Access to original SQL from ExecutionFactory

[mickalas]

Hi,

Is there anyway to get hold of the original SQL sent to Teiid (parsed or unparsed) from within ExecutionFactory.createExecution? I.e. before it has been rewritten by Teiid.

It may be accessible from ExecutionContext, but I have not seen how.

The reason I would like this is to improve our diagnostics. I'd like to link the queries from users to what we execute in our Translator.

Many Thanks

Mick Davies

[shawkins]

No it is not currently directly accessible.  It may potentially have little relationship to what is happening at the source though - given the presence of view layers and the rewrite/optimization.

Generally the correlation is seen with logging as the request id will be the same for the user and source sql that is logged.

[mickalas]

Thanks for the swift reply.

We are using the Embedded version, and we don't see original SQL logged anywhere. Do you know how I can get that logged?

Cheers

Mick

[shawkins]

> Do you know how I can get that logged?

The best logging is through command logging - Logging - Teiid 8.11 - Project Documentation Editor

You can enable it by setting the org.teiid.COMMAND_LOG context to the appropriate level.

[mickalas]

Hi,

I tried this, setting COMMAND_LOG to debug as per instructions, but did not see commands logged, actually I set all logging to DEBUG, and saw other teiid logging at debug level. I wonder if it is because we are using Embedded Server.

Mick