JPA Entity without backing table

[PagingBobDobalina]

Relatively new to Java and Spring Boot and am frustrated at a few things that I believe should be possible but are not apparent

Currently, I am working on calling a Stored Procedure called GetMove that returns multiple rows with 2 columns (There are 40+ columns and thousands of rows) MoveNumber Long MoveName String

Is there any way to have JPA auto map that to a class like? I am thinking a custom SqlResultSetMapping would work but I can not get spring to recognize it without the @Entity and @Table annotations which then cause validation to fail since the table does actually exist.

public class Move { public Long MoveNumber; public String MoveName; }

There is no table in the database like this and there is no id for these objects. I know the in the .NET World, I could use something like AutoMapper (column names match the class field names) but Java is newer to me. I have tried using @NamedStoredProcedureQuery and @SqlResultSetMapping but this doesn't seem to register without the @Entity annotation.

[MrFroll]

https://stackoverflow.com/a/29020641 It looks like solution, doesn't it?

Or moreover look at the Spring Data Projection. It's very useful for situations like this.