debug SQL procedure using UI5 application

[Former Member]

Dear Experts,

I have developed an SAPUI5 application on Eclipse and I am using a SQL Anywhere database as its back end. I want to debug the SQL procedure called in the UI5 application for posting data. I have opened the SQL Anywhere in debug mode but the application doesn't stop at the breakpoint. Kindly help.

[Vlad]

There is an article in DCX that describes everything related to the debugging in SA17. Have you read and followed it? The SQL Anywhere Debugger

[Former Member]

Yes, I have read it and I am able to debug the procedure through Interactive SQL Window. Only when I run my SAPUI5 application that is calling this procedure, the breakpoint is not triggered.

[Former Member]

When you switch to debug view in SQL Central, you have to accept the "debug all users" (*) suggestion. I'm guessing you have done that because you can debug from Interactive SQL windows.

If I had to guess I'd suspect the procedure is not being called. There are several moving parts between UI5 and the stored procedure: perhaps the problem is in one of those parts. You could check by adding a MESSAGE statement with TO CONSOLE (http://dcx.sap.com/index.html#sqla170/en/html/3be51a926c5f10148fd9c9c9884dde68.html) to your procedure: like a printf only it writes to the SQL Anywhere console.