SelectCountStar

How do I execute "SELECT COUNT(*)" in TopLink?

The easiest way is with a ValueReadQuery.

ValueReadQuery q = new ValueReadQuery("SELECT COUNT(*) FROM xxx");
Number count = (Number) myTopLinkSession.executeQuery(q);
return count.longValue();

For more complicated needs see SelectAggregateValues.