How to map JPA query results to a POJO?

Question

@Query("SELECT tt, at.field, at.anotherField from TableTest tt LEFT JOIN AnotherTable at ON at.commonField = tt.commonField")
List<TestPojo> findAllPojo(List<TableTestDTO> TableTestDTOList);

How can I map this JPA query results to a Pojo without native query, like this approach ?

I'm using JPA and Hibernate. Can anyone provide other option?

score 0 · Accepted Answer · answered Apr 23 '19 at 15:53

0

Try using the constructor:

@Query("SELECT new TestPojo(tt, at.field, at.anotherField) from TableTest tt LEFT JOIN AnotherTable at ON at.commonField = tt.commonField")
List<TestPojo> findAllPojo(List<TableTestDTO> TableTestDTOList);

Of course such constructor must exist and even better would be to place the fully qualified name instead of bare TestPojo.

answered Apr 23 '19 at 15:53

Andronicus

24,333
17
47
82

Thank you so much! – R. Pereira Apr 23 '19 at 17:04

score 0 · Answer 2 · answered Apr 23 '19 at 16:29

Well you can use the @SqlResultSetMapping annotation or you can create your own interface to reflect the query fields to it. You can find both examples here:Spring Data JPA map the native query result to Non-Entity POJO

You can call a constructor too, like @Andronicus said.

How to map JPA query results to a POJO?

2 Answers2