I would like to optimize the generated select of api criteria


With 2 tables


Criteria crit = this.getSession().createCriteria(T1.class);
crit.createCriteria(T2.class);
crit.add(Restrictions.eq(T2NAME,"TOTO"));


Api generate sql like:

SELECT T1.*,T2.* FROM T1 INNER JOIN T2 ON T1.C1=T2.C2 where T2.T2NAME = 'TOTO';

But how to specify to criteria to recover only one or more property into T1 objet

SELECT T1.C1, T1.C4 FROM T1 INNER JOIN T2 ON T1.C1=T2.C2 where T2.T2NAME = 'TOTO4;

i test setResultTransformer(Transformers.aliasToBean(target))

assuming that T1 and T2 are already joined i the mapping files, and that there is a property T1.getT2()



you can put this into an HQL query and treat the array of objects it returns