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 32 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,082,665
372
3,610
3,555

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