Jump to: navigation, search


Design Specification: Support for Stored Procedure Calls

ER 350487

Document History

Date Author Version Description & Notes
21 November 2011 Gordon Yorke Initial document creation

Project overview

JPA specification 2.1 has introduced support for executing Stored Procedure calls. This includes a new StoredProcedureQuery API and Named Stored Procedure Queries.


Stored Procedure are pre-existing portions of code on the database that can be called through a standard syntax. JDBC has support for calling Stored Procedures. Support is available for returning multiple resultsets and multiple update result counts as well.


Beyond implementation of the APIs ensure the surrounding behavioural requirements as outlined in section 3.8 are met included returning multiple result sets and multiple update counts.

Design Constraints

Design / Functionality




Config files


Open Issues

This section lists the open issues that are still pending that must be decided prior to fully implementing this project's requirements.

Issue # Owner Description / Notes


This section lists decisions made. These are intended to document the resolution of open issues or constraints added to the project that are important.

Issue # Description / Notes Decision

Future Considerations

During the research for this project the following items were identified as out of scope but are captured here as potential future enhancements. If agreed upon during the review process these should be logged in the bug system.