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 in the where clause 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

transformers does not change the query.

This may not be directly related to Transformers, but Hibernate in general. Why Hibernate is using column alias for where clause comparision? I don't think this is standard query. This may work with SQL Server but doesn't work with DB2. What's the solution to this problem??? Can column alias be disabled somehow???

look in jira - existing bugs/feature requests for it.

Is this a known bug? You have bug ID? Thanks.

no, not on hand. use the search ;)