infinite loop performing a SQLTemplate query

From: Bryan Lewis (brya..aine.rr.com)
Date: Mon Jan 30 2006 - 19:32:12 EST

  • Next message: Andrus Adamchik: "Re: infinite loop performing a SQLTemplate query"

    I have some code that worked well in earlier versions of Cayenne (1.2M4
    or before) but now it goes into an infinite loop.

        String sql = "delete from Search_Data where UserName = 'joe'";
        SQLTemplate query = new SQLTemplate(Company.class, sql);
        dc.performQuery(query);

    The query is deleting all the rows from the user's previous search. In
    this case there are 20 rows.

    The code enters the performQuery() but never comes out. The log shows
    an infinite list of this message:

        [QueryLogger] === updated 20 rows.

    This archive was generated by hypermail 2.0.0 : Mon Jan 30 2006 - 19:32:22 EST