[Hibernate-JIRA] Created: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[Hibernate-JIRA] Created:...

Martin Kouba (JIRA)

Monday, 11 June 2007 Mon, 11 Jun '07

2:53 p.m.

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.4.sp1, 3.2.4, 3.2.3 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1. -- 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

Show replies by date

Carsten Behring (JIRA)

Monday, 11 June Mon, 11 Jun

6:53 p.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667?page=c... ] Carsten Behring commented on HHH-2667: -------------------------------------- I have the same problem with the Criteria API, the code is something like this: Conjunction conjuntion= Expression.conjunction(); conjuntion.add(Expression.isNotNull("cat.age")); conjuntion.add(Expression.isNull("cat.mate.age")); I works with 3.1.3, and 3.2.2 I doesn't work with 3.2.3

...

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1.

-- 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

Tomasz Blachowicz (JIRA)

Tuesday, 26 June Tue, 26 Jun

1:18 p.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667?page=c... ] Tomasz Blachowicz commented on HHH-2667: ---------------------------------------- This seems to be serious issue. I've been working on large scale application and this problem blocks Hibernate upgrade. We're kind of stuck in 3.2.2. Do you think somone more advanced in Hibernate development could take a look at the problem?

...

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1.

Nick Folder (JIRA)

Tuesday, 3 July Tue, 3 Jul

10:23 a.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667?page=c... ] Nick Folder commented on HHH-2667: ---------------------------------- I have the same problem. This is a very serious issue! Why is there no response from hibernate?

...

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1.

Christian Bauer (JIRA)

10:31 a.m.

New subject: [Hibernate-JIRA] Updated: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667?page=c... ] Christian Bauer updated HHH-2667: --------------------------------- Comment: was deleted

...

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1.

Christian Bauer (JIRA)

10:33 a.m.

New subject: [Hibernate-JIRA] Updated: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667?page=c... ] Christian Bauer updated HHH-2667: --------------------------------- Comment: was deleted

...

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1.

Jeff Pae-Corr (JIRA)

Friday, 20 July Fri, 20 Jul

4:37 a.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667?page=c... ] Jeff Pae-Corr commented on HHH-2667: ------------------------------------ I provide support for a web-app that uses Hibernate 3.x. At this time I am not able to provide the version number of Hibernate as those were removed from the jar names, but I get the same behavior. Per the opening description I changed this: List assignments = find("from Assignment a where a.assigner.locations.name = ?",schoolName); to List assignments = find("from Assignment a join a.assigner.locations s where s.name = ?",schoolName); to attempt to resolve the issue. The problem is that next I am trying to run deleteAll(assignments) but it fails on a java.lang.ClassCastException: [Ljava.lang.Object; I believe this is probably due to the fact that properties from objects other than Assignment are also being pulled into the List since I am using join. The original query worked fine before the Hibernate update.

...

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1.

Jeff Pae-Corr (JIRA)

4:37 a.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667?page=c... ] Jeff Pae-Corr commented on HHH-2667: ------------------------------------ By the way, this was on Server '03, MySQL 4.1 DB.

...

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1.

Nick Folder (JIRA)

9:57 a.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667?page=c... ] Nick Folder commented on HHH-2667: ---------------------------------- Which files are requiered for a complete test case? BTW: Why do you need a test case, it's obvious that auto-join with collections is broken since 3.2.3?

...

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1.

Jeff Pae-Corr (JIRA)

4:27 p.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667?page=c... ] Jeff Pae-Corr commented on HHH-2667: ------------------------------------ I have confirmed the versions stated in the original entry are correct. The ablility to auto join collections works as expected in 3.1.3, 3.2.0 and 3.2.2 and It doesn't work with versions 3.2.3 and with 3.2.4.sp1. I have also tested this with 3.2.1 which is the version I used prior to updating to 3.2.3 and it funcitoned the way it should.

...

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1.

Steve Ebersole (JIRA)

6:10 p.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667?page=c... ] Steve Ebersole commented on HHH-2667: ------------------------------------- I dont know how many times i need to close cases with almost the same exact description. This was never supported syntax, and was never supposed to work. It was simply a regression that it happened to work (somewhat) in certain releases.

...

From your example, locations (whatever type of collection it is) has no property named 'name'.

...

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1.

Steve Ebersole (JIRA)

6:10 p.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667?page=c... ] Steve Ebersole commented on HHH-2667: ------------------------------------- Yes, requesting a test case was not the right thing here. because this is expected not to work.

...

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1.

Nick Folder (JIRA)

6:38 p.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667?page=c... ] Nick Folder commented on HHH-2667: ---------------------------------- Well, it worked in any Hibernate realease I know. It's ok to change such "dirty" stuff . But it's not ok to change it in a service realease (3.2.2 -> 3.2.3). Never had such problems with Hibernate before. Anyway, thanks for your great work.

...

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1.

Jeff Pae-Corr (JIRA)

6:55 p.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667?page=c... ] Jeff Pae-Corr commented on HHH-2667: ------------------------------------ The "name" property exists for locations, I have also figured out a workaround so I dont have to go through and modify ump-teen queries. Thank you for work on the Hibernate project. Since you say that this was never an intended feature, Is this something that could be added through a feature request?

...

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1.

Chris Bredesen (JIRA)

7 p.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667?page=c... ] Chris Bredesen commented on HHH-2667: ------------------------------------- Just to alleviate future confusion -- the original example implies that implicit joins across a many-to-one are broken and this is not the case. If Cat.mate were a collection, you'd get this error which is expected behavior and aptly named.

...

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1.

Martin Kouba (JIRA)

