Re: Returning updated rows from SQLTemplate

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Mon Sep 15 2008 - 10:26:12 EDT

  • Next message: Laurent Marchal: "Re: Returning updated rows from SQLTemplate"

    Hi there! This is the 3rd copy of the same message that got sent to
    the list. So I assume you are not getting our replies via the list?
    There were replies to both of your messages, please check the archives
    here: http://cayenne.markmail.org/search/

    Also note that your smaeur.com address is subscribed, so you should be
    getting replies at that address, while gmail.com address is NOT
    subscribed.

    Thanks,
    Andrus

    On Sep 15, 2008, at 5:11 PM, Laurent Marchal wrote:

    > 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 : Mon Sep 15 2008 - 10:26:47 EDT