Hibernate Criteria Query Issue with Projection and restriction

If you are using Hibernate 3.2.6, 3.0.5, 3.5.5, 3.6.0.Beta3 then it's time for migrating to newer version of Hibernate.

Reported bug: Criteria Query Issue with Projection and restriction

Link: https://hibernate.atlassian.net/browse/HHH-3371

Affects Version/s: 3.2.6 3.0.5, 3.5.5, 3.6.0.Beta3

Component/s: query-criteria

Fix Version: 3.6.0.Beta4 and above.

I believe you're using the outdated version of hibernate.

The issue is addressed and resolved for a long time:

https://hibernate.atlassian.net/browse/HHH-817

Fixed version: 3.6.0.Beta4