CORRELATING QUERIES ISSUED BY APPLICATIONS WITH THEIR SOURCE LINES AND ANALYZING APPLICATIONS FOR PROBLEM DETERMINATION AND WHERE USED ANALYSIS

摘要

Provided are techniques for invoking with a processor executing on a computer a source code parser to obtain source information that includes a first location of an Application Programming Interface (API) call and parameters of the API call in source code of a client application, where the parameters the API call do not include query text for a query that is to be used to access a database; examining a stack trace to determine a second location of the API call in the stack trace; and deriving the query of the API call and a third location of the query in the source code by identifying the query in the stack trace at the location of the API call in the stack trace.

主权项

1. A method, comprising:
setting, with a processor executing on a computer, one or more breakpoints in source code of a client application based on locations of Application Programming Interface (API) calls in the source code; and while running the client application through a debugger, upon reaching each of the one or more breakpoints,
identifying one or more debugger rules associated with a query at a breakpoint;in response to determining that conditions of the one or more debugger rules are satisfied, obtaining a stack trace before the query makes a call to a database; andderiving query text of the query and a location of the query in source code of the client application.