Hibernate criteria not working as expected
09:14 23 Jan 2026

I got stuck on an old project and I've never really used hibernate criteria before. This is an Oracle database.

I have a query that uses criteria. Here is the criteria dumped.

criteria:CriteriaImpl(com.jsi.fullcourt.domain.caserole.Statute:st[][st.revision=Revision{id=1, description='201908', effectiveDate=2019-08-26, endDate=null, basedOn=null, statutes=37, uniqueBy='Statute Number'}, st.expungedIndicator=false, st.effectiveDate>=1971-01-09, st.inactive=false])

This query returns no rows.

I believe this is the same query:

select id, JSI_NUMBER, DESCRIPTION, EFFECTIVE_DATE, INACTIVE, INACTIVE_DATE, REVISION_ID, EXPUNGED_INDICATOR, COMMON from STATUTE where REVISION_ID = 1 and EFFECTIVE_DATE >= to_date('1971-01-09', 'YYYY-MM-DD') and EXPUNGED_INDICATOR = 0 and INACTIVE = 0 order by JSI_NUMBER;

And this returns one row.

What am I missing?

java oracle-database hibernate hibernate-criteria