How to assign a native query result to a Pojo Class

Question

I am using JPA with hibernate in my project.

I came to a query where I need to join 6 tables. This will give 20 columns as a result.

My Entity classes are:

My pojo class is AggregateDetail which contain all the 20 variables that I will get from the native query.

Is there any way to implement this.

You may use CreateSQLQuery along with Result transformer to achieve this. https://stackoverflow.com/questions/55545239/get-value-from-java-lang-object-on-hibernate/55545543#55545543 — javapedia.net, Apr 10 '19 at 10:30
In that example InvoiceItems seems to be an Entity class. But I need to assingn the result to a non entity class — izaz, Apr 10 '19 at 18:24

score 0 · Answer 1 · answered Apr 10 '19 at 10:26

0

I think you can do this:

List<? extends Object> results=entityManager.createQuery("YOUR QUERY").getResultList();

Finally you can cast the result, of course after testing each object.

answered Apr 10 '19 at 10:26

Ismail

what does "?" means here – izaz Apr 11 '19 at 04:52
This means any class extends from Object, as you know all the classes in JAVA extends Object class, so this mean any class you want. – Ismail Apr 11 '19 at 08:13
Also you must know there a is difference between List extends Object> and List – Ismail Apr 11 '19 at 08:15

1 Answers1