Nested JPA projection using custom query

Question

I'm new to Spring Data projection and I'm trying to use this feature in a new project.

In particular I'd like to use projections on a repo method associated to a complex query.

I annotated my method with the @Query annotation and declared a JPA query with several joined tables/entities and a complex where condition.

In this article I read that is possible to use an interface-based projection and a class-based projection, but only the first one supports nested projections.

I need nested projection but it seems that this feature is only supported using interface-based projections, and this approach is only possible with auto-generated query methods and not using explicit JPA queries. Is this right?

Is there a way to use interface-based projections using custom JPA queries?

Chaosfire · Accepted Answer · 2022-03-16 09:36:38Z

4

You can use interface projections with custom queries. If this is the interface:

public interface MyView {

  int getCount();
  String getName();
}

Then you can make a query like this:

@Repository
public interface MyRepository extends JpaRepository<Entity, Long> {

  @Query("SELECT e.some_count AS count, e.name FROM Entity AS e WHERE e.id IN :ids")
  List<MyView> findViews(List<Long> ids);
}

Interface projections work with custom queries, be it JPA or native. Just the column name must match method name, as in example. I have not used nested projections yet, but i don't see a reason why they wouldn't work.

Also found this question about nested projections, which should help.

answered Mar 16, 2022 at 9:36

Chaosfire

7,1094 gold badges11 silver badges31 bronze badges

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

Comments

ouflak · Accepted Answer · 2022-03-16 18:32:24Z

0

You can use Hibernate ResultTransformer. This article from Vlad mihalcea presents an example of how to customize result set mappings.

edited Mar 16, 2022 at 18:32

ouflak

2,56310 gold badges46 silver badges53 bronze badges

answered Mar 16, 2022 at 15:02

Bessem Manita

2201 silver badge6 bronze badges

1 Comment

Philippe Over a year ago

This is now deprecated. See docs.jboss.org/hibernate/orm/6.0/javadocs/org/hibernate/…. Use TupleTransformer and/or ResultListTransformer instead.

Collectives™ on Stack Overflow

Nested JPA projection using custom query

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related