EclipseLink/DesignDocs/350487

From Eclipsepedia

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.

Concepts

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.

Requirements

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

Testing

API

GUI

Config files

Documentation

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

Decisions

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.