cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Kienenberger" <mkien...@gmail.com>
Subject Re: How do I return a record count?
Date Fri, 23 Mar 2007 15:13:27 GMT
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
> >>
> >
>

Mime
View raw message