hibernate - Ejbql query with in in where clause -


i try query :

select x compteutilisateur x, mail m m.adresse = :param_mail , m in (x.listemail) 

i fails, query generated clause :

where compteutil0_.id=listemail2_.fk__compte__id  , listemail2_.fk__mail__id=mailimpl3_.id  , mailimpl1_.adresse=?  , (     mailimpl1_.id in (         .     ) ) 

what missing ? possible whant ? :)

in using sub query, try member of.

select x compteutilisateur x, mail m m.adresse = :param_mail , m member of x.listemail 

Comments

Popular posts from this blog

rest - Spring boot: Request method 'PUT' not supported -

java - WrongTypeOfReturnValue exception thrown when unit testing using mockito -

symfony - imagine_filter() not generating the correct url in LiipImagineBundle -