Re: Returning updated rows from SQLTemplate

From: Laurent Marchal (biguphp..mail.com)
Date: Mon Sep 15 2008 - 10:41:21 EDT

  • Next message: Michael Gentry: "Re: Cayenne, XML objects and JDBC 4"

    Hi Andrus,

    Sorry i think i have a problem with my internet provider which seems
    block emails coming from this list !
    I will use the archives until all is ok. Sorry all for the spam !

    Andrus Adamchik wrote:
    > 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:42:58 EDT