hibernate jpa projection with @Query

Question

Most of the examples I've seen is using entityManager.createQuery or .createNativeQuery etc.

Is there a way to have something like the following working?

data class SummaryDto(val employeeName: String, val employerName: String)

@Query("select e.name as employeeName, emp.name as employerName " +
            "from Employer e " +
            "inner join Employee emp on emp.employer_id = e.id ", nativeQuery = true)
    fun findSummaries(): List<SummaryDto>

When I ran the above code

I got this error No converter found capable of converting from type [org.springframework.data.jpa.repository.query.AbstractJpaQuery$TupleConverter$TupleBackedMap] to type [dto.SummaryDto]

Can this be done with Kotlin or is there another way to get this to work with Hibernate JPA Annotation based?

Thanks Tin

Tin Ng · Accepted Answer · 2018-10-17 10:06:41Z

8

For anyone that might run into the same problem. Change SummaryDto to an interface like this

interface SummaryDto { val employeeName: String val employerName: String }

will work.

answered Oct 17, 2018 at 10:06

Tin Ng

1,0572 gold badges14 silver badges27 bronze badges

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

1 Comment

Sean Hwang Over a year ago

But why it works?

Collectives™ on Stack Overflow

hibernate jpa projection with @Query

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related