8:19 p.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667?page=c... ] Martin Kouba commented on HHH-2667: ----------------------------------- Would you kindly not close an issue related to a bug and could you kindly reopen this issue. This is not a misuse or something. I guess I have described the situation clear enough in my original statement. Also according to the current manual at 14.17. Components eg. "select p.name from from Person p" eg. "from Person p order by p.name.first" (I don't know why the manual says from from but this is a different story) you can find examples that will not work without fixing this bug. So if you plan to remove this feature and make it necessary to work aroung such cases using native SQL than please state that in the manual that this is no longer supported.

...

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1.

Chris Bredesen (JIRA)

8:25 p.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667?page=c... ] Chris Bredesen commented on HHH-2667: ------------------------------------- Kindly attach a runnable test case which shows this and it will get looked at. Dereferencing a collection is misuse. Implicit join across a single-valued association is not.

...

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1.

Christian Bauer (JIRA)

8:53 p.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667?page=c... ] Christian Bauer commented on HHH-2667: -------------------------------------- And do so by opening a new issue (WITH a runable testcase). This one is obviously just a bunch of people guessing without any hard evidence such as mapping files etc, and has now been closed.

...

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1.

Christian Bauer (JIRA)

8:53 p.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667?page=c... ] Christian Bauer commented on HHH-2667: -------------------------------------- And finally: The "collection dereference" change has been noted in the migration guide for months for Hibernate 3.2.

...

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1.

Jeff Pae-Corr (JIRA)

Saturday, 21 July Sat, 21 Jul

5 a.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667?page=c... ] Jeff Pae-Corr commented on HHH-2667: ------------------------------------ Thank you Christian. btw, great job on your Hibernate books with Manning, I have and use them both. I unfortunately cannot provide any files as they are because they are not mine to publicly post. I will try to genericize the hbm files along with their corresponding pojos for review.

...

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1.

Nick Folder (JIRA)

Sunday, 22 July Sun, 22 Jul

11 p.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667?page=c... ] Nick Folder commented on HHH-2667: ----------------------------------

...

From the Hibernate 3.2 Migration Guide:

"Query language changes Implicit joins are more deterministic With such mapping: <class name='Currency' lazy='false'> .... </class> <class name='Asset'> <id name='id' ... </id> <many-to-one name='currency' class='Currency' fetch='select'/> </class> and such HQL query: select a.id, a.currency from Asset a Since Hibernate 3.2.2 this query generates an inner join on Asset with Currency which means that Assets with a NULL currency are not returned by the query anymore. This makes implicit joins more deterministic. To get Assets with a NULL currency just use select a.id, c from Asset a left join a.currency as c Path expressions joining across a collection throw exception The always illegal statement: select f.bars.baz from Foo f Now throws an exception. Despite the always present warning in the documentation that this is an illegal path expression if bars is a collection, users found this to be working in some cases with Hibernate 3.1. This is no longer the case, an error is thrown. As always, the correct syntax is an explicit join: select b.baz from Foo f join f.bars b"

...

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1.

Carsten Behring (JIRA)

Wednesday, 1 August Wed, 1 Aug

6:59 p.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

...

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1.

Christian Bauer (JIRA)

7:09 p.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667?page=c... ] Christian Bauer commented on HHH-2667: -------------------------------------- Discuss usage questions on the forum.

...

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1.

Nick Folder (JIRA)

Sunday, 19 August Sun, 19 Aug

10:01 p.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667?page=c... ] Nick Folder commented on HHH-2667: ---------------------------------- "But how do I need to change my code which is using the Criteria API (see my first comment on this ) ?"

...

From the Reference Guide (anyway it sucks ;-) ...

15.4. Associations You may easily specify constraints upon related entities by navigating associations using createCriteria(). List cats = sess.createCriteria(Cat.class) .add( Restrictions.like("name", "F%") ) .createCriteria("kittens") .add( Restrictions.like("name", "F%") ) .list(); note that the second createCriteria() returns a new instance of Criteria, which refers to the elements of the kittens collection. The following, alternate form is useful in certain circumstances. List cats = sess.createCriteria(Cat.class) .createAlias("kittens", "kt") .createAlias("mate", "mt") .add( Restrictions.eqProperty("kt.name", "mt.name") ) .list(); (createAlias() does not create a new instance of Criteria.) Note that the kittens collections held by the Cat instances returned by the previous two queries are not pre-filtered by the criteria! If you wish to retrieve just the kittens that match the criteria, you must use a ResultTransformer. List cats = sess.createCriteria(Cat.class) .createCriteria("kittens", "kt") .add( Restrictions.eq("name", "F%") ) .setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP) .list(); Iterator iter = cats.iterator(); while ( iter.hasNext() ) { Map map = (Map) iter.next(); Cat cat = (Cat) map.get(Criteria.ROOT_ALIAS); Cat kitten = (Cat) map.get("kt"); }

...

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1.

Steve Ebersole (JIRA)

Wednesday, 3 October Wed, 3 Oct

9:08 a.m.

New subject: [Hibernate-JIRA] Reopened: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667?page=c... ] Steve Ebersole reopened HHH-2667: ---------------------------------

...

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1.

Steve Ebersole (JIRA)

9:08 a.m.

New subject: [Hibernate-JIRA] Closed: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667?page=c... ] Steve Ebersole closed HHH-2667. ------------------------------- Resolution: Rejected

...

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.3, 3.2.4, 3.2.4.sp1 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1.

6113

days inactive

6227

days old

hibernate-issues@lists.jboss.org

Manage subscription

25 comments

8 participants

tags (0)

participants (8)

Carsten Behring (JIRA)
Chris Bredesen (JIRA)
Christian Bauer (JIRA)
Jeff Pae-Corr (JIRA)
Martin Kouba (JIRA)
Nick Folder (JIRA)
Steve Ebersole (JIRA)
Tomasz Blachowicz (JIRA)

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

[Hibernate-JIRA] Created: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join