I am doing something like the next:
....
Criterion criterio2 = Restrictions.ilike("artiNombre", query, MatchMode.START);
ProjectionList proList = Projections.projectionList();
proList.add(Projections.property("artiNombre"),"artiNombre");
criterio.setProjection(proList);
criterio.setResultTransformer(Transformers.aliasToBean(Sene1Articulo.class));
......

It generates:

select
this_.ARTI_NOMBRE as y2_
from
sene1_articulos this_
where
and lower(y2_) like ?

And Oracle says: ORA-00904: "Y2_": identifier not valid.
I think its because Im using an alias in the ProjectionList for "artiNombre" and Iam using a condition for "artiNombre" too. How can I put a property in a Projection and use the same property like a condition in the select? is not possible for the alias?
Thanks

There is a JIRA issue raised on this http://opensource.atlassian.com/project ... e/HHH-5020