This looks like a bug with Hibernate Transformers. Hibernate is creating bad query when using transformers:

Here's an example:
criteria.setProjection(Projections.projectionList(). add(Projections.property("field1"), "dtoField"). setResultTransformer(new AliasToBeanResultTransformer(TestDTO.class));

Here's the query being generated:
select this_.FIELD1 as y0_ from TESTDB this_
where y0_ = 'test'

Hibernate is using y0_ alias instead of this_.FIELD1 and this doesn't run.

Anyone with the same problem???? Is there a way to disable aliases???


Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html