4 Replies Latest reply on Sep 15, 2015 4:01 AM by mickalas

Access to original SQL from ExecutionFactory

mickalas Sep 9, 2015 9:41 AM

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

1. Re: Access to original SQL from ExecutionFactory

shawkins Sep 9, 2015 10:05 AM (in response to mickalas)

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.
Actions
2. Re: Access to original SQL from ExecutionFactory

mickalas Sep 9, 2015 10:19 AM (in response to shawkins)

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
Actions
3. Re: Access to original SQL from ExecutionFactory

shawkins Sep 9, 2015 10:43 AM (in response to mickalas)

> 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.
Actions
4. Re: Access to original SQL from ExecutionFactory

mickalas Sep 15, 2015 4:01 AM (in response to shawkins)

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
Actions

Go to original post