|
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. |
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 24 Apr '17, 02:47
question was seen: 943 times
last updated: 26 Apr '17, 10:46
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
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.
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.