matching row is missing error

From: Frank (farocc..otmail.com)
Date: Wed Feb 14 2007 - 13:41:18 EST

  • Next message: Juergen Saar: "Re: OutOfMemoryErrors (solved)"

    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

    This archive was generated by hypermail 2.0.0 : Wed Feb 14 2007 - 13:41:50 EST