I am using Hibernate 2 and have the following property mapping which has a WHERE clause that filters on 'sysdate' to return the first period after todays date.

<set name="currentPeriod"
cascade="none"
access="field"
lazy="true"
where="period_date = (SELECT MIN(p1.period_date) FROM period p1 WHERE p1.period_date > sysdate AND p1.company_id = company_id)">
<key>
<column name="COMPANY_ID"/>
</key>
<one-to-many class="common.Accounts.Period"/>
</set>

My problem is in unit testing using this class.
Within the Java application I can change todays date for testing purposes but I can't change 'sysdate' in my tests which in this case is the Oracle databases today date.

I imagine it is not possibe to parameterize the SQL in the WHERE clause and pass a date at runtime from my unit test?

Would anyone have any suggestions of an alternative approach here?