hi, i have two tables, similar to the classic Products and Departments, where a field in the first table is a foreign key for the other table.
the tables are generated using myeclipse 6.5 tools.
I need to make a list of all the products for the same departments, and i'm trying using the findbyexamples method this way

ProductsDAO prodDao = new ProductsDAO();
DepartmentsDAO depDao = new DepartmentsDAO();

Departments exampleDep = depDao.findById(departmentId);

Products example = new Products();
example.setDepartments(exampleDep);

List<Products> record = prodDao.findByExample(example);

but i have a problem: whatever value i use for departmentid, all the records are returned, but the data are stored correctly.
how can i solve this problem?

best regards,
luca morelli

can you write your query string used in prodDao.findByExample(example).

public List findByExample(Departments instance) {
log.debug("finding Proucts instance by example");
try {
List results = getSession().createCriteria("Departments").add(
Example.create(instance)).list();
log.debug("find by example successful, result size: "
+ results.size());
return results;
} catch (RuntimeException re) {
log.error("find by example failed", re);
throw re;
}
}

this is the method generated by myeclipse

Don't use example queries, because it says in the documentation that it ignores any references:



right here:

http://www.hibernate.org/hib_docs/core/ ... a-examples

But it should work with a eq Restriction.

Don't use criteria.
You have two pojos as Products and Departments.
In Products pojo you have the reference of Departments table like below :-

public class Products
{
Departments department = null;
// any more attributes
// you have the setters getters for all the attributes including department
}




Try to execute below function:-
public List findByExample(Departments instance) {


Query query = getSession().createQuery(" from Products where Products.getDepartmet.getDepartmentId()=?");
query.setParameter(1,new Long(instance.getDepartment().getDepartmentid()));
List results = query.list();
Iterator itr = results.iterator();
Products prod = null;
while(itr.hasNext())
{
prod = (Products) itr.next();
// here you will get the desired o/p
}
}
}

if still you have facing problem, then let me know..