-
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.
-
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
-
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.
-
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