aspose file tools*
The moose likes Object Relational Mapping and the fly likes Quering on multiple tables using criteria api Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Quering on multiple tables using criteria api" Watch "Quering on multiple tables using criteria api" New topic
Author

Quering on multiple tables using criteria api

Nrapendra Sharma
Ranch Hand

Joined: Jun 16, 2008
Posts: 31
Hi,
I have a contact entity which have a collection of communication



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

I tried this:


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

What wrong i am doing ??


Regards,
Nrapendra Sharma
Cameron Wallace McKenzie
author and cow tipper
Saloon Keeper

Joined: Aug 26, 2006
Posts: 4968
    
    1

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

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



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



The key part is this line:



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
Ranch Hand

Joined: Jun 16, 2008
Posts: 31
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


executing this i am getting results but i now getting duplicate records..
Any idea why ??
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Quering on multiple tables using criteria api