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.
Difference between revisions of "EclipseLink/UserGuide/JPA/Basic JPA Development/Querying/Native"
< EclipseLink | UserGuide | JPA | Basic JPA Development | Querying
m |
|||
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/Query Hints|Query Hints]] | + | |next=[[EclipseLink/UserGuide/JPA/Basic_JPA_Development/Querying/Query Hints|Query Hints]] |
|up=[[EclipseLink/UserGuide/JPA/Basic_JPA_Development/Querying|Querying]] | |up=[[EclipseLink/UserGuide/JPA/Basic_JPA_Development/Querying|Querying]] | ||
|version=2.2.0 DRAFT}} | |version=2.2.0 DRAFT}} |
Revision as of 09:19, 13 January 2011
EclipseLink JPA
EclipseLink | |
Website | |
Download | |
Community | |
Mailing List • Forums • IRC • mattermost | |
Issues | |
Open • Help Wanted • Bug Day | |
Contribute | |
Browse Source |
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();
Note: The JpaEntityManager API was added in EclipseLink 1.1.
In EclipseLink 1.0, the JpaQuery method setDatabaseQuery() could be used.