Method and apparatus for providing multiple commands to a server

• US 6,324,567 B2
• Filed: 02/11/1999
• Issued: 11/27/2001
• Est. Priority Date: 06/11/1997
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle Corporation
• Inventors: Chidambaran, Luxi, Chandrasekaran, Sahikanth
• Primary Examiner(s): Harrell, Robert B.
• Assistant Examiner(s): Vaughn, Jr., William C.
• Application Number:
  US09/249,222
• Publication Number:
  US 20010011296A1
• Time in Patent Office: 1,020 Days
• Field of Search: 709/203, 709/219, 709/101, 709/202, 709/302, 709/303, 709/304, 709/305, 709/217, 709/310, 709/330, 709/313, 709/328, 707/103, 707/102, 707/104, 714/34, 714/758, 714/52, 714/49, 714/48
• US Class Current: 709/203
• CPC Class Codes: H04L 67/133 Protocols for remote procedure calls [RPC]
• CPC Class Codes: H04L 9/40 Network security protocols
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A method and apparatus allows a client to easily send multiple commands to a server. The client registers one or more tables with the method and apparatus of the present invention, which contain information with which to query the client if the client provides commands to be sent to a server. When the client sends a command intended for the server, the command and the tables are used to query the client. If the application responds affirmatively to the query, additional commands are generated for sending to the server. The method and apparatus assist in handling errors by deleting, either unconditionally or upon receipt of an instruction from the client, all pending commands related to the command causing the error and not generating additional such commands.

Claims

1. An apparatus for providing at an output a first set of commands to be sent to a server, comprising:

an administration having a first input operatively coupled to receive from an application program at least one command, and a second input operatively coupled to receive error messages, the administration for providing at a first output an indicator of receipt of the at least one command;

a query manager having an input coupled to the administration first output, the query manager for, responsive to receipt of the indicator of receipt, providing at an output coupled to the application program at least one query, each of said at least one query corresponding to at least one command in a second set;

an RPC builder having an input operatively coupled to receive from the application program at least one response corresponding to at least one of the at least one query, and for providing at an output coupled to the apparatus output coupled to the server at least one of the commands in the second set, responsive to at least one of the at least one response received at the RPC builder input;

and a server having an input coupled to the RPC builder output for receiving the commands in the second set the server for providing at an output coupled to the administration second input an error code and a tag of the said command, responsive to the execution of a command resulting in an error detectable by the server.

2. The apparatus of claim 1, wherein the administration additionally has a second output for providing an instruction to abort processing, and the server is additionally for receiving at a second input coupled to the administration second output said instruction and for aborting processing of at least one of the commands in the second set corresponding to the tag provided at the server output.

3. A method of providing at least one command, comprising:

receiving a first command from an application program;

providing the first command received;

responsive to the receipt of the first command, locating query information from a set of query information;

providing to the application program a query, responsive to the query information located;

receiving from the application program a response corresponding to the query provided;

building at least one second command, responsive to the response received; and

providing to a server the at least one second command built; and

wherein

at least one of the second commands comprises a remote procedure code capable of causing a server to execute a plurality of third commands; and

each of the first and second commands are provided to a queue; and

the method additionally comprises;

receiving an error message; and

discarding at least one command in the queue responsive to the error message.

4. The method of claim 3 comprising the additional step of, responsive to the error message received, providing a command to a server to abort processing of at least one second command.

5. A method of responding to an error caused by a command having a tag, comprising:

detecting the error;

generating an error message comprising the tag;

providing the error message generated; and

removing from a queue at least one different command having a tag corresponding to the tag of the command.

6. A method of responding to an error caused by a command having a tag, the method comprising:

detecting the error;

indicating suspension of execution of other commands having a tag equivalent to the tag of the command;

generating an error message comprising the tag;

providing the error message generated;

receiving a response having a first state and a second state;

responsive to the response in the first state, removing the suspension indicated; and

responsive to the response in the second state, deleting at least one of the other commands.

7. A computer program product comprising a computer useable medium having computer readable program code embodied therein for providing at least one command, the computer program product comprising:

computer readable program code devices configured to cause a computer to receive a first command from an application program;

computer readable program code devices configured to cause a computer to provide the first command received;

computer readable program code devices configured to cause a computer to, responsive to the receipt of the first command, locate query information from a set of query information;

computer readable program code devices configured to cause a computer to provide to the application program a query, responsive to the query information located;

computer readable program code devices configured to cause a computer to receive from the application program a response corresponding to the query provided;

computer readable program code devices configured to cause a computer to build at least one second command, responsive to the response received;

computer readable program code devices configured to cause a computer to provide to a server the at least one second command built; and

wherein

at least one of the second commands comprises a remote procedure code capable of causing a server to execute a plurality of third commands; and

each of the first and second commands are provided to a queue; and

the computer program product additionally comprises;

computer readable program code devices configured to cause a computer to receive an error message; and

computer readable program code devices configured to cause a computer to discard at least one command in the queue responsive to the error message.

8. The computer program product of claim 7 additionally comprising computer readable program code devices configured to cause a computer to, responsive to the error message received, provide a command to a server to abort processing of at least one second command.

9. A computer program product comprising a computer useable medium having computer readable program code embodied therein for responding to an error caused by a command having a tag, the computer program product comprising:

computer readable program code devices configured to cause a computer to detect the error;

computer readable program code devices configured to cause a computer to generate an error message comprising the tag;

computer readable program code devices configured to cause a computer to provide the error message generated; and

computer readable program code devices configured to cause a computer to remove from a queue at least one different command having a tag corresponding to the tag of the command.

10. A computer program product comprising a computer useable medium having computer readable program code embodied therein for responding to an error caused by a command having a tag, the computer program product comprising:

computer readable program code devices configured to cause a computer to detect the error;

computer readable program code devices configured to cause a computer to indicate suspension of execution of other commands having a tag equivalent to the tag of the command;

computer readable program code devices configured to cause a computer to generate an error message comprising the tag;

computer readable program code.devices configured to cause a computer to provide the error message generated;

computer readable program code devices configured to cause a computer to receive a response having a first state and a second state;

computer readable program code devices configured to cause a computer to responsive to the response in the first state, remove the suspension indicated; and

computer readable program code devices configured to cause a computer to, responsive to the response in the second state, delete at least one of the other commands.