Menu
▾
▴
hibernate-issues
|
From: <no...@at...> - 2005-04-12 09:26:59
|
Message: A new issue has been created in JIRA. --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/browse/HHH-333 Here is an overview of the issue: --------------------------------------------------------------------- Key: HHH-333 Summary: QuerySyntaxError when using JOIN index(...) in HQL query Type: Bug Status: Unassigned Priority: Major Original Estimate: Unknown Time Spent: Unknown Remaining: Unknown Project: Hibernate3 Versions: 3.0 final Assignee: Reporter: Etienne Bernard Created: Tue, 12 Apr 2005 4:25 AM Updated: Tue, 12 Apr 2005 4:25 AM Description: I've been using this syntax since hibernate 2.0 : FROM test.A AS a JOIN a.abs AS ab JOIN index(ab) AS b WHERE ab.status=1 with the following mapping : [...] <class name="test.A" table="a"> [...] <map name="abs" table="ab" lazy="true"> <key column="a"></key> <index-many-to-many class="test.B" column="b"/> <composite-element class="test.AB"> <property name="status" type="int"/> </composite-element> </map> [...] </class> [...] It used to work with hibernate 2.1 too. It doesn't work anymore with hibernate 3.0 final. See the attached example for a complete test case. Thanks. --------------------------------------------------------------------- JIRA INFORMATION: 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 If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
|
From: <no...@at...> - 2005-04-12 09:29:04
|
The following comment has been added to this issue:
Author: Etienne Bernard
Created: Tue, 12 Apr 2005 4:27 AM
Body:
The testcase is too big to be attached. It is downloadable from http://pltplp.net/hibernate-bug.tgz
---------------------------------------------------------------------
View this comment:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-333?page=comments#action_17091
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-333
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HHH-333
Summary: QuerySyntaxError when using JOIN index(...) in HQL query
Type: Bug
Status: Unassigned
Priority: Major
Original Estimate: Unknown
Time Spent: Unknown
Remaining: Unknown
Project: Hibernate3
Versions:
3.0 final
Assignee:
Reporter: Etienne Bernard
Created: Tue, 12 Apr 2005 4:25 AM
Updated: Tue, 12 Apr 2005 4:27 AM
Description:
I've been using this syntax since hibernate 2.0 :
FROM test.A AS a JOIN a.abs AS ab JOIN index(ab) AS b WHERE ab.status=1
with the following mapping :
[...]
<class name="test.A" table="a">
[...]
<map name="abs" table="ab" lazy="true">
<key column="a"></key>
<index-many-to-many class="test.B" column="b"/>
<composite-element class="test.AB">
<property name="status" type="int"/>
</composite-element>
</map>
[...]
</class>
[...]
It used to work with hibernate 2.1 too. It doesn't work anymore with hibernate 3.0 final.
See the attached example for a complete test case.
Thanks.
---------------------------------------------------------------------
JIRA INFORMATION:
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
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <no...@at...> - 2005-04-12 09:31:10
|
The following comment has been added to this issue:
Author: Etienne Bernard
Created: Tue, 12 Apr 2005 4:29 AM
Body:
Oops, forgot to add : run "ant testh2" for hibernate 2.1 test, "ant testh3" for hibernate 3.
---------------------------------------------------------------------
View this comment:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-333?page=comments#action_17092
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-333
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HHH-333
Summary: QuerySyntaxError when using JOIN index(...) in HQL query
Type: Bug
Status: Unassigned
Priority: Major
Original Estimate: Unknown
Time Spent: Unknown
Remaining: Unknown
Project: Hibernate3
Versions:
3.0 final
Assignee:
Reporter: Etienne Bernard
Created: Tue, 12 Apr 2005 4:25 AM
Updated: Tue, 12 Apr 2005 4:29 AM
Description:
I've been using this syntax since hibernate 2.0 :
FROM test.A AS a JOIN a.abs AS ab JOIN index(ab) AS b WHERE ab.status=1
with the following mapping :
[...]
<class name="test.A" table="a">
[...]
<map name="abs" table="ab" lazy="true">
<key column="a"></key>
<index-many-to-many class="test.B" column="b"/>
<composite-element class="test.AB">
<property name="status" type="int"/>
</composite-element>
</map>
[...]
</class>
[...]
It used to work with hibernate 2.1 too. It doesn't work anymore with hibernate 3.0 final.
See the attached example for a complete test case.
Thanks.
---------------------------------------------------------------------
JIRA INFORMATION:
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
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <no...@at...> - 2005-04-16 13:42:52
|
The following comment has been added to this issue:
Author: Panagiotis Korros
Created: Sat, 16 Apr 2005 8:41 AM
Body:
I have a similar problem with the index hql function.
It is documented in http://forum.hibernate.org/viewtopic.php?t=940527 and also includes a junit test case.
---------------------------------------------------------------------
View this comment:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-333?page=comments#action_17164
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-333
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HHH-333
Summary: QuerySyntaxError when using JOIN index(...) in HQL query
Type: Bug
Status: Unassigned
Priority: Major
Original Estimate: Unknown
Time Spent: Unknown
Remaining: Unknown
Project: Hibernate3
Versions:
3.0 final
Assignee:
Reporter: Etienne Bernard
Created: Tue, 12 Apr 2005 4:25 AM
Updated: Sat, 16 Apr 2005 8:41 AM
Description:
I've been using this syntax since hibernate 2.0 :
FROM test.A AS a JOIN a.abs AS ab JOIN index(ab) AS b WHERE ab.status=1
with the following mapping :
[...]
<class name="test.A" table="a">
[...]
<map name="abs" table="ab" lazy="true">
<key column="a"></key>
<index-many-to-many class="test.B" column="b"/>
<composite-element class="test.AB">
<property name="status" type="int"/>
</composite-element>
</map>
[...]
</class>
[...]
It used to work with hibernate 2.1 too. It doesn't work anymore with hibernate 3.0 final.
See the attached example for a complete test case.
Thanks.
---------------------------------------------------------------------
JIRA INFORMATION:
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
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: Etienne B. (JIRA) <no...@at...> - 2006-01-03 10:29:40
|
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-333?page=comments#action_21513 ] Etienne Bernard commented on HHH-333: ------------------------------------- This issue is fixed in hibernate 3.1. Thank you for the correction. I think you can close the bug, now (and I can port my application ;-) > QuerySyntaxError when using JOIN index(...) in HQL query > -------------------------------------------------------- > > Key: HHH-333 > URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-333 > Project: Hibernate3 > Type: Bug > Versions: 3.0 final > Reporter: Etienne Bernard > > > I've been using this syntax since hibernate 2.0 : > FROM test.A AS a JOIN a.abs AS ab JOIN index(ab) AS b WHERE ab.status=1 > with the following mapping : > [...] > <class name="test.A" table="a"> > [...] > <map name="abs" table="ab" lazy="true"> > <key column="a"></key> > <index-many-to-many class="test.B" column="b"/> > <composite-element class="test.AB"> > <property name="status" type="int"/> > </composite-element> > </map> > [...] > </class> > [...] > It used to work with hibernate 2.1 too. It doesn't work anymore with hibernate 3.0 final. > See the attached example for a complete test case. > Thanks. -- 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 |
|
From: Gavin K. (JIRA) <no...@at...> - 2006-01-03 10:40:35
|
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-333?page=comments#action_21514 ] Gavin King commented on HHH-333: -------------------------------- We had better make sure we have a unit test before we close anything. The fix might have been accidental ;) Raising priority, so we don't break it again. > QuerySyntaxError when using JOIN index(...) in HQL query > -------------------------------------------------------- > > Key: HHH-333 > URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-333 > Project: Hibernate3 > Type: Bug > Versions: 3.0 final > Reporter: Etienne Bernard > > > I've been using this syntax since hibernate 2.0 : > FROM test.A AS a JOIN a.abs AS ab JOIN index(ab) AS b WHERE ab.status=1 > with the following mapping : > [...] > <class name="test.A" table="a"> > [...] > <map name="abs" table="ab" lazy="true"> > <key column="a"></key> > <index-many-to-many class="test.B" column="b"/> > <composite-element class="test.AB"> > <property name="status" type="int"/> > </composite-element> > </map> > [...] > </class> > [...] > It used to work with hibernate 2.1 too. It doesn't work anymore with hibernate 3.0 final. > See the attached example for a complete test case. > Thanks. -- 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 |
|
From: Gavin K. (JIRA) <no...@at...> - 2006-01-03 11:02:25
|
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-333?page=all ] Gavin King updated HHH-333: --------------------------- Priority: Critical (was: Major) Environment: Description: I've been using this syntax since hibernate 2.0 : FROM test.A AS a JOIN a.abs AS ab JOIN index(ab) AS b WHERE ab.status=1 with the following mapping : [...] <class name="test.A" table="a"> [...] <map name="abs" table="ab" lazy="true"> <key column="a"></key> <index-many-to-many class="test.B" column="b"/> <composite-element class="test.AB"> <property name="status" type="int"/> </composite-element> </map> [...] </class> [...] It used to work with hibernate 2.1 too. It doesn't work anymore with hibernate 3.0 final. See the attached example for a complete test case. Thanks. was: I've been using this syntax since hibernate 2.0 : FROM test.A AS a JOIN a.abs AS ab JOIN index(ab) AS b WHERE ab.status=1 with the following mapping : [...] <class name="test.A" table="a"> [...] <map name="abs" table="ab" lazy="true"> <key column="a"></key> <index-many-to-many class="test.B" column="b"/> <composite-element class="test.AB"> <property name="status" type="int"/> </composite-element> </map> [...] </class> [...] It used to work with hibernate 2.1 too. It doesn't work anymore with hibernate 3.0 final. See the attached example for a complete test case. Thanks. > QuerySyntaxError when using JOIN index(...) in HQL query > -------------------------------------------------------- > > Key: HHH-333 > URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-333 > Project: Hibernate3 > Type: Bug > Versions: 3.0 final > Reporter: Etienne Bernard > Priority: Critical > > > I've been using this syntax since hibernate 2.0 : > FROM test.A AS a JOIN a.abs AS ab JOIN index(ab) AS b WHERE ab.status=1 > with the following mapping : > [...] > <class name="test.A" table="a"> > [...] > <map name="abs" table="ab" lazy="true"> > <key column="a"></key> > <index-many-to-many class="test.B" column="b"/> > <composite-element class="test.AB"> > <property name="status" type="int"/> > </composite-element> > </map> > [...] > </class> > [...] > It used to work with hibernate 2.1 too. It doesn't work anymore with hibernate 3.0 final. > See the attached example for a complete test case. > Thanks. -- 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 |
|
From: Steve E. (JIRA) <no...@at...> - 2006-01-28 12:46:40
|
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-333?page=all ] Steve Ebersole updated HHH-333: ------------------------------- Priority: Minor (was: Critical) Component: query-hql > QuerySyntaxError when using JOIN index(...) in HQL query > -------------------------------------------------------- > > Key: HHH-333 > URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-333 > Project: Hibernate3 > Type: Bug > Components: query-hql > Versions: 3.0 final > Reporter: Etienne Bernard > Priority: Minor > > > I've been using this syntax since hibernate 2.0 : > FROM test.A AS a JOIN a.abs AS ab JOIN index(ab) AS b WHERE ab.status=1 > with the following mapping : > [...] > <class name="test.A" table="a"> > [...] > <map name="abs" table="ab" lazy="true"> > <key column="a"></key> > <index-many-to-many class="test.B" column="b"/> > <composite-element class="test.AB"> > <property name="status" type="int"/> > </composite-element> > </map> > [...] > </class> > [...] > It used to work with hibernate 2.1 too. It doesn't work anymore with hibernate 3.0 final. > See the attached example for a complete test case. > Thanks. -- 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 |
|
From: Etienne B. (JIRA) <no...@at...> - 2006-02-16 15:37:17
|
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-333?page=comments#action_22240 ] Etienne Bernard commented on HHH-333: ------------------------------------- err shame on me... I just noticed that I had hibernate.query.factory_class=org.hibernate.hql.classic.ClassicQueryTranslatorFactory in my hibernate.properties so the bug is not fixed at all... > QuerySyntaxError when using JOIN index(...) in HQL query > -------------------------------------------------------- > > Key: HHH-333 > URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-333 > Project: Hibernate3 > Type: Bug > Components: query-hql > Versions: 3.0 final > Reporter: Etienne Bernard > Priority: Minor > > > I've been using this syntax since hibernate 2.0 : > FROM test.A AS a JOIN a.abs AS ab JOIN index(ab) AS b WHERE ab.status=1 > with the following mapping : > [...] > <class name="test.A" table="a"> > [...] > <map name="abs" table="ab" lazy="true"> > <key column="a"></key> > <index-many-to-many class="test.B" column="b"/> > <composite-element class="test.AB"> > <property name="status" type="int"/> > </composite-element> > </map> > [...] > </class> > [...] > It used to work with hibernate 2.1 too. It doesn't work anymore with hibernate 3.0 final. > See the attached example for a complete test case. > Thanks. -- 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 |
|
From: Etienne B. (JIRA) <no...@at...> - 2006-05-11 10:01:12
|
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-333?page=comments#action_23076 ] Etienne Bernard commented on HHH-333: ------------------------------------- Just so that everyone knows... FROM test.A AS a JOIN a.abs AS ab JOIN index(ab) AS b WHERE ab.status=1 can be replaced with the syntax : FROM test.A AS a JOIN a.abs AS ab JOIN ab.index AS b WHERE ab.status=1 which works perfectly with Hibernate 3.0 and 3.1. This features seems to not be documented. I'm not sure if it's wanted or not but for me it's the only way to perform complex HQL queries involving many-to-many relationships. > QuerySyntaxError when using JOIN index(...) in HQL query > -------------------------------------------------------- > > Key: HHH-333 > URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-333 > Project: Hibernate3 > Type: Bug > Components: query-hql > Versions: 3.0 final > Reporter: Etienne Bernard > Priority: Minor > > > I've been using this syntax since hibernate 2.0 : > FROM test.A AS a JOIN a.abs AS ab JOIN index(ab) AS b WHERE ab.status=1 > with the following mapping : > [...] > <class name="test.A" table="a"> > [...] > <map name="abs" table="ab" lazy="true"> > <key column="a"></key> > <index-many-to-many class="test.B" column="b"/> > <composite-element class="test.AB"> > <property name="status" type="int"/> > </composite-element> > </map> > [...] > </class> > [...] > It used to work with hibernate 2.1 too. It doesn't work anymore with hibernate 3.0 final. > See the attached example for a complete test case. > Thanks. -- 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 |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X