I'm caching a few different queries. I have one that always misses. It has a Date parameter but I zero out the time. I need some help investigating the problem.

Here is the portion of the log output:

DEBUG org.hibernate.cache.EhCache - Element for sql: select
...
where this_.RPT_ID=? and (sq2_.END_DT>? or sq2_.END_DT is null) and sq2_.RPT_FLG=?;
parameters: 1234, Fri Jun 18 00:00:00 MDT 2010, Y, ; transformer: org.hibernate.transform.RootEntityResultTransformer@7a25088f is null

Query and Parameters are identical on misses.

The resulttransformer was unique on each query which explains the misses

Can you please let me know how to make result transformer does not create an unique object and does not make the query unique ,so that I can use in query cache. Is there any work around for it.
Please let me know
Best Regards
NG