Timestamp between of DateA and DateB

[nimo frey]

Hello,

I have a timestampValue which is mapped as:

private java.util.Date timestampValue ;
@Temporal(TemporalType.TIMESTAMP)
public Date getTimestampValue () {return timestampValue; }
public void setTimestampValue(Date timestampValue) { this.timestampValue = timestampValue;}

in my database, the timestamp-value is something like:

1990-09-09 00:00:00.000000

Now, I have two Values of type java.util.Date:

myFirstDate: Tue Jan 15 00:00:00 GMT 2009
mySecondDate: Tue Feb 25 00:00:00 GMT 2009

Now, I want a hql, which gives the range between myFirstDate and mySecondDate, something like:

"select o from MyObject o where o.timestampValue between myFirstDate and mySecondDate"

But this does not work as myFirstDate and mySecondDate are not comparable with the Timestamp-Object, or?

Any suggestions?