Is it possible to run a query for construct an object with list<>

Asked Aug 06 '19 at 09:00

Active Aug 26 '19 at 09:58

Viewed 28 times

I'm trying to find a way to create an object from a query, this object is containing three int fields and a List<>

@AllArgsConstructor
@Data
public class SiteDescriptionDao {

    private int        hauteurMax;
    private int        cotMin;
    private int        cotMax;
    private List<Voie> voieList;

}

my 'actual' query is :

SELECT new com.c.c.c.dao.SiteDescriptionDao(1,1,1,(select vo from Voie vo where vo
.idSecteur = 1)) FROM Site si

Thanks for your help !

edited Aug 26 '19 at 09:58

BalusC

1,040,783
362
3,548
3,513

asked Aug 06 '19 at 09:00

Joffrey Bonifay

1

Possible duplicate of https://stackoverflow.com/questions/2355728/jpql-create-new-object-in-select-statement-avoid-or-embrace – Jaume Morón i Tarrasa Aug 06 '19 at 09:22
It's not possible to return a list in an row of a query. – Simon Martinelli Aug 06 '19 at 14:30
Possible duplicate of [JPQL: Receiving a Collection in a Constructor Expression](https://stackoverflow.com/questions/5998409/jpql-receiving-a-collection-in-a-constructor-expression) – Simon Martinelli Aug 06 '19 at 14:30

Is it possible to run a query for construct an object with list<>

0 Answers0