How to construct a list of Custom object directly from a jpql query (hibernate)

Question

I have the two following custom object

public class customDataObject_1 {
    private String number;
    private List<PartnerData> partnersDatas;
    private List<customDataObject_2> custom_list_2;
}
and 
public class customDataObject_2 {
    private String property1;
    private String property2;
    private String property3;
    private DataObject1 dataObject1;
    private DataObject2 dataObject2;
    private DataObject3 dataObject3;
}

In JPQL, I can get the following list of object Array: List by a query that is alike

String queryString = select orderNo, new package1.PartnerData(-), new package2.customDataObject_2(-,-,-,-,-,-) from -,-,-,- where ------;

After a java treatment I can get from the result of the request the following result: List#customDataObject_1#.

My question is: is it possible to get, without a java treatment, directly from a JPQL request the previous result, that is List#customDataObject_1# and if it is possible, how

Simon Martinelli · Accepted Answer · 2020-01-07 11:17:08Z

1

No you can't.

The result of a SQL query is always a table. So cannot get nested tables inside the result.

answered Jan 7, 2020 at 11:17

Simon Martinelli

36.6k6 gold badges62 silver badges92 bronze badges

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

Collectives™ on Stack Overflow

How to construct a list of Custom object directly from a jpql query (hibernate)

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