I have the following as a mapping element:

<property name="activeParticipantCount" type="int" lazy="true" >
<formula>( select count(*) from participant_employer pe, participant p
where pe.employer_id = EMPLOYER_ID and pe.termination_date is null
and pe.user_id = p.user_id and p.status = 'active' )
</formula>
</property>

The sql genereated by hibernate is :

Hibernate: select [...other field removed...] ( select count(*) from participant_employer pe, participant p
where pe.employer_id = employer0_.EMPLOYER_ID and pe.termination_date is employer0_.null
and pe.user_id = p.user_id and p.status = 'active' )
as formula1_ from EMPLOYER employer0_

How do I get hibernate to generate "pe.termination_date is null" instead of "pe.termination_date is employer0_.null"?

The query as hibernate generates causes a jdbc exception: java.sql.SQLException: ORA-00908: missing NULL keyword

Ok here is the scoop....

In my formula query above, if I put a space after the is null clause, "is null ", then it works. However, if there is no space, "is null", then I get the above descriped error.

Should this be in the JIRA system?

And yes, I do have a carriage return after the "is null" in my mapping file.

have you tried CDATA?

I wrapped it in a CDATA tag, and the behavior still exists. I need to have a space after the "is null".

OK, looks like Template.renderWhereStringTemplate() is not considering a carriage return as whitespace. I'll fix that.