SQL server debugging
First Claim
1. A software architecture for debugging a distributed database application process on a client connection, comprising:
- a server, wherein the server runs the distributed database application;
a client, wherein the client interacts with the distributed database application by way of the client connection;
a debugger, wherein the debugger debugs the distributed database application process; and
an application program interface (API), wherein the API receives a request to initiate a debugging session from the debugger, returns an interface pointer to the debugger, causes the server to the client connection according to the interface pointer, and connects the client connection to the debugger.
2 Assignments
0 Petitions
Accused Products
Abstract
A software architecture for debugging the execution of T-SQL and managed data-tier application logic associated with a single connection, in isolation from other connections, is provided. In the architecture, a database server hosts the data-tier application logic. A client connects to the database server and issues requests on the connection, which initiates the execution of the data-tier application logic. A debugger debugs a client process on the server. An application program interface (API) receives a request to initiate a debugging session from the debugger, and returns an interface pointer to the debugger, thereby enabling the debugger to debug the client connection to the server.
70 Citations
33 Claims
-
1. A software architecture for debugging a distributed database application process on a client connection, comprising:
-
a server, wherein the server runs the distributed database application;
a client, wherein the client interacts with the distributed database application by way of the client connection;
a debugger, wherein the debugger debugs the distributed database application process; and
an application program interface (API), wherein the API receives a request to initiate a debugging session from the debugger, returns an interface pointer to the debugger, causes the server to the client connection according to the interface pointer, and connects the client connection to the debugger. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A method of communicating between a server process, a client process and a debugger process in a distributed database environment, comprising:
-
receiving a first call for a stored procedure from the debugger process;
returning an interface pointer to the debugger process responsive to the received first call;
receiving a second call for a register method from the debugger process, wherein the second call comprises a machine name, a process ID and an interface pointer;
recognizing a client connection matching the machine name, process ID and interface pointer on the server process;
halting execution of the client connection on the server process responsive to said detection;
executing a third call, wherein the third call establishes operative communications between the debugger process and the client process; and
debugging the client process. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18)
-
-
19. A computer-readable medium having computer-executable instructions for performing a method of communicating between a server process, a client process and a debugger process in a distributed database environment, the method comprising:
-
receiving a first call for a stored procedure from the debugger process;
returning an interface pointer to the debugger process responsive to the received first call;
receiving a second call for a register method from the debugger process, wherein the second call comprises a machine name, a process ID and an interface pointer;
recognizing a client connection matching the machine name, process ID and interface pointer on the server process;
halting execution of the client connection on the server process responsive to said detection;
executing a third call, wherein the third call establishes operative communications between the debugger process and the client process; and
debugging the client process. - View Dependent Claims (20, 21, 22, 23, 24, 25, 26)
-
-
27. A method of initiating a debugging session between a debugger and a client connection on a server running a distributed database application, comprising:
-
specifying the client connection to be debugged by way of an API;
returning an interface pointer to the debugger by way of the API;
calling a register method, wherein the register method uses the interface pointer to detect the client connection associated with the interface pointer;
halting execution of the client connection; and
enabling the debugger to debug the client connection by way of the server and the API. - View Dependent Claims (28, 29, 30, 31)
-
-
32. A computer-readable medium having computer-executable instructions for performing a method of initiating a debugging session between a debugger and a client connection on a server running a distributed database application, the method comprising:
-
specifying the client connection to be debugged by way of an API;
returning an interface pointer to the debugger by way of the API;
calling a register method, wherein the register method uses the interface pointer to detect the client connection associated with the interface pointer;
halting execution of the client connection; and
enabling the debugger to debug the client connection by way of the server and the API. - View Dependent Claims (33)
-
Specification