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/UserGuide/JPA/Basic JPA Development/Querying/Native"
< EclipseLink | UserGuide | JPA | Basic JPA Development | Querying
m (→EclipseLink Native Query) |
m (→EclipseLink Native Query) |
||
Line 38: | Line 38: | ||
{{EclipseLink_JPA | {{EclipseLink_JPA | ||
|previous= [[EclipseLink/UserGuide/JPA/Basic_JPA_Development/Querying/Criteria|Criteria]] | |previous= [[EclipseLink/UserGuide/JPA/Basic_JPA_Development/Querying/Criteria|Criteria]] | ||
− | |next=[[EclipseLink/UserGuide/JPA/Basic_JPA_Development/ | + | |next=[[EclipseLink/UserGuide/JPA/Basic_JPA_Development/Query Hints|Query Hints]] |
|up=[[EclipseLink/UserGuide/JPA/Basic_JPA_Development/Querying|Querying]] | |up=[[EclipseLink/UserGuide/JPA/Basic_JPA_Development/Querying|Querying]] | ||
}} | }} |
Revision as of 11:34, 18 June 2010
EclipseLink Native Query
In addition to JPQL, EclipseLink rich native DatabaseQuery and Expression criteria API.
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();
Note: The JpaEntityManager API was added in EclipseLink 1.1.
In EclipseLink 1.0, the JpaQuery method setDatabaseQuery() could be used.