How to trace SQL statemtents execution in XS applications?

[Former Member]

Hello,

I am developing an XS application that allows user to edit and execute SQL statements (like HANA Studio's SQL Console). When using this app to execute any SQL statement, it does not trace the execution to the sql trace file like when I using HANA Studio's SQL Console.

Do you know how to configure in system, or do I miss any codeline?

Thank you.

[lbreddemann]

Did you setup the SQL trace on the server?

More important: what do you want the trace for? Maybe you get a better experience with using the expensive statements trace or the auditing features (depending on what you actually want).

[Former Member]

Firstly, thank you.

Yes, I have the SQL trace activated on my server and I can see SQL statements are traced when I executing scripts using HANA Studio SQL console, but not my XS app.

Anwser your 2nd question: I want to trace every possible SQL statements, like HANA Studio's SQL Console. Actually, my team and I are developing a web based HANA SQL Console, which is a part of HANA Web IDE.

In HANA Web IDE, there is as well a component named Trace, which allows user to view HANA trace files content, including SQL trace.

Because the application is XS application, I don't know whether there is any limitation.