This Bugzilla instance is deprecated, and most Eclipse projects now use GitHub or Eclipse GitLab. Please see the deprecation plan for details.
Bug 350843 - JPA 2.1 JPQL Generic Function support
Summary: JPA 2.1 JPQL Generic Function support
Status: RESOLVED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P3 enhancement (vote)
Target Milestone: ---   Edit
Assignee: James Sutherland CLA
QA Contact:
URL: http://wiki.eclipse.org/EclipseLink/D...
Whiteboard:
Keywords:
Depends on:
Blocks: 338610
  Show dependency tree
 
Reported: 2011-06-30 10:30 EDT by Gordon Yorke CLA
Modified: 2022-06-09 10:05 EDT (History)
2 users (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Gordon Yorke CLA 2011-06-30 10:30:31 EDT 
Support to call SQL functions not part of the JPQL BNF or Criteria API has been proposed for the Specification.

For JPQL the proposed form is " FUNCTION(function_name {, function_arg}*)" and can be used anywhere an expression can be used in a JPQL statement.

For Criteria Queries the method <T> Expression<T> function(String name, Class<T> type,Expression<?>... args); is being proposed for the CriteriaBuilder.
Comment 1 James Sutherland CLA 2012-02-28 11:25:57 EST 
Added support for FUNCTION in Hermes.

function() is already supported in Criteria as of JPA 2.0?
Comment 2 James Sutherland CLA 2012-03-01 15:08:13 EST 
See patch in bug#305187
Comment 3 Gordon Yorke CLA 2012-03-20 15:10:02 EDT 
For Criteria Queries the method <T> Expression<T> function(String name,
Class<T> type,Expression<?>... args); was introduced and supported as part of JPA 2.0
Comment 4 James Sutherland CLA 2012-04-11 10:46:59 EDT 
Fixed in 2.4
Comment 5 Eclipse Webmaster CLA 2022-06-09 10:05:03 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink