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.
Difference between revisions of "EclipseLink/DesignDocs/350843"
(New page: <div style="margin:5px;float:right;border:1px solid #000000;padding:5px">__TOC__</div> = Design Specification: <feature-name> = [http://bugs.eclipse.org/350843 ER 350843] == Document His...) |
|||
Line 1: | Line 1: | ||
<div style="margin:5px;float:right;border:1px solid #000000;padding:5px">__TOC__</div> | <div style="margin:5px;float:right;border:1px solid #000000;padding:5px">__TOC__</div> | ||
− | = Design Specification: | + | = Design Specification: Generic Query function support = |
[http://bugs.eclipse.org/350843 ER 350843] | [http://bugs.eclipse.org/350843 ER 350843] | ||
Line 11: | Line 11: | ||
! Version Description & Notes | ! Version Description & Notes | ||
|- | |- | ||
− | | | + | | 08 November 2011 |
− | | | + | | Gordon Yorke |
− | | | + | | initial document creation |
|} | |} | ||
== Project overview == | == Project overview == | ||
− | + | The SQL spec and many databases have SQL functions that are not covered by the JPA specification. With the latest JPA specification the ability to call generic SQL functions will be added to JPQL and the Criteria API. This feature will cover adding this support. | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
== Concepts == | == Concepts == | ||
+ | May functions like 'UTC_DATE' are supported by databases but not provided with the JPQL syntax or the criteria API. This feature will provide the APIs necessary to call a function by name using the keyword FUNCTION. The syntax takes the form: | ||
+ | |||
+ | function_invocation::= FUNCTION(function_name {, function_arg}*) | ||
+ | function_arg ::= | ||
+ | literal | | ||
+ | state_field_path_expression | | ||
+ | input_parameter | | ||
+ | scalar_expression | ||
− | + | and CriteriaBuilder.<T> Expression<T> function(String name, Class<T> type, Expression<?>... args); | |
== Requirements == | == Requirements == | ||
− | + | Implement support for the function() method and the FUNCTION keyword. | |
== Design Constraints == | == Design Constraints == |
Revision as of 15:19, 8 November 2011
Design Specification: Generic Query function support
Document History
Date | Author | Version Description & Notes |
---|---|---|
08 November 2011 | Gordon Yorke | initial document creation |
Project overview
The SQL spec and many databases have SQL functions that are not covered by the JPA specification. With the latest JPA specification the ability to call generic SQL functions will be added to JPQL and the Criteria API. This feature will cover adding this support.
Concepts
May functions like 'UTC_DATE' are supported by databases but not provided with the JPQL syntax or the criteria API. This feature will provide the APIs necessary to call a function by name using the keyword FUNCTION. The syntax takes the form:
function_invocation::= FUNCTION(function_name {, function_arg}*) function_arg ::=
literal | state_field_path_expression | input_parameter | scalar_expression
and CriteriaBuilder.<T> Expression<T> function(String name, Class<T> type, Expression<?>... args);
Requirements
Implement support for the function() method and the FUNCTION keyword.
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.