Unwanted select statement issued for each not-found=ignore ---------------------------------------------------------- Key: HHH-3025 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3025 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.5 Environment: Win XP Oracle 9i Reporter: Julien HENRY Hi, I just want to report that I was bitten by the same bug reported on NHibernate JIRA : http://jira.nhibernate.org/browse/NH-1001 not-found="ignore" is set on a many-to-one (not-null="false") element that I retrieve using a Criteria query and using FechMode.JOIN. Hibernate have everything needed in the first query to know whether the foreign entity exists. But it performs an additional query. I'm retrieving a big list of entity, and I'm using FetchMode.JOIN to prevent N+1 select. But this bug waste my efforts. Thanks Julien -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira