Hello, i have a little troble with Hibernate.
In my query I have these Criteria "c":

c.add(Restrictions.ne("codClasse", "49"));
c.add(Restrictions.ne("codClasse", "51"));

When it runs i get: ORA-00904: "Y5_": invalid identifier
And the logged SQL query is:

select distinct this_.COD_BANCA as y0_, this_.DESC_BANCA as y1_, this_.COD_ENTITA as y2_, this_.INTESTAZIONE_MEDIA as y3_, this_.COD_ENTITA_PADRE as y4_, this_.COD_CLASSE as y5_ from MYTABLE this_ where this_.COD_ENTITA_PADRE like ? and this_.FLAG_AUT_CONT like ? and this_.COD_CLASSE_PADRE like ? and not y5_ like ? and not y5_ like ? and this_.COD_TIPOL_UO in (?, ?, ?, ?)

As you can se in the restrictions is used the column alias (y5_) intead of the column name like in the other restrictions... why?
Thank you.

I found the cause, i report this just if someone else will find the same problem.

The trouble was the projection with the same name as the Entity propertyName:

c.add(Restrictions.ne("codClasse", "49"));
c.add(Restrictions.ne("codClasse", "51"));
...
projList.add(Projections.property("codClasse"), "codClasse");

Changing the projection variable (or the entity property) i solved:

c.add(Restrictions.ne("codClasse", "49"));
c.add(Restrictions.ne("codClasse", "51"));
...
projList.add(Projections.property("codClasse"), "classe");

I hope it will be useful... i spent a morning for this!

I am having the same issue here.
Isn't anyone going to file a bug for this?
Definitely it is a bug as it is not stated in any part of the docs that this isn't allowed and it does not seem that unusual to project a field on a bean property with the same name.
Strangely enough ppl tried to file bugs and they got rejected even though later on it was clearly stated on the bug reports the way to reproduce the error:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1685
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2847

Tobia,

There is an uglier hack that can be applied in the meantime. Suppose your entity is called MyEntity, you should do a createCriteria(MyEntity.class, "this") and then change the restrictions to have this prefix and letting the projection without the prefix:

c.add(Restrictions.ne("this.codClasse", "49"));
c.add(Restrictions.ne("this.codClasse", "51"));
...
projList.add(Projections.property("codClasse"), "codClasse");

Thanks rafaelri,
I think your way is better, i will try it!