File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes Criteria createAlias with addtional restrictions Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Criteria createAlias with addtional restrictions" Watch "Criteria createAlias with addtional restrictions" New topic

Criteria createAlias with addtional restrictions

Ka Erol

Joined: Feb 19, 2013
Posts: 3

I'm looking for solution how to add additional restriction do left outer join.

Actually I'm using:
crit.createAlias(VcInternalMail.PROPERTY_COMPANIES_RECIPIENT, "imc", CriteriaSpecification.LEFT_JOIN).add(Restrictions.eq("imc.idCompany", companyList));

But this give me restriction in where clause.

I want to get something like that
left outer join vc_internal_mail_company imc on imc.idInternalMail = this_.idInternalMail and imc.idCompany in (13)

Is it possible with Criteria ?

Kind regards
Karol R.
I agree. Here's the link:
subject: Criteria createAlias with addtional restrictions
jQuery in Action, 3rd edition