Hi all,

I am HB-Newbe.
Problem seems easy, only 2 tables to make a select: table person and table persondetails, 1:1, both with same ids as pk, in hybernate i made annotation one to one. Initially most persons have not a associated persondetail in the db.

I want get a list of all persons who have a specific field in persondetails set to false OR who have not (yet) a persondetails entry in the db.

Many thanks!

(ps: i managed to get the persons with persondetails-field false with a alias rsp additional "criteria.createCriteria(persondetails...," but i cant figure out how to combine that with a "OR persondetail is null":-)

Try something like:

select p from Person p where p.personDetails is null or p.personDetails.someField = false

I haven't tested this :) Generally I find HQL a lot simpler than Criteria...