[Hibernate-JIRA] Created: (HHH-5126) JPA Query with InExpression and Collection_valued_input_parameter Complains About Bad Syntax
4:49 a.m.
JPA Query with InExpression and Collection_valued_input_parameter Complains About Bad
Syntax
--------------------------------------------------------------------------------------------
Key: HHH-5126
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126
Project: Hibernate Core
Issue Type: Bug
Affects Versions: 3.5.1
Reporter: Guido Müller
Priority: Blocker
JPA 2.0 spec final chapter 4.6.9 In Expressions
In the spec there are 3 alternatives allowed for the query argument. For the 3rd
alternative there are no parenthesis allowed.
Hibernate seems to expect these illegal parenthesis.
The error occurs within a named query in an entity class.
--
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
4:53 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5126) JPA Query with InExpression and Collection_valued_input_parameter Complains About Bad Syntax
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126?page=c...
]
Guido Müller commented on HHH-5126:
-----------------------------------
The error occurs e.g. in this Query:
@NamedQuery(name = ExportFormat.NQ_FIND_ALL_WITH_EXCEPTION, query = "SELECT e FROM
ExportFormat e WHERE e.oid NOT IN :oidList")
It works with this illegal syntax:
@NamedQuery(name = ExportFormat.NQ_FIND_ALL_WITH_EXCEPTION, query = "SELECT e FROM
ExportFormat e WHERE e.oid NOT IN (:oidList)")
JPA Query with InExpression and Collection_valued_input_parameter
Complains About Bad Syntax
--------------------------------------------------------------------------------------------
Key: HHH-5126
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126
Project: Hibernate Core
Issue Type: Bug
Affects Versions: 3.5.1
Reporter: Guido Müller
Priority: Blocker
JPA 2.0 spec final chapter 4.6.9 In Expressions
In the spec there are 3 alternatives allowed for the query argument. For the 3rd
alternative there are no parenthesis allowed.
Hibernate seems to expect these illegal parenthesis.
The error occurs within a named query in an entity class.
--
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
8:27 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5126) JPA Query with InExpression and Collection_valued_input_parameter Complains About Bad Syntax
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126?page=c...
]
Pierce Wetter commented on HHH-5126:
------------------------------------
Also, the parenthese should be allowed, then it should expect single values.
Query qTwoLogins = em.createQuery(
"select u from User u where ou.loginId in (:login1, :login2)"
);
Query qCollectionLogins = em.createQuery(
"select u from User u where u.login in :logins"
);
qTwoLogins.setParameter("login1","testuser1");
qTwoLogins.setParameter("login2","testuser2");
HashSet<String> list= new HashSet<String>(2);
list.add("testuser1");
list.add("testuser2");
qCollectionLogins.setParameter("logins",list);
BTW, could we fix this soon, its driving me crazy everytime I switch between EclipseLink
and Hibernate to try to shake out bugs I have in Hibernate but not EclipseLink.
JPA Query with InExpression and Collection_valued_input_parameter
Complains About Bad Syntax
--------------------------------------------------------------------------------------------
Key: HHH-5126
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126
Project: Hibernate Core
Issue Type: Bug
Affects Versions: 3.5.1
Reporter: Guido Müller
Priority: Blocker
JPA 2.0 spec final chapter 4.6.9 In Expressions
In the spec there are 3 alternatives allowed for the query argument. For the 3rd
alternative there are no parenthesis allowed.
Hibernate seems to expect these illegal parenthesis.
The error occurs within a named query in an entity class.
--
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
11:15 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5126) JPA Query with InExpression and Collection_valued_input_parameter Complains About Bad Syntax
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126?page=c...
]
Gail Badner commented on HHH-5126:
----------------------------------
To address this quickly, it would really help if you:
- checkout the source code from http://anonsvn.jboss.org/repos/hibernate/core/trunk/
- update org.hibernate.ejb.test.query.QueryTest to reproduce your issues using HQL
- update , and attach a patch generated with "svn diff".
Thanks,
Gail
JPA Query with InExpression and Collection_valued_input_parameter
Complains About Bad Syntax
--------------------------------------------------------------------------------------------
Key: HHH-5126
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126
Project: Hibernate Core
Issue Type: Bug
Affects Versions: 3.5.1
Reporter: Guido Müller
Priority: Blocker
JPA 2.0 spec final chapter 4.6.9 In Expressions
In the spec there are 3 alternatives allowed for the query argument. For the 3rd
alternative there are no parenthesis allowed.
Hibernate seems to expect these illegal parenthesis.
The error occurs within a named query in an entity class.
--
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
10:04 a.m.
New subject: [Hibernate-JIRA] Updated: (HHH-5126) JPA Query with InExpression and Collection_valued_input_parameter Complains About Bad Syntax
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126?page=c...
]
Guido Müller updated HHH-5126:
------------------------------
Attachment: QueryTest.java.patch
Patch for QueryTest.java to meet the JPA 2 spec
JPA Query with InExpression and Collection_valued_input_parameter
Complains About Bad Syntax
--------------------------------------------------------------------------------------------
Key: HHH-5126
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126
Project: Hibernate Core
Issue Type: Bug
Affects Versions: 3.5.1
Reporter: Guido Müller
Priority: Blocker
Attachments: QueryTest.java.patch
JPA 2.0 spec final chapter 4.6.9 In Expressions
In the spec there are 3 alternatives allowed for the query argument. For the 3rd
alternative there are no parenthesis allowed.
Hibernate seems to expect these illegal parenthesis.
The error occurs within a named query in an entity class.
--
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
4:26 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5126) JPA Query with InExpression and Collection_valued_input_parameter Complains About Bad Syntax
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126?page=c...
]
Guido Müller commented on HHH-5126:
-----------------------------------
The patches I have sent are still not applied to the sources yet.
JPA Query with InExpression and Collection_valued_input_parameter
Complains About Bad Syntax
--------------------------------------------------------------------------------------------
Key: HHH-5126
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126
Project: Hibernate Core
Issue Type: Bug
Affects Versions: 3.5.1
Reporter: Guido Müller
Priority: Blocker
Attachments: QueryTest.java.patch
JPA 2.0 spec final chapter 4.6.9 In Expressions
In the spec there are 3 alternatives allowed for the query argument. For the 3rd
alternative there are no parenthesis allowed.
Hibernate seems to expect these illegal parenthesis.
The error occurs within a named query in an entity class.
--
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
2:32 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5126) JPA Query with InExpression and Collection_valued_input_parameter Complains About Bad Syntax
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126?page=c...
]
Pierce Wetter commented on HHH-5126:
------------------------------------
I'd also like to comment that this is in all 3.5.x and 3.6.x versions, not just 3.5.1.
JPA Query with InExpression and Collection_valued_input_parameter
Complains About Bad Syntax
--------------------------------------------------------------------------------------------
Key: HHH-5126
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126
Project: Hibernate Core
Issue Type: Bug
Affects Versions: 3.5.1
Reporter: Guido Müller
Priority: Blocker
Attachments: QueryTest.java.patch
JPA 2.0 spec final chapter 4.6.9 In Expressions
In the spec there are 3 alternatives allowed for the query argument. For the 3rd
alternative there are no parenthesis allowed.
Hibernate seems to expect these illegal parenthesis.
The error occurs within a named query in an entity class.
--
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
6:42 p.m.
New subject: [Hibernate-JIRA] Updated: (HHH-5126) JPA Query with InExpression and Collection_valued_input_parameter Complains About Bad Syntax
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126?page=c...
]
Gail Badner updated HHH-5126:
-----------------------------
Affects Version/s: 3.6.0
JPA Query with InExpression and Collection_valued_input_parameter
Complains About Bad Syntax
--------------------------------------------------------------------------------------------
Key: HHH-5126
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126
Project: Hibernate Core
Issue Type: Bug
Affects Versions: 3.5.1, 3.6.0
Reporter: Guido Müller
Priority: Blocker
Attachments: QueryTest.java.patch
JPA 2.0 spec final chapter 4.6.9 In Expressions
In the spec there are 3 alternatives allowed for the query argument. For the 3rd
alternative there are no parenthesis allowed.
Hibernate seems to expect these illegal parenthesis.
The error occurs within a named query in an entity class.
--
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
7:08 p.m.
New subject: [Hibernate-JIRA] Updated: (HHH-5126) JPA Query with InExpression and Collection_valued_input_parameter Complains About Bad Syntax
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126?page=c...
]
Gail Badner updated HHH-5126:
-----------------------------
Fix Version/s: 4.0.0.Alpha1
3.6.1
JPA Query with InExpression and Collection_valued_input_parameter
Complains About Bad Syntax
--------------------------------------------------------------------------------------------
Key: HHH-5126
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126
Project: Hibernate Core
Issue Type: Bug
Affects Versions: 3.5.1, 3.6.0
Reporter: Guido Müller
Priority: Blocker
Fix For: 3.6.1, 4.0.0.Alpha1
Attachments: QueryTest.java.patch
JPA 2.0 spec final chapter 4.6.9 In Expressions
In the spec there are 3 alternatives allowed for the query argument. For the 3rd
alternative there are no parenthesis allowed.
Hibernate seems to expect these illegal parenthesis.
The error occurs within a named query in an entity class.
--
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
6:23 p.m.
New subject: [Hibernate-JIRA] Assigned: (HHH-5126) JPA Query with InExpression and Collection_valued_input_parameter Complains About Bad Syntax
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126?page=c...
]
Gail Badner reassigned HHH-5126:
--------------------------------
Assignee: Gail Badner
JPA Query with InExpression and Collection_valued_input_parameter
Complains About Bad Syntax
--------------------------------------------------------------------------------------------
Key: HHH-5126
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126
Project: Hibernate Core
Issue Type: Bug
Affects Versions: 3.5.1, 3.6.0
Reporter: Guido Müller
Assignee: Gail Badner
Priority: Blocker
Fix For: 3.6.1, 4.0.0.Alpha1
Attachments: QueryTest.java.patch
JPA 2.0 spec final chapter 4.6.9 In Expressions
In the spec there are 3 alternatives allowed for the query argument. For the 3rd
alternative there are no parenthesis allowed.
Hibernate seems to expect these illegal parenthesis.
The error occurs within a named query in an entity class.
--
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
3:02 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5126) JPA Query with InExpression and Collection_valued_input_parameter Complains About Bad Syntax
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126?page=c...
]
Gail Badner commented on HHH-5126:
----------------------------------
https://github.com/hibernate/hibernate-core/pull/33
JPA Query with InExpression and Collection_valued_input_parameter
Complains About Bad Syntax
--------------------------------------------------------------------------------------------
Key: HHH-5126
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126
Project: Hibernate Core
Issue Type: Bug
Affects Versions: 3.5.1, 3.6.0
Reporter: Guido Müller
Assignee: Gail Badner
Priority: Blocker
Fix For: 3.6.1, 4.0.0.Alpha1
Attachments: QueryTest.java.patch
JPA 2.0 spec final chapter 4.6.9 In Expressions
In the spec there are 3 alternatives allowed for the query argument. For the 3rd
alternative there are no parenthesis allowed.
Hibernate seems to expect these illegal parenthesis.
The error occurs within a named query in an entity class.
--
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
3:04 p.m.
New subject: [Hibernate-JIRA] Issue Comment Edited: (HHH-5126) JPA Query with InExpression and Collection_valued_input_parameter Complains About Bad Syntax
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126?page=c...
]
Gail Badner edited comment on HHH-5126 at 1/18/11 3:02 PM:
-----------------------------------------------------------
This is a proposed fix so that IN expressions will work with a collection-valued
input-parameter that is optionally enclosed in parentheses:
https://github.com/hibernate/hibernate-core/pull/33
For example, both of the following will work if a collection is bound to the parameter:
select item from Item item where item.name in :names select item from Item item where
item.name in (:names)
JPA 2.0 spec shows the paremeter not enclosed in parentheses. I've specifically
allowed the paremeter to be enclosed in parentheses because disallowing it would break the
non-JPA use case.
This fix works as follows:
1) hql.g was updated to allow a parameter that is not enclosed in parentheses
2) AbstractQueryImpl.expandParameterList(...) calls a new overloaded StringUtils.replace()
that takes a boolean parameter, encloseInParensIfNecessary. When true, replacement text is
explicitly enclosed in parentheses, if the placeholder was not immediately enclosed in
parentheses (ignoring whitespace).
3) the special case where AbstractQueryImpl.expandParameterList(...) checks for one value
was also changed to check for parentheses.
Steve, please take a look.
Thanks,
Gail
was (Author: gbadner):
https://github.com/hibernate/hibernate-core/pull/33
JPA Query with InExpression and Collection_valued_input_parameter
Complains About Bad Syntax
--------------------------------------------------------------------------------------------
Key: HHH-5126
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126
Project: Hibernate Core
Issue Type: Bug
Affects Versions: 3.5.1, 3.6.0
Reporter: Guido Müller
Assignee: Gail Badner
Priority: Blocker
Fix For: 3.6.1, 4.0.0.Alpha1
Attachments: QueryTest.java.patch
JPA 2.0 spec final chapter 4.6.9 In Expressions
In the spec there are 3 alternatives allowed for the query argument. For the 3rd
alternative there are no parenthesis allowed.
Hibernate seems to expect these illegal parenthesis.
The error occurs within a named query in an entity class.
--
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
3:09 p.m.
New subject: [Hibernate-JIRA] Resolved: (HHH-5126) JPA Query with InExpression and Collection_valued_input_parameter Complains About Bad Syntax
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126?page=c...
]
Gail Badner resolved HHH-5126.
------------------------------
Resolution: Fixed
Fixed in hibernate-core master and 3.6.
JPA Query with InExpression and Collection_valued_input_parameter
Complains About Bad Syntax
--------------------------------------------------------------------------------------------
Key: HHH-5126
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5126
Project: Hibernate Core
Issue Type: Bug
Affects Versions: 3.5.1, 3.6.0
Reporter: Guido Müller
Assignee: Gail Badner
Priority: Blocker
Fix For: 3.6.1, 4.0.0.Alpha1
Attachments: QueryTest.java.patch
JPA 2.0 spec final chapter 4.6.9 In Expressions
In the spec there are 3 alternatives allowed for the query argument. For the 3rd
alternative there are no parenthesis allowed.
Hibernate seems to expect these illegal parenthesis.
The error occurs within a named query in an entity class.
--
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
10:13 a.m.
New subject: [Hibernate-JIRA] (HHH-5126) JPA Query with InExpression and Collection_valued_input_parameter Complains About Bad Syntax
7:38 a.m.
New subject: [Hibernate-JIRA] (HHH-5126) JPA Query with InExpression and Collection_valued_input_parameter Complains About Bad Syntax
2:47 a.m.
New subject: [Hibernate-JIRA] (HHH-5126) JPA Query with InExpression and Collection_valued_input_parameter Complains About Bad Syntax
10:59 a.m.
New subject: [Hibernate-JIRA] (HHH-5126) JPA Query with InExpression and Collection_valued_input_parameter Complains About Bad Syntax
4427
days inactive
5364
days old
hibernate-issues@lists.jboss.org
16 comments
6 participants
participants (6)
-
Anthony Ogier (JIRA) -
Gail Badner (JIRA)
-
Guido Müller (JIRA)
-
Karsten Wutzke (JIRA)
-
Pierce Wetter (JIRA)
-
Steve Ebersole (JIRA)