wood burning stoves 2.0
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 OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 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: http://aspose.com/file-tools
subject: Criteria createAlias with addtional restrictions
It's not a secret anymore!