Select count(*) on table with no rows

[dornus]

I have a tbale with no rows in it. I would like to get the count for that table. I would expect to see zero rows returned instead of an error.

 final Query q = em.createNativeQuery(
 "select count(*) " +
 "from MyTable " +
 "where myColumn = :col ", MyClass.class
 );
 q.setParameter("col", myColumnValue);
 return (Integer) q.getSingleResult();

I think this is because it is trying to create a MyClass object, but cannot since no data was returned by the database.

Is there a better way of doing this?

[dornus]

The error I receive is:

WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: S0022
ERROR [JDBCExceptionReporter] Column 'myPrimaryKey' not found.

[dornus]

In case you're wondering why I added the MyClass.class part....

If I take the MyClass.class part out I get a NOT YET IMPLEMENTED error.

[dornus]

I got it w/o using the native query.

 final Query q = em.createQuery(
 "select count(o) " +
 "from MyTable o " +
 "where o.myColumn = :col "
 );

I'm just wondering how to get a similar result with nativeQuerying.