The problem with an alias com
in HQL. com.company.location.entities.Compte
has an incorrect meaning with this alias.
select com from Compte com where com.statuts="actif" and com.user=""+user+""
and com.pwd='"+pwd+"' "
+ "and com.personnels.id in (select p.id from Personnels p where statuts="actif"
Just change it to compte
select compte from Compte compte where compte.statuts="actif" ...
And, please, use the named query parameters
solved could not resolve property 3 [closed]