Is there a way to return collection instead of entity in @Repository's @Query

Question

I have a query:

@Query(
    value = "select name, age, now() from received.scheme ;", 
    nativeQuery = true

)
public {???} selectData()

I cannot create or return an entity for such a scheme as there is no natural id in it, so is there a way to return something like List<Triple<String, Int, LocalDateTime>>?

Does [this answer](https://stackoverflow.com/a/52666044/1505146) help? — Tasos P., Apr 18 '22 at 11:00
Is it helpfull https://stackoverflow.com/questions/23122846/query-returning-object-instead-of-entity? — surendrapanday, Apr 18 '22 at 11:08

score 0 · Answer 1 · answered Apr 18 '22 at 12:37

0

you can create another class with the required properties which you want to retrieve from the database and then you can return that class as List<Class>.

answered Apr 18 '22 at 12:37

rg226965

61
2

score 0 · Answer 2 · answered Apr 18 '22 at 20:19

In your code you get the data from: scheme So the Entity SchemeEntity should contains those three fields:

name
age
now (creationDate for example it depend on your logic)

Then your method should be like this:

@Query(value = "select name, age, now() from received.scheme ;", 
    nativeQuery = true
)
public List<SchemeEntity> selectData();

score 0 · Answer 3 · answered Apr 19 '22 at 03:04

0

You can provide a PROJECTION entity which will have 3 attributes and must provide a parametrized constructor with those 3 attributes you want to fetch ,or you can still get them as a List<Object[]> and then hydrate your entity.

answered Apr 19 '22 at 03:04

karim farhouti

310
1
7

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Apr 19 '22 at 11:53

score 0 · Answer 4 · edited Apr 24 '22 at 19:32

0

I've tried those things but what worked for me is using ctid as an @Id. Since I only needed some sort of a mock id, it worked fine.

edited Apr 24 '22 at 19:32

Jhanzaib Humayun

1,193
1
4
10

answered Apr 23 '22 at 20:40

ruslan agaev

13
4

Is there a way to return collection instead of entity in @Repository's @Query

4 Answers4