RE: One more query

From: Gentry, Michael \(Contractor\) ("Gentry,)
Date: Thu Mar 17 2005 - 17:43:23 EST

  • Next message: Hogue, Brian: "weird log entries"

    In addition to what Andrus said, if you are fetching raw rows, the first
    parameter might seem useless, but it is actually used by Cayenne to
    determine which DataNode (and therefore database connection -- important
    when you are using more than one database) to use to perform the fetch.
    So, it isn't crucial which ObjEntity to specify for the first parameter
    when fetching raw rows, as long is it is in the correct DataNode/DB.
    I'd almost prefer another constructor which could take a DataNode as the
    first parameter, since that makes more sense (and would default the
    query to raw rows then).

    So, in your example, "Irf.class" is informing Cayenne which DB to
    access, even though you aren't returning objects of "Irf". Be sure you
    fetch raw rows:

    selectQuery.setFetchingDataRows(true);

    /dev/mrg

    -----Original Message-----
    From: Fredrik Liden [mailto:flide..ranslate.com]
    Sent: Thursday, March 17, 2005 3:45 PM
    To: cayenne-use..bjectstyle.org
    Subject: One more query

    Can I use agregates like sum in an SelectQuery?

    Or should I use the SQLTemplate? One question regarding the SQLTemplate.

    Does it matter what the first parameter is? I mean since the query
    returns raw data. Oh, and what's the third parameter?

    SQLTemplate selectQuery = new SQLTemplate(Irf.class,"select
    description,sum(amount) from irf_entry group by description",true);

    Thanks!

    /Fredrik

    This archive was generated by hypermail 2.0.0 : Thu Mar 17 2005 - 17:43:28 EST