[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3394) ScrollableResults delivers sometime wrong collections when used with a LEFT JOIN FETCH clause
Gail Badner (JIRA)
noreply at atlassian.com
Tue Sep 16 13:14:05 EDT 2008
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3394?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=31209#action_31209 ]
Gail Badner commented on HHH-3394:
----------------------------------
Please attach a runnable unit test (Java + mapping) that reproduces this issue.
> ScrollableResults delivers sometime wrong collections when used with a LEFT JOIN FETCH clause
> ---------------------------------------------------------------------------------------------
>
> Key: HHH-3394
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3394
> Project: Hibernate Core
> Issue Type: Bug
> Components: query-hql
> Affects Versions: 3.2.6
> Environment: Windows, Java SE 6.06, Oracle 9 / 10, Hibernate 3.2.6
> Reporter: Thomas Scherm
>
> Following stament is used to create a ScrollableResult from a Query.
> SELECT DISTINCT f FROM Fall f
> LEFT JOIN FETCH f.leistungen l
> WHERE (f.status = '2' OR f.status = '3') AND f.quartalJahr = ?
> It schould deliver a Faelle with prefeched sets of Leistungen.
> The first row is ok. All subsequent rows return exactly one leistungen.
> Th SQL Statement is ok, the session cache works fine and has the missing Leistungen, but they are not attached.
> As Workaround we removed the FETC clause and let it work with lazy loading. It works.
--
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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the hibernate-issues
mailing list