I need to query a table having data similar to something like:

Date Count
1/10/2007 10
2/10/2007 13
4/10/2007 11
6/10/2007 12

Notice that there is no data avaialble for 3rd and 5th; I expect the result to have something as shown below:

Date Count
1/10/2007 10
2/10/2007 13
3/10/2007 0
4/10/2007 11
5/10/2007 0
6/10/2007 12

This is not possible with a simple query; Is there anyway I can handle this using Hibernate features.

TIA
~vd

You can use Criteria
Criteria criteria = session.createCriteria(DateCount.class).
add(Restrictions.gt("count",new Long(0))).
addOrder(Order.asc("date"));

This will show the result as in the first table.

But if you want the output as in second table then I doubt current Hibernate version could help regarding that.
You need to retrive data in some data-structure such as (ArrayList, Vector) and show the result manually.