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?