Re: Returning updated rows from SQLTemplate

From: Michael Shea (mik..itido.com)
Date: Thu Sep 11 2008 - 11:59:32 EDT

  • Next message: Andrus Adamchik: "Re: Returning updated rows from SQLTemplate"

    int[] updateCounts = context.performNonSelectingQuery( query );

    =).

    Mike Shea.

    > Hello !
    >
    > I use Cayenne 3.0M4 and since UpdateQuery is deprecated i use a
    > SQLTemplate query to do an UPDATE.
    > The thing is i would like to know how many rows are updated, and the
    > query returns no DataRows.
    >
    > SQLTemplate query = new SQLTemplate(..., "UPDATE...");
    > query.setFetchingDataRows(true);
    >
    > List<DataRow> dtList = context.performQuery(query);
    >
    > the returned list is always empty....
    > How can i get the precious Integer saying "X rows updated" ?
    >
    > Thanks.
    > Laurent Marchal.
    >
    >

    This archive was generated by hypermail 2.0.0 : Thu Sep 11 2008 - 12:00:18 EDT