Revisions to JPA : How to convert a native query result set to POJO class collection

Bounty Awarded with 50 reputation awarded by Sarabjeet

occurred Feb 29, 2016 at 12:07

added 463 characters in body

edited Jan 31, 2014 at 17:09

19.2k
7
54
69

JPA provides an SqlResultSetMapping that allows you to map whatever returns from your native query into an Entity or~~or a custom class~~.

EDIT JPA 1.0 does not allow mapping to non-entity classes. Only in JPA 2.1 a customConstructorResult has been added to map return values a java class.

Also, for OP's problem with getting count it should be enough to define a result set mapping with a single ColumnResult

JPA provides an SqlResultSetMapping that allows you to map whatever returns from your native query into an Entity or a custom class.

JPA provides an SqlResultSetMapping that allows you to map whatever returns from your native query into an Entity ~~or a custom class~~.

EDIT JPA 1.0 does not allow mapping to non-entity classes. Only in JPA 2.1 a ConstructorResult has been added to map return values a java class.

Also, for OP's problem with getting count it should be enough to define a result set mapping with a single ColumnResult

Source Link

answered Oct 22, 2012 at 14:16

Denis Tulskiy

19.2k
7
54
69

JPA provides an SqlResultSetMapping that allows you to map whatever returns from your native query into an Entity or a custom class.

Collectives™ on Stack Overflow

Return to Answer