Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (herse.apache.org: domain of mkienenb@gmail.com designates
 64.233.184.231 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=NMTJQOGsab0djsobfh84Y7ku1VtiIE569zz46sFryN65koe7nenHvqr0WuH2Q8J6Cc1nq328WV0zd5Bvsj9TSgIiS55PjSofyUzVh30jBa85QzvSzWqmXdYonKojPWee79QpoRW4I9JyjgkleguVZJ3Y/xeokQEp3wR5yVpnAmA=
Message-ID: <8f985b960703230813w177589f8qec3e268ed6313911@mail.gmail.com>
Date: Fri, 23 Mar 2007 10:13:27 -0500
From: "Mike Kienenberger" <mkienenb@gmail.com>
To: user@cayenne.apache.org
Subject: Re: How do I return a record count?
In-Reply-To: <BAY143-DAV874CCB3260EBFD4570460BA6A0@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <BAY143-DAV96132EBCC609B9791A022BA6A0@phx.gbl>
	 <8f985b960703230801o727e7b0ej2fc660f09f1abc01@mail.gmail.com>
	 <BAY143-DAV874CCB3260EBFD4570460BA6A0@phx.gbl>

Sounds right.  I haven't used named queries so I wasn't aware of how
they are configured.   If that's the case, what sql output do you see
in the logs?

Here's some sample code that might be helpful.  It doesn't do quite
the same thing, but it's pretty close in structure and data returned.

    private Integer fetchDocumentNumberAutoIncrement() {
        String defaultSql = "SELECT #result('max(DOCUMENT_NUMBER)+1'
'long' 'ID') FROM ENG_WORK_MGMT.AUTHORIZATION_DOCUMENT";
    	String oracleSql = "SELECT
#result('SEQ_AuthDocDocumentNumber.NextVal' 'long' 'ID') FROM DUAL";
    	
        SQLTemplate rawSelect = new SQLTemplate(getClass(), defaultSql);
        rawSelect.setTemplate(OracleAdapter.class.getName(), oracleSql);
        rawSelect.setFetchingDataRows(true);

        List list = getDataContext().performQuery(rawSelect);
        Map row = (Map)list.get(0);

        Number autoincrementID = (Number)row.get("ID");

        return new Integer(autoincrementID.intValue());
	}


On 3/23/07, Frank <farocco@hotmail.com> wrote:
> Fetch DataObjects is unchecked.
> Does this default to fetch DataRows?
>
> Frank
>
> ----- Original Message -----
> From: "Mike Kienenberger" <mkienenb@gmail.com>
> To: <user@cayenne.apache.org>
> Sent: Friday, March 23, 2007 11:01 AM
> Subject: Re: How do I return a record count?
>
>
> > Did you set the query to fetch DataRows (Maps) instead of DataObjects
> > (Entities)?
> >
> > On 3/23/07, Frank <farocco@hotmail.com> wrote:
> >> Hello,
> >> I have a named query defined as:
> >> SELECT COUNT(ticketId) AS cnt FROM tickets
> >> WHERE ticketClosed = 0
> >>
> >> This is not working, how do I get the count returned?
> >> NamedQuery query = new NamedQuery("openTicketsQuery");
> >> List records = context.performQuery(query).;
> >> String cnt = records.get(0).toString();
> >>
> >> Thanks
> >>
> >> Frank
> >>
> >
>