Hi everbody

Using Hibernate 3 with XML mappings.

Say, there is a "Project" object referencing "Information" objects like

<set name="listOfInformation" table="information">
<key column="project_id"/>
<one-to-many class="Information"/>
</set>

Information looks like
..
<property column="language" name="language" type="string"/>
<property column="title" name="title" type="string"/>
..

Projects may have n Information children, but only one for a given language. Language and project form a unique key in information-table.

In most cases I need the complete bunch of Information children, but sometimes I want to find, say the project title in a certain language.
Now, I need to dynamically set up a Criteria query resulting in a Object[]-Array where I'm not getting an entity, thus eliminating accessing entity methods that could help me.

Question:
Is there any way of setting up a Criteria query resulting in a SQL like

select p.field1, p.field2, i.title
from project
left join information on (p.project_id=i.project_id and i.language='EN');

?
This is what I meant by "with additional restriction" in headline.

Thank for your time trying to understand and help me.
Best regards,
Claus.

Yes, it was added in 3.5 for the Criteria and I submitted a patch for the DetachedCriteria side of things. (I'm not sure if it got into a release as of yet).

public Criteria createAlias(String associationPath, String alias, int joinType, Criterion withClause)

Thank you, VampBoy. I would have to switch over to 3.5. In the meanwhile I found an alternative solution which offers even more flexibility. But it's good to know, that there would be that option, too.

Kind regards and many thanks
Claus.

Does anyone can give me an example of this method. I have written like this:

for sql:
FROM Promo
LEFT JOIN Users ON Users.ID = Promo.ID AND Users.MemberID=$this->memberID

I wrote:
.createAlias("users", "dpu", Criteria.LEFT_JOIN, Restrictions.eq("dpu.memberId", user.getMemberId()))

is that correct? it seems not because an exception is occured like NoSuchMethodError..

Try this: