Exception [EclipseLink-6044] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.QueryException
Exception Description: The primary key read from the row [ArrayRecord(
 => 1129
 => 2011-09-05 12:50:28.735459)] during the execution of the query was detected to be null. Primary keys must not contain null.
Query: ReadAllQuery(referenceClass=Wowzalog sql="select logid, created from wowzalog l where xtime >= '2011-05-01'::date and xtime < '2012-03-07'::date + 1 and username = 'bulbTest5' order by xtime, logid ASC offset 0 limit 20")

Exception [EclipseLink-6044] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.QueryException
Exception Description: The primary key read from the row [ArrayRecord(
=> 61)] during the execution of the query was detected to be null. Primary keys must not contain null.
Query: ReadAllQuery(referenceClass=Broj sql="select count(1) as broj from wowzalog where xtime >= '2011-05-01'::date and xtime < '2012-03-07'::date + 1 and username = 'bulbTest5'")

String query = "select count(1) as broj from wowzalog where xtime >= '2011-05-01'::date and xtime < '2012-03-07'::date + 1 and username = 'bulbTest5'"
Broj count = (Broj) em.createNativeQuery(query, Broj.class).getSingleResult();

@Entity
public class Broj implements Serializable {
    private static final long serialVersionUID = 786457894567954L;
    
    @Id
    private int broj;

    public int getBroj() {
        return broj;
    }

    public void setBroj(int broj) {
        this.broj = broj;
    }    
}