This discussion is archived
2 Replies Latest reply: Mar 20, 2013 6:10 PM by 997917 RSS

Null values in coherence -3.7.1

997917 Newbie
Currently Being Moderated
Hi,

I have a rather naive question about the EqualsFilter usage.
Let's say I have an table with 3 columns: EmployeeId (key), EmployeeName and EmployeeAddress where some of the address column values are empty.
A SQL query to get the employee names that have null addresses would look like this:
"select * from Employee where EmployeeAddress is NULL".

If I try to model this in Coherence , I would have EmployeeId as the key and an Employee object as the value.
I am loading the table from Oracle11g into Coherence.
How can I use an EqualsFilter to give me the same results as the SQL query above ?
Should it just be EqualsFilter as : employeeCache.entrySet( new EqualsFilter(AddressExtractor,null) );

I am trying to do the remote invocation of the filters.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points