matching row is missing error

[Frank <fa...@hotmail.com>]

Hi Andrus,

I am not sure if this is a Click or Cayenne problem.

I have a two table relation defined and am getting an error when a matching
record is not found in the second table.
This works fine until I do a search that does not have a matching row.

Here is my query:

     DataContext context = DataContext.getThreadDataContext();
     Integer[] hspArray = {new Integer(1), new Integer(5)};
     Expression e = ExpressionFactory.inDbExp(Bsypemp.EMHSPPOUND_PK_COLUMN,
hspArray);
        e =
e.andExp(ExpressionFactory.likeIgnoreCaseExp(Bsypemp.EMYLNM_PROPERTY, lname
        +"%"));
        e =
e.andExp(ExpressionFactory.likeIgnoreCaseExp(Bsypemp.EMYFNM_PROPERTY, fname
                +"%"));

     SelectQuery query = new SelectQuery(Bsypemp.class,e);
     List records = context.performQuery(query);
     return records;


 column = new Column("departments.Pcldds");
        column.setHeaderTitle("Department");
        column.setWidth("15%;");
        column.setAttribute("align", "left");
        column.setSortable(true);
        table.addColumn(column);

Caused by: org.objectstyle.cayenne.FaultFailureException: [v.1.2.2 January
10 2007] Error resolving fault for ObjectId: <ObjectId:Bprppcp, PCDEP4=0,
PCHSP#=5> and state (transient). Possible cause - matching row is missing
from the database.


Thanks
Frank