Notice: This Wiki is now read only and edits are no longer possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
EclipseLink/DesignDocs/350487
Design Specification: Support for Stored Procedure Calls
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.