Quering on multiple tables using criteria api

[Nrapendra Sharma]

Hi,
I have a contact entity which have a collection of communication

public class Contact{
private Set<Communication> communications;
private String firstName;
private String middleName;
}    

public class Communication{
private Contact contact;
private String value;
}

I want to search on firstName, middleName, and value(in communication)

I tried this:

 
public List searchContact(String searchText){
Criteria criteria = getSession().createCriteria(Contact.class,
		    "contact");
criteria.add(Restrictions.like("contact.firstName", searchText,MatchMode.ANYWHERE));
criteria.add(Restrictions.like("contact.middleName", searchText,MatchMode.ANYWHERE));
criteria.add(Restrictions.like("comm.value", searchText,MatchMode.ANYWHERE));

List results = criteria.list();
return results;
}

when i m executing this code i always get size of results 0

What wrong i am doing ??

[Cameron Wallace McKenzie]

I'm wondering if you need the contact. part?

For example, if I wanted to use a Restriction query on the following entity:

 
public class User {
  private Long id;
  private String loginName;
  private String password;
  private String encryptedPassword;
  private String emailAddress;
  private Boolean verified;
  private java.util.Date lastAccessTime;
  private java.util.Calendar registrationDate;

  @Id
  @GeneratedValue
  @Column(name = "id")
  public Long getId() { return id; }
  public void setId(Long id) { this.id = id; }
//..........
}

   

I wouldn't say user.id in my restruction, but just id"

Session session = HibernateUtil.beginTransaction();
Criteria criteria = 
      session.createCriteria(User.class);
criteria.add(Restrictions.gt("id", 5));
List results = criteria.list();
HibernateUtil.commitTransaction();
for (int i = 0; i<results.size(); i++) {
  System.out.println(results.get(i).toString());
}

The key part is this line:

criteria.add(Restrictions.gt("id", 5));    

A Simple Tutorial on Using the Hibernate Criteria API for Multiple Tables


Since the core class you are doing the restriction with is the contact class, I'm wondering if using the 'contact.' in front of your properties is causing a problem?

Regardless, start small. See if you can get it to work without any restriction. Get one filter field working, and then integrate the other two.

-Cameron McKenzie>

[Nrapendra Sharma]

i tried without contact. part its the same.
When i am adding restrictions on same table fields i.e firstName and middleName i am getting correct results.
As soon as i add restrictions on communication table i am getting 0 results.

I searched on google and found that i must use Disjunction beacause i need or operator in query.
this is the code

    
public void search(String searchText){
Criteria criteria = getSession().getCriteria(Contact.class).createAlias("communications","comm");
Disjunction dis = Restrictions.disjunction();
dis.add(Restrictions.like("contact.firstName",searchText, MatchMode.ANYWHERE));
dis.add(Restrictions.like("contact.middleName",searchText, MatchMode.ANYWHERE));
dis.add(Restrictions.like("contact.middleName",searchText, MatchMode.ANYWHERE));
dis.add(Restrictions.like("comm.value",searchText, MatchMode.ANYWHERE));
criteria.add(dis);
List results = criteria.list();
}

executing this i am getting results but i now getting duplicate records..
Any idea why ??