Problem with Hibernate Criteria, Query by Example and "nullable=false"

[Peter Wagner]

Hi,

i am using Hibernate Criteria with "Query by Example" and have some problems when i set "nullable=false" for OneToMany mapping inside my entities.
The problem is, that the generated SQL query is not the one i expected.

Here is my example code:

Person.java:

@Entity @Table(name="personen")
public class Person {
   
   @Id
   private Integer bp_personenid;
   
   @OneToMany(fetch=FetchType.EAGER)
   @JoinColumn(name="bp_personenid", nullable=false)
   @Cascade({CascadeType.SAVE_UPDATE, CascadeType.DELETE_ORPHAN})
   private Set<PersonenStichwort> personenStichworte = new HashSet<PersonenStichwort>();
   
   public Set<PersonenStichwort> getPersonenStichworte() {
      return personenStichworte;
   }

PersonenStichwort.java:

@Entity
@Table(name="personenstichworte")
public class PersonenStichwort {

   @Id
   private Integer bp_personenid;
   private String stichwort;
   @Version @Generated(GenerationTime.ALWAYS) @Temporal(TemporalType.TIMESTAMP)
   private Date la;
   
   public String getStichwort() {
      return stichwort;
   }
   
   public void setStichwort(String stichwort) {
      this.stichwort = stichwort;
   }   
}

PersonenDao.java:

public class PersonenDaoImpl extends GenericDaoImpl<Person, Integer> implements PersonenDao {

   public List<Person> findPersonen(Person person, PersonenStichwort personenStichwort) {
      Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Person.class);
   
                criteria.createCriteria("personenStichworte",CriteriaSpecification.LEFT_JOIN)
                     .add(Example.create(personenStichwort).excludeProperty("bp_personenid"));
      
      criteria.add(Example.create(person).ignoreCase().enableLike());
      criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
      
      return criteria.list();
   }

}

SQL Query generated by Hibernate:

select
    this_.bp_personenid as bp1_5_1_
    from
        personen this_
    left outer join
        personenstichworte personenst1_
            on this_.bp_personenid=personenst1_.bp_personenid
    where
        (
            personenst1_.bp_personenid=?
        )
        and (
            1=1
        )

As you can see, Hibernate inserts "personenst1_.bp_personenid=?" inside the sql-where-clause, cause personenStichworte in Person.java is mapped with "nullable=false". How can i force Hibernate to exclude this property without
changing nullable to true? (I have already tested Example.create(personenStichwort).excludeProperty("bp_personenid"), but doesn't work as well)

Best regards

Peter