You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cayenne.apache.org by Frank <fa...@hotmail.com> on 2007/03/23 15:58:34 UTC
How do I return a record count?
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
Re: How do I return a record count?
Posted by Frank <fa...@hotmail.com>.
Thanks Mike, that did the trick.
List list = context.performQuery(query);
Map row = (Map)list.get(0);
String cnt = row.get("cnt").toString();
Regards,
Frank
----- Original Message -----
From: "Mike Kienenberger" <mk...@gmail.com>
To: <us...@cayenne.apache.org>
Sent: Friday, March 23, 2007 11:13 AM
Subject: Re: How do I return a record count?
> 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 <fa...@hotmail.com> wrote:
>> Fetch DataObjects is unchecked.
>> Does this default to fetch DataRows?
>>
>> Frank
>>
>> ----- Original Message -----
>> From: "Mike Kienenberger" <mk...@gmail.com>
>> To: <us...@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 <fa...@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
>> >>
>> >
>>
>
Re: How do I return a record count?
Posted by Mike Kienenberger <mk...@gmail.com>.
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 <fa...@hotmail.com> wrote:
> Fetch DataObjects is unchecked.
> Does this default to fetch DataRows?
>
> Frank
>
> ----- Original Message -----
> From: "Mike Kienenberger" <mk...@gmail.com>
> To: <us...@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 <fa...@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
> >>
> >
>
Re: How do I return a record count?
Posted by Frank <fa...@hotmail.com>.
Fetch DataObjects is unchecked.
Does this default to fetch DataRows?
Frank
----- Original Message -----
From: "Mike Kienenberger" <mk...@gmail.com>
To: <us...@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 <fa...@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
>>
>
Re: How do I return a record count?
Posted by Mike Kienenberger <mk...@gmail.com>.
Did you set the query to fetch DataRows (Maps) instead of DataObjects
(Entities)?
On 3/23/07, Frank <fa...@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
>