Untitled

converting a complex oracle query to hibernate
select
    d.dateInRange as dateval,
    eventdesc,
    nvl(td.dist_ucnt, 0) as dist_ucnt
from (
    select
        to_date('03-NOV-2011','dd-mon-yyyy') + rownum - 1 as dateInRange
    from all_objects
    where rownum <= to_date('31-DEC-2011','dd-mon-yyyy') - to_date('03-NOV-2011','dd-mon-yyyy') + 1
) d
left join (
    select
        currentdate,
        count(distinct(grauser_id)) as dist_ucnt,
        eventdesc
    from
        txn_summ_dec

    group by currentdate, eventdesc
) td on td.currentdate = d.dateInRange order by d.dateInRange asc