Eclipse Community Forums: EclipseLink » I must be missing something!

Home » Eclipse Projects » EclipseLink » I must be missing something!

I must be missing something! [message #383029]

Mon, 17 November 2008 13:45

Eclipse User

This always returns all of the rows in the table. There are only a couple
of rows where departmentId is equal to 1.

What did I miss?

public List<Employee> getEmployees( Employee criteria, int page,
int limit ) throws Exception
{
ReadAllQuery query = new ReadAllQuery(Employee.class);
ExpressionBuilder eb = query.getExpressionBuilder();
eb.get("departmentId").equal( 1 );
query.setSelectionCriteria(eb);
query.refreshIdentityMapResult();
List employees = (List) session.executeQuery(query);
return employees;
}

Re: I must be missing something! [message #383033 is a reply to message #383029]

Tue, 18 November 2008 08:25

Eclipse User

The line:

eb.get("departmentId").equal( 1 );

creates an expression object that you need to set into the selection
criteria. The ExpressionBuilder is a factory for these expressions. If you
re-write your code as:

> public List<Employee> getEmployees( Employee criteria, int page,
> int limit ) throws Exception
> {
> ReadAllQuery query = new ReadAllQuery(Employee.class);
> ExpressionBuilder eb = query.getExpressionBuilder();
> Expression exp = eb.get("departmentId").equal( 1 );
> query.setSelectionCriteria(exp);
> query.refreshIdentityMapResult();
> List employees = (List) session.executeQuery(query);
> return employees;
> }

It should work for you.

Doug

Previous Topic:	EJBQL translaltion problem
Next Topic:	PostLoad on a new instance?

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Jul 21 22:32:11 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter