Revision history [back]
 | 1 | initial version |
In the ORM.xml file, define a named-native-query and specify the SQL statement to be executed.
Define the Projection interface with the required getters for the columns that need to be returned.
Create a ProjectionList by adding Projections to it for each column that needs to be returned.
Use the createNativeQuery method of EntityManager to create a Query object from the named-native-query.
Apply the ProjectionList to the Query object using the setProjection method.
Execute the query using the getResultList method of the Query object.
The results of the query will be returned as a list of Projection objects. Each Projection object will contain the values of the selected columns as returned by the database.