doing a count(*) in a named query

[John Gregory]

I've been told to create a named query within an entity class that performs a count on the table.
In JDBC, I could do this and get an int. However, I'm not sure how to do this within the framework
I've been given. Can someone offer any suggestions with this???

Thanks,

John

[Cameron Wallace McKenzie]

So, the next question is, 'what framework have you been given?'

[John Gregory]

Cameron,

Sorry, I guess by framework, I meant how the boss wants it done, nothing
technology specific. We're using JPA and toplink. Other than that, not sure what you
need... It's not using Spring/Hibernate....etc.

John

[James Sutherland]

In JPA try something like:

@NamedQuery(
  name="countEmployees",
  query="Select Count(e) from Employee e"
)

...

int count = ((Number)em.createNamedQuery("countEmployees").getSingleResult()).intValue();

[John Gregory]

James,

Thanks, I'll give that a try.

John