Getting the Data as a CSV file directly instead of a List of object from spring-data-jpa

Question

Is it possible to get the data from spring-data JPA in the form of CSV data instaed of ArrayList of pojos like

Below is the interface extending JpaRepository.

public interface FactAggRepository extends JpaRepository<FactAggRepository,Integer> {

@Query("select p from FactAggRepository as p where p.pId=:pId and p.periodStart=:periodStart")
public List<FactAggRepository> getAggregates(@Param("pId") Long pId,@Param("periodStart")LocalDateTime periodStart);

@Query("select p from UsageAgg as p where p.pId=:pId")
public List<UsageAgg> UsageAggregates(@Param("pId") Long pId);

}

Autowiring the repository to use the same methods as follows.

fetchedRecord = AggRepo.getAggregates(pId, periodStart);

Now the above the code returnd the List. Is it possible to get the CSV file with the data in the List without any conversion.please let me know. Thanks in advance.

Jens Schauder · Accepted Answer · 2021-03-02 10:50:45Z

1

Spring Data is here to handle communication with data sources layers. Unfortunately, CSV is not a data store handled natively.

You have to use a third-party dependency such as OpenCSV to transform those POJOs to CSV.

edited Mar 2, 2021 at 10:50

Jens Schauder

82.6k35 gold badges199 silver badges379 bronze badges

answered Feb 14, 2020 at 10:11

Hassam Abdelillah

2,3143 gold badges18 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting the Data as a CSV file directly instead of a List of object from spring-data-jpa

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related