Skip to main content

Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.

Jump to: navigation, search

Difference between revisions of "EclipseLink/UserGuide/JPA/Basic JPA Development/Querying/Native"

m (EclipseLink Native Query)
m
Line 1: Line 1:
 +
{{EclipseLink_UserGuide|info=n}}
 
=EclipseLink Native Query=
 
=EclipseLink Native Query=
  
 
In addition to [[EclipseLink/UserGuide/JPA/Basic JPA Development/Querying/JPQL|JPQL]], EclipseLink rich native DatabaseQuery and Expression criteria API.
 
In addition to [[EclipseLink/UserGuide/JPA/Basic JPA Development/Querying/JPQL|JPQL]], EclipseLink rich native DatabaseQuery and Expression criteria API.
 
{{EclipseLink_API
 
|api=
 
*[http://www.eclipse.org/eclipselink/api/org/eclipse/persistence/queries/package-frame.html org.eclipse.persistence.queries]
 
*[http://www.eclipse.org/eclipselink/api/org/eclipse/persistence/expressions/package-frame.html org.eclipse.persistence.expressions]
 
}}
 
  
 
For additional information on EclipseLink native queries, see [[EclipseLink/UserGuide/Queries_(ELUG)|Queries]] in the ''EclipseLink User's Guide''.
 
For additional information on EclipseLink native queries, see [[EclipseLink/UserGuide/Queries_(ELUG)|Queries]] in the ''EclipseLink User's Guide''.

Revision as of 15:31, 18 June 2010



EclipseLink Native Query

In addition to JPQL, EclipseLink rich native DatabaseQuery and Expression criteria API.

For additional information on EclipseLink native queries, see Queries in the EclipseLink User's Guide.


Using JpaEntityManager createQuery() API

import javax.persistence.Query;
import org.eclipse.persistence.expressions.*;
import org.eclipse.persistence.queries.ReadAllQuery;
 
ExpressionBuilder builder = new ExpressionBuilder();
ReadAllQuery databaseQuery = new ReadAllQuery(Employee.class, builder);
databaseQuery.setSelectionCriteria(builder.get("firstName").like("B%"));
databaseQuery.addOrdering(builder.get("firstName").toUpperCase());
 
Query query = ((JpaEntityManager)entityManager.getDelegate()).createQuery(databaseQuery);
List result = query.getResultList();

Elug note icon.png

Note: The JpaEntityManager API was added in EclipseLink 1.1.

In EclipseLink 1.0, the JpaQuery method setDatabaseQuery() could be used.


Eclipselink-logo.gif
Version: DRAFT
Other versions...

Copyright © Eclipse Foundation, Inc. All Rights Reserved.