Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (athena.apache.org: domain of msabo@buk.cvut.cz designates
 147.32.104.6 as permitted sender)
Message-ID: <4B6EA67B.4030803@buk.cvut.cz>
Date: Sun, 07 Feb 2010 12:39:39 +0100
From: =?UTF-8?B?TWFyZWsgxaBhYm8=?= <msabo@buk.cvut.cz>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
 rv:1.9.1.7) Gecko/20100111 Lightning/1.0b1 Thunderbird/3.0.1
MIME-Version: 1.0
To: user@cayenne.apache.org
Subject: SQLResultMapping missing in RC2?
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Hi all,

I was using this chunk of code to return number of records in table:

	SQLTemplate sq = new SQLTemplate(User.class, "SELECT COUNT(id) C from User;");
        SQLResultSetMapping rsMap = new SQLResultSetMapping();
        rsMap.addColumnResult("C");
        sq.setResultSetMapping(rsMap);
        Long users = (Long) DataObjectUtils.objectForQuery(getObjectContext(), sq);


This code worked the whole way with cayenne 3 but after upgrade to rc2
(maven repo) the SQLResultSetMapping class is missing. Did you change
some workflow and added alternative to this? If so then please could you
provide it?
Anyway, I find this piece of code rather colossal for simple procedure
as count (I figure this is a common usecase) so is there an easier way
to work with aggreagate functions?

TIA,

--
Marek Šabo