Can we use JPA Repository to pull/fetch data from Mysql View? If yes How?

Question

I have many tables where I am using JPARepository to fetch data from it. Then I have created on MySql - View and tried to use JPARepository to do findAll but it is not working.

Answer 1

You can use a native query and a DTO projection:

public interface ReportRepository extends JpaRepository<SomeEntity, Long> {

   @Query(nativeQuery = true, value = "SELECT * FROM yourView")
   List<YourDto> getDateFromYourView();

}