Hibernate generates Alias in Where clause

phoenixvn · **Joined:** Mon Nov 30, 2009 5:16 am **Posts:** 2

Hi all,

I have problem when trying to make a query with HibernateCriteria. Without a projection, everything went fine. However, when I applied a projection on the criteria, the query failed because Hibernate generated a query with alias (same as specified in the projection) in WHERE clause. Has anyone faced this? If yes, could you please point me out how to solve this?

Thanks a lot,

phoenixvn · **Joined:** Mon Nov 30, 2009 5:16 am **Posts:** 2

Hi,

I finally managed to do it by not using any Restrictions and it worked for now.

Cheers,

yvangkwheng · **Joined:** Mon Nov 30, 2009 10:13 pm **Posts:** 5

congratulations!u r a so smart.

sreedhargattu · **Joined:** Thu Sep 16, 2010 11:16 am **Posts:** 1

phoenixvn wrote:

Hi,

I finally managed to do it by not using any Restrictions and it worked for now.

Cheers,

How did you manage it?