I'm putting together a demo for my coworkers to show them why we should move our mixed EJB 1.1/EJB 2.1 app to hibernate during our JBoss conversion. Part of this demo will be a QBE demo.

I have three simple classes:

Person
String firstName
String lastName
Set addresses (relates to Address)
Email email (relates to Email )

Address
String line1, line2 etc...

Email
String email ...


Using QBE, it was shockingly easy to get a simple AND scenario setup:

Person p = new Person();
p.setFirstName("D");

Address a = new Address();
a.setCity("St");

Email e = new Email();
e.setEmail("dc");

Example personExample = Example.create(p)
.ignoreCase()
.enableLike(MatchMode.START);

Example addressExample = Example.create(a).ignoreCase().enableLike(MatchMode.START);

Example emailExample = Example.create(e).ignoreCase().enableLike(MatchMode.START);


//create a criteria based on a person
Criteria personCriteria = session.createCriteria(Person.class).add(personExample);

//add an address criteria, using the name of the property this is related to
personCriteria.createCriteria("addresses").add(addressExample);

//add an email criteria, using the name of the email property
personCriteria.createCriteria("email").add(emailExample);


The query this creates is perfect for matching ALL properties.

Now, what I'd like do do is create a Disjunction on addresses and email, so it will return objects that macth the properties of Person AND (the properties of Address OR the properties of Email).

Can this be done only using QBE?
Thanks,
Dave Cracauer

org.hibernate.criterion.Disjunction

I have tried using Disjunction, and am not able to make it work using the Example object I created.

When I do this:

Junction dis= Expression.disjunction().add(addressExample).add(emailExample);

Criteria personCriteria = session.createCriteria(Person.class).add(personExample).add(dis);

Hibernate throws a net.sf.hibernate.PropertyAccessException

I assume this is because it is looking for the Address and Email properties (in the Example object, in the Disjuction) on the Person object.

I can't figure out how to properly create a Disjunction of two Example objects that are properties of another object.


Thanks,
Dave

hmm - without being the biggest Critiera wizard then try looking
into createAlias() to allow referring to more than one thing.

Also look at CriteriaQueryTest for inspiration.

I am having the same problem.

I need to create a disjunction of subqueries. You can only add Criterion (not Criteria) to a disjunction.

Let me know if you figure out how to do that with aliases.

Thanks,
gabe

is this really the case?

I too need to create a disjunction between two criteria. It appears impossible using the criteria API because the disjunction (or the Restrictions.or) will only take criterion.

Would be interested in any feedback.

What about rewriting the subquery using Subqueries.exists ? It returns a Criterion.