Method, system, and program for invoking stored procedures and accessing stored procedure data

• US 20020016814A1
• Filed: 04/27/2001
• Published: 02/07/2002
• Est. Priority Date: 08/07/2000
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Dessloch, Stefan, Wollscheid, Dirk, Convent, Bernhard L., Wolfson, Charles Daniel, Saracco, Cynthia Maro
• Application Number:
  US09/845,065
• Publication Number:
  US 20020016814A1
• Time in Patent Office: Days
• US Class Current: 709/203
• CPC Class Codes: G06F 9/465 Distributed object oriented systems remote method invocation [RMI] G06F9/548
• CPC Class Codes: G06F 9/548 Object oriented; Remote method invocation [RMI] non-remote method invocation G06F9/449

Abstract

Provided is a method, system, and program for enabling access to data. A call is received from a client to invoke a remote interface method. A remote interface implementation accesses parameters from the received call in response to the invocation of the remote interface method. A stored procedure call is generated with the accessed parameters as input parameters of the stored procedure. The stored procedure call is transferred to a stored procedure named by the call to execute. Output from the stored procedure is received and inserted into a data object that is returned to the client.

Claims

1. A method for enabling access to data, comprising:

receiving a call from a client to invoke a remote interface method;

accessing, with a remote interface implementation, parameters from the received call in response to the invocation of the remote interface method;

generating a stored procedure call with the accessed parameters as input parameters of the stored procedure;

transferring the stored procedure call to a stored procedure named by the call to execute;

receiving output from the stored procedure;

inserting the received output from the stored procedure into a data object; and

returning the data object to the client.

2. The method of claim 1, wherein the stored procedure executes in a database server and generates the output, wherein the output is capable of comprising output that is a member of the set of output comprising one or more result sets of data from the database table and one or more output parameters resulting from stored procedure operations performed on data in the database table.

3. The method of claim 1, further comprising processing, with the remote interface implementation, an input mapping to determine the parameters in the client call to use as input parameters to the stored procedure call.

4. The method of claim 1, further comprising:

receiving the stored procedure output after the stored procedure program completes execution.

5. The method of claim 1, further comprising processing an output mapping indicating how the stored procedure output is mapped to the data object.

6. The method of claim 5, wherein the output is capable of including result sets and parameters, wherein the output mapping indicates an order in which the received result sets and parameters are added to the data object.

7. The method of claim 1, further comprising:

generating metadata describing the stored procedure output included in the data object; and

adding the metadata to the data object.

8. The method of claim 7, further comprising:

processing, with the client, the metadata in the received data object to determine how to access the stored procedure output from the data object.

9. The method of claim 7, wherein the data object is comprised of multiple elements, wherein the stored procedure output includes rows of data from at least one result set, wherein inserting the stored procedure output into the data object further comprises inserting data from each column in each row in each result set to one element in the data object, and wherein the metadata defines structure and types of data in each element.

10. The method of claim 7, wherein the data object is comprised of multiple elements, and wherein the stored procedure output is capable of including multiple output parameters, wherein inserting the stored procedure output into the data object further comprises inserting each output parameter into one element in the data object, and wherein the metadata provides information on structure and type of the data in each element.

11. The method of claim 1, wherein the client only receives one data object with stored procedure output in response to the call.

12. The method of claim 1, wherein the remote interface implementation is implemented as a Enterprise JavaBean and wherein the data object comprises a Java serializable object.

14. The method of claim 13, wherein the generated remote interface implementation inserts metadata into the data object providing information on the stored procedure output inserted into the data object.

16. The system of claim 15, wherein the stored procedure executes in a database server and generates the output, wherein the output is capable of comprising output that is a member of the set of output comprising one or more result sets of data from the database table and one or more output parameters resulting from stored procedure operations performed on data in the database table.

17. The system of claim 15, further comprising means for processing, with the remote interface implementation, an input mapping to determine the parameters in the client call to use as input parameters to the stored procedure call.

18. The system of claim 15, further comprising:

means for receiving the stored procedure output after the stored procedure program completes execution.

19. The system of claim 15, further comprising means for processing an output mapping indicating how the stored procedure output is mapped to the data object.

20. The system of claim 19, wherein the output is capable of including result sets and parameters, wherein the output mapping indicates an order in which the received result sets and parameters are added to the data object.

21. The system of claim 15, further comprising:

means for generating metadata describing the stored procedure output included in the data object; and

means for adding the metadata to the data object.

22. The system of claim 21, further comprising:

means for processing, with the client, the metadata in the received data object to determine how to access the stored procedure output from the data object.

23. The system of claim 21, wherein the data object is comprised of multiple elements, wherein the stored procedure output includes rows of data from at least one result set, wherein the means for inserting the stored procedure output into the data object further inserts data from each column in each row in each result set to one element in the data object, and wherein the metadata defines structure and types of data in each element.

24. The system of claim 21, wherein the data object is comprised of multiple elements, and wherein the stored procedure output is capable of including multiple output parameters, wherein the means for inserting the stored procedure output into the data object further inserts each output parameter into one element in the data object, and wherein the metadata provides information on structure and type of the data in each element.

25. The system of claim 15, wherein the client only receives one data object with stored procedure output in response to the call.

26. The system of claim 15, wherein the remote interface implementation is implemented as a Enterprise JavaBean and wherein the data object comprises a Java serializable object.

28. The system of claim 27, wherein the generated remote interface implementation inserts metadata into the data object providing information on the stored procedure output inserted into the data object.

30. The article of manufacture of claim 29, wherein the stored procedure executes in a database server and generates the output, wherein the output is capable of comprising output that is a member of the set of output comprising one or more result sets of data from the database table and one or more output parameters resulting from stored procedure operations performed on data in the database table.

31. The article of manufacture of claim 29, further comprising processing, with the remote interface implementation, an input mapping to determine the parameters in the client call to use as input parameters to the stored procedure call.

32. The article of manufacture of claim 29, further comprising:

receiving the stored procedure output after the stored procedure program completes execution.

33. The article of manufacture of claim 29, further comprising processing an output mapping indicating how the stored procedure output is mapped to the data object.

34. The article of manufacture of claim 33, wherein the output is capable of including result sets and parameters, wherein the output mapping indicates an order in which the received result sets and parameters are added to the data object.

35. The article of manufacture of claim 29, further comprising:

generating metadata describing the stored procedure output included in the data object; and

adding the metadata to the data object.

36. The article of manufacture of claim 35, further comprising:

processing, with the client, the metadata in the received data object to determine how to access the stored procedure output from the data object.

37. The article of manufacture of claim 35, wherein the data object is comprised of multiple elements, wherein the stored procedure output includes rows of data from at least one result set, wherein inserting the stored procedure output into the data object further comprises inserting data from each column in each row in each result set to one element in the data object, and wherein the metadata defines structure and types of data in each element.

38. The article of manufacture of claim 35, wherein the data object is comprised of multiple elements, and wherein the stored procedure output is capable of including multiple output parameters, wherein inserting the stored procedure output into the data object further comprises inserting each output parameter into one element in the data object, and wherein the metadata provides information on structure and type of the data in each element.

39. The article of manufacture of claim 29, wherein the client only receives one data object with stored procedure output in response to the call.

40. The article of manufacture of claim 29, wherein the remote interface implementation is implemented as a Enterprise JavaBean and wherein the data object comprises a Java serializable object.

13. A method for making stored procedure programs available to application programs, comprising:

determining one stored procedure program generating output needed by one application program;

generating a remote interface implementation to respond to a remote interface method capable of receiving a call from the application program including data and invoking a stored procedure in a database server with the data from the application program used as input; and

generating an output mapping for the remote interface implementation to use to determine how to insert the stored procedure output into a data object that may be used by the application program.

15. A system for enabling access to data, comprising:

means for receiving a call from a client to invoke a remote interface method;

means for accessing, with a remote interface implementation, parameters from the received call in response to the invocation of the remote interface method;

means for generating a stored procedure call with the accessed parameters as input parameters of the stored procedure;

means for transferring the stored procedure call to a stored procedure named by the call to execute;

means for receiving output from the stored procedure;

means for inserting the received output from the stored procedure into a data object; and

means for returning the data object to the client.

27. A system for making stored procedure programs available to application programs, comprising:

means for determining one stored procedure program generating output needed by one application program;

means for generating a remote interface implementation to respond to a remote interface method capable of receiving a call from the application program including data and invoking a stored procedure in a database server with the data from the application program used as input; and

means for generating an output mapping for the remote interface implementation to use to determine how to insert the stored procedure output into a data object that may be used by the application program.

29. An article of manufacture for enabling access to data by:

receiving a call from a client to invoke a remote interface method;

accessing, with a remote interface implementation, parameters from the received call in response to the invocation of the remote interface method;

generating a stored procedure call with the accessed parameters as input parameters of the stored procedure;

transferring the stored procedure call to a stored procedure named by the call to execute;

receiving output from the stored procedure;

inserting the received output from the stored procedure into a data object; and

returning the data object to the client.

41. An article of manufacture for making stored procedure programs available to application programs by:

determining one stored procedure program generating output needed by one application program;

generating a remote interface implementation to respond to a remote interface method capable of receiving a call from the application program including data and invoking a stored procedure in a database server with the data from the application program used as input; and

generating an output mapping for the remote interface implementation to use to determine how to insert the stored procedure output into a data object that may be used by the application program.

42. The article of manufacture of claim 41, wherein the generated remote interface implementation inserts metadata into the data object providing information on the stored procedure output inserted into the data object.