Hibernate Community • View topic - alias non root entities in SQL Criteria

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

alias non root entities in SQL Criteria

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

jtowell

Post subject: alias non root entities in SQL Criteria

Posted: Sat Feb 20, 2010 2:49 pm

Newbie

Joined: Tue Oct 28, 2003 4:43 pm
Posts: 13

Is there support for this yet?

http://opensource.atlassian.com/project ... e/HHH-2952

It looks like the bug was quickly rejected, but I think the issue still exists correct?

The problem is if you are using Criteria and have a join and you want to do a SQL projection or SQL group projection for example

Code:

Projections.sqlGroupProjection("month(dateCreated)")

It's possible that "dateCreated" is defined on both the root and join subquery table. And the generated SQL will fail because of this ambiguous reference.
To get the "dateCreated" on the root entity you would do

Code:

Projections.sqlGroupProjection("{alias}.month(dateCreated)")

This works. But how do you get the "dateCreated" on the joined table?

Top

jtowell

Post subject: Re: alias non root entities in SQL Criteria

Posted: Wed Feb 24, 2010 8:29 pm