# The Second Best Way to Fetch a Spring Data JPA DTO Projection

DevFeed: [The Second Best Way to Fetch a Spring Data JPA DTO Projection](<https://devfeed.tech/articles/the-second-best-way-to-fetch-a-spring-data-jpa-dto-projection-28966.md>)

Original publisher: [Read original article](<https://blog.jooq.org/the-second-best-way-to-fetch-a-spring-data-jpa-dto-projection/>)

Author: lukaseder

Published: 2022-08-30T14:48:44Z

Content type: tutorial

Language: en

Sources: [jOOQ](<https://devfeed.tech/sources/jooq.md>)

Topics: [Code](<https://devfeed.tech/topics/code.md>), [Spring Boot](<https://devfeed.tech/topics/spring-boot.md>)

Tags: [code](<https://devfeed.tech/tags/code.md>), [dto-projection](<https://devfeed.tech/tags/dto-projection.md>), [jooq](<https://devfeed.tech/tags/jooq.md>), [jooq-in-use](<https://devfeed.tech/tags/jooq-in-use.md>), [nested-collections](<https://devfeed.tech/tags/nested-collections.md>), [repositories](<https://devfeed.tech/tags/repositories.md>), [spring-boot](<https://devfeed.tech/tags/spring-boot.md>), [spring-data-jpa](<https://devfeed.tech/tags/spring-data-jpa.md>)

## AI overview

The article presents jOOQ as a second way to implement a Spring Data JPA DTO projection. It shows value-constructor and aggregate-function approaches, emphasizing type-safe record conversion and reduced infrastructure code.

## Source excerpt

I've just stumbled upon this great post by Vlad Mihalcea, titled The Best Way to Fetch a Spring Data JPA DTO Projection. It got some nice traction on reddit, too. This is such a nice use-case and apt solution, I wanted to quickly show the second best way of doing the same, with jOOQ this ... Continue reading The Second Best Way to Fetch a Spring Data JPA DTO Projection ->