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

From Eclipsepedia

Jump to: navigation, search
m (EclipseLink Native Query)
m (EclipseLink Native Query)
Line 5: Line 5:
 
{{EclipseLink_API
 
{{EclipseLink_API
 
|api=
 
|api=
*org.eclipse.persistence.queries
+
*[http://www.eclipse.org/eclipselink/api/org/eclipse/persistence/queries/package-frame.html org.eclipse.persistence.queries]
*org.eclipse.persistence.expressions
+
*[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''.
  
  
See:
 
* [http://www.eclipse.org/eclipselink/api/1.1/org/eclipse/persistence/queries/package-frame.html org.eclipse.persistence.queries]
 
* [http://www.eclipse.org/eclipselink/api/1.1/org/eclipse/persistence/expressions/package-frame.html org.eclipse.persistence.expressions]
 
* [[EclipseLink/UserGuide/Queries_(ELUG)|Queries]] in the ''EclipseLink User's Guide''
 
  
 
=== Using JpaEntityManager createQuery() API ===
 
=== Using JpaEntityManager createQuery() API ===

Revision as of 13:48, 16 June 2010

EclipseLink Native Query

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


Elug api package icon.png Key API {{{apis}}}

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...