Web-based debugging of database sessions

Patent metadata

Field	Value
Publication number	US-9710512-B2
Application number	US-201414315580-A
Country	US
Kind code	B2
Filing date	Jun 26, 2014
Priority date	Nov 25, 2013
Publication date	Jul 18, 2017
Grant date	Jul 18, 2017

Abstract

A system includes reception, from a first user, of a first web-protocol request to establish a first database server session, establishment of the first database server session in response to the first request, reception, from a second user, of a second web-protocol request to establish a second database server session and to communicate with the second database server session via a non-transient connection, establishment of the second database server session in response to the second request, reception, from the second user, of a third web-protocol request to attach the second database server session to the first database server session, attachment of the second database server session to the first database server session, and transmission of debugging information of the first database server session to the second user via the non-transient connection.

First claim

What is claimed is:

1. A system comprising:
a memory storing processor-executable process steps; and
a processor to execute the processor-executable process steps to cause the system to:
receive, from a first user, a first web-protocol request to establish a first database server session;
establish the first database server session in response to the first request;
receive, from a second user, a second web-protocol request to establish a second database server session and to communicate with the second database server session via a non-transient connection;
establish the second database server session in response to the second request;
receive a user interface from a client of one of the first database server session and the second database server session;
attach the user interface to one of the first database server session and the second database server session;
the user interface including program code configured to debug an application;
receive, from the second user, a third web-protocol request to attach the second database server session to the first database server session;
attach the second database server session to the first database server session;
receive a token from one of the first user and the second user, the token specifying that another of the first user and the second user is authorized to debug one or more of the server sessions;
receive from one of the first user and the second user a first request to access inactive private artifacts to test design time artifacts respectively associated with one of the first database server session and the second database server session;
determine with the token if the first request is from an authorized user; and
if the first request is from an authorized user, then:
activate the private artifacts in response to the received first request;
create a private runtime representation of the activated private artifacts; and
transmit debugging information of the debugged server session via the non-transient connection to the other of the first user and the second user that did not provide the first request.

2. A system according to claim 1 , wherein the processor is further to execute the processor-executable process steps to cause the system to:
execute server-side application program code in the first database server session;
prior to transmission of the debugging information, determine that execution has reached a breakpoint in the server-side application program code;
in response to the determination that execution has reached the breakpoint, and prior to transmission of the debugging information, halt execution of the server-side application program code.

3. A system according to claim 1 , wherein the first request conforms to HyperText Transfer Protocol protocol, and
wherein the second request and the third request conform to Web Socket protocol.

4. A system according to claim 1 , wherein the processor is further to execute the processor-executable process steps to cause the system to:
receive, from a third user, a fourth web-protocol request to establish a third database server session and to communicate with the third database server session via a second non-transient connection;
establish the third database server session in response to the fourth request;
receive, from the third user, a fifth web-protocol request to attach the third database server session to the first database server session;
attach the third database server session to the first database server session; and
transmit second debugging information of the first database server session to the third user via the second non-transient connection.

5. A system according to claim 4 , wherein the processor is further to execute the processor-executable process steps to cause the system to:
execute server-side application program code in the first database server session;
prior to transmission of the debugging information, determine that execution has reached a breakpoint in the server-side application program code;
in response to the determination that execution has reached the breakpoint, and prior to transmission of the debugging information and the second debugging information, halt execution of the server-side application program code.

6. A system according to claim 4 , wherein the processor is further to execute the processor-executable process steps to cause the system to:
in response to the third request, determine whether the second user is authorized to debug the first database server session, and
in response to the fifth request, determine whether the third user is authorized to debug the first database server session.

7. A system according to claim 1 , wherein the processor is further to execute the processor-executable process steps to cause the system to:
in response to the third request, determine whether the second user is authorized to debug the first database server session.

8. A computer-implemented method comprising:
receiving, from a first user, a first web-protocol request to establish a first database server session;
establishing the first database server session in response to the first request;
receiving a user interface from a client of one of the first database server session and the second database server session;
attaching the user interface to one of the first database server session and the second database server session;
the user interface including program code configured to debug an application;
receiving, from a second user, a second web-protocol request to establish a second database server session and to communicate with the second database server session via a non-transient connection;
establishing the second database server session in response to the second request;
receiving, from the second user, a third web-protocol request to attach the second database server session to the first database server session;
in response to the third request, determining whether the second user is authorized to debug the first database server session based on stored authorization information;
if it is determined that the second user is authorized to debug the first database server session, attaching the second database server session to the first database server session;
receiving from one of the first user and the second user a first request to access inactive private artifacts to test design time artifacts respectively associated with one of the first database server session and the second database server session;
determining with the token if the first request is from an authorized user; and
if the first request is from an authorized user, then:
activating the private artifacts in response to the received request;
creating a private runtime representation of the activate private artifacts; and
transmitting debugging information of the debugged server session via the non-transient connection to the other of the first user and the second user that did not provide the first request.

9. A computer-implemented method according to claim 8 , further comprising:
executing server-side application program code in the first database server session;
prior to transmitting the debugging information, determining that execution has reached a breakpoint in the server-side application program code;
in response to determining that execution has reached the breakpoint, and prior to transmitting the debugging information, halting execution of the server-side application program code.

10. A computer-implemented method according to claim 8 , wherein the first request conforms to HyperText Transfer Protocol protocol, and
wherein the second request and the third request conform to Web Socket protocol.

1

Assignees

• Foebel Florian
• Friedmann Bjoern
• Gruschko Boris
• Mohr Christian
• Strenge Martin
• Zorn Sascha
• Sap Se

Inventors

• Foebel Florian
• Friedmann Bjoern
• Gruschko Boris
• Mohr Christian
• Strenge Martin
• Zorn Sascha

Classifications

• G06F11/3668

  Testing of software · CPC title

• H04L63/083

  using passwords (cryptographic mechanisms or cryptographic arrangements for entity authentication using a predetermined code H04L9/3226) · CPC title

• G06F16/215

  Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors · CPC title

• G06F16/2365 Primary

  Ensuring data consistency and integrity · CPC title

• H04L63/08

  for authentication of entities (cryptographic mechanisms or cryptographic arrangements for entity authentication H04L9/32) · CPC title