Saving count(*) in an annotated entity

ribose · **Joined:** Thu Jul 03, 2008 1:00 am **Posts:** 1

How to specify the following request:

Code:

select count(*) from <another-table> where id = <current-id>

with an annotation in an entity? I would like to have a field called size in my entity which should have the value returned by the upper SQL request. This field is not saved in the database, so it is transient.

Cameron McKenzie · **Posted:** Fri Jul 04, 2008 1:26 pm

If it's just a simple count, there's no reason why you can't just do a simple SQL query.

If there's an object mapped to the table, you could just use a from 'object' HQL query. Criteria queries always work well too, but I think simple HQL and then doing a size() method call on the returned list/collection would be sufficient.

How to do HQL and Native queries with Hibernate3:

http://jpa.ezhibernate.com/Javacode/learn.jsp?tutorial=08masteringhqlandnamedqueries

Do you see any problems with that? What is the issue you are anticipating?