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/05/09 19:41:06 UTC

Null value for 'ticketId'

Hello,

I am trying to get a count of records from mysql.
I keep getting this error.

Null value for 'ticketId'. Snapshot: org.objectstyle.cayenne.DataRow@158689a[values={COUNT(*)=5}, version=-9223372036854775802, replaces=-9223372036854775808]. Prefix: null

here is my code:

     String sql = "SELECT COUNT(*) AS cnt FROM tickets";
     SQLTemplate query = new SQLTemplate(tickets.class, sql);
     List list = context.performQuery(query);
     Map row = (Map)list.get(0);
     String cnt = row.get("cnt").toString();


Thanks

Frank

Re: Null value for 'ticketId'

Posted by Frank <fa...@hotmail.com>.
Nevermind,

I forgot the
query.setFetchingDataRows(true);

Thanks

Frank

----- Original Message ----- 
From: "Frank" <fa...@hotmail.com>
To: <us...@cayenne.apache.org>
Sent: Wednesday, May 09, 2007 1:41 PM
Subject: Null value for 'ticketId'


Hello,

I am trying to get a count of records from mysql.
I keep getting this error.

Null value for 'ticketId'. Snapshot: 
org.objectstyle.cayenne.DataRow@158689a[values={COUNT(*)=5}, 
version=-9223372036854775802, replaces=-9223372036854775808]. Prefix: null

here is my code:

     String sql = "SELECT COUNT(*) AS cnt FROM tickets";
     SQLTemplate query = new SQLTemplate(tickets.class, sql);
     List list = context.performQuery(query);
     Map row = (Map)list.get(0);
     String cnt = row.get("cnt").toString();


Thanks

Frank