[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2449) Lazy loading for one-to-one asociations

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2449?page=c... ] radhakrishna commented on HHH-2449: ----------------------------------- Thought that this is a very simple scenario that might have already been addressed, discussed and take care of in Hibernate as it involves serious performance issues. Posted on Hibernate forums made me realize that lazy is only possible from the side holding the foreign key which makes sense and a work around by defining the one-to-one as a <set> But how can the child loads eagerly in separate select statements rather than using a join for no reason! The concept of lazy="no-proxy" and lazy="proxy" are confusing. The lazy="no-proxy" in the documentation suggests enabling lazy fetching with out proxies as the only way to have the <one-to-one> end not load eagerly. But it requires byte-code manipulation as described here: http://www.hibernate.org/hib_docs/v3/reference/en/html/performance.html#p.... I had no idea how to do this as I could not find an example or a way to do it. Again, to explain my scenario: I have a user and user_termination tables with only the user_termination having the user_id as the foreign key and the user may or may not have a user_termination entry! I defined the userTermination mapping in user as <one-to-one name="userTermination" class="UserTermination" property-ref="user" lazy="no-proxy"> </one-to-one> And the userTermination has a user entry as a many-to-one <many-to-one name="participant" class="Participant" column="participant_id" unique="true" not-null="false" /> I chose lazy="no-proxy" in my parent however, whenever I write my HQL on parent User table such as from User user where user.user_deleted_date_time is null it fetches all of my user's first in a single select and then follows by a separate select statements of userTermination, obviously whenever they may only exist, although I don't need them to be fetched eagerly unless I do a left join fetch or something! There is no alternative by avoiding the userTermination entry in user object and write my HQL query as select from user, userTermination where user.userId = userTermination.userId it looses the user objects as only not all users have userTermination!! In a normal SQL statement all I have to do is a left join as in select .. from user, userTermination where user.userId = userTermination.userId(+) I am not sure if I can write my left join HQL query without having it to be mentioned as a one-to-one object in my parent mapping? -- 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