9:49 a.m.
Query Parameters not supported for Entity Type Expression
---------------------------------------------------------
Key: HHH-5282
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5282
Project: Hibernate Core
Issue Type: Bug
Affects Versions: 3.5.2
Reporter: Simon Martinelli
Trying to use Entity Type Expression with query parameter result in an exception:
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: : near line 1, column 90
[select k from ch.bkw.zlsc.domain.stammdaten.vse.VSEStatistikKategorie k where TYPE(k) in
:typs and k.sortierung like :keyword]
Using dynamic query instead of parameters 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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:51 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5282) Query Parameters not supported for Entity Type Expression
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5282?page=c...
]
Simon Martinelli commented on HHH-5282:
---------------------------------------
Extract from JPA 2.0 Spec:
4.6.17.4 Entity Type Expressions
An entity type expression can be used to restrict query polymorphism. The TYPE operator
returns the exact type of the argument.
The syntax of an entity type expression is as follows:
entity_type_expression ::=
type_discriminator |
entity_type_literal |
input_parameter
type_discriminator ::=
TYPE(identification_variable |
single_valued_object_path_expression |
input_parameter )
An entity_type_literal is designated by the entity name.
The Java class of the entity is used as an input parameter to specify the entity type.
Examples:
SELECT e
FROM Employee e
WHERE TYPE(e) IN (Exempt, Contractor)
SELECT e
FROM Employee e
WHERE TYPE(e) IN (:empType1, :empType2)
SELECT e
FROM Employee e
WHERE TYPE(e) IN :empTypes
SELECT TYPE(e)
FROM Employee e
WHERE TYPE(e) <> Exempt
Query Parameters not supported for Entity Type Expression
---------------------------------------------------------
Key: HHH-5282
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5282
Project: Hibernate Core
Issue Type: Bug
Affects Versions: 3.5.2
Reporter: Simon Martinelli
Trying to use Entity Type Expression with query parameter result in an exception:
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: : near line 1, column 90
[select k from ch.bkw.zlsc.domain.stammdaten.vse.VSEStatistikKategorie k where TYPE(k) in
:typs and k.sortierung like :keyword]
Using dynamic query instead of parameters 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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:08 a.m.
New subject: [Hibernate-JIRA] Updated: (HHH-5282) Query Parameters not supported for Entity Type Expression
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5282?page=c...
]
Gail Badner updated HHH-5282:
-----------------------------
Component/s: entity-manager
Please do the following:
* checkout the trunk version http://anonsvn.jboss.org/repos/hibernate/core/trunk
* update or add a test in entitymanager/src/test/ to reproduce your issue
* update org.hibernate.ejb.AbstractQueryImpl.java with your fix
* create two patches using "svn diff" (one for your test and one for your
fix), and attach to this issue
Thanks,
Gail
Query Parameters not supported for Entity Type Expression
---------------------------------------------------------
Key: HHH-5282
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5282
Project: Hibernate Core
Issue Type: Bug
Components: entity-manager
Affects Versions: 3.5.2
Reporter: Simon Martinelli
Trying to use Entity Type Expression with query parameter result in an exception:
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: : near line 1, column 90
[select k from ch.bkw.zlsc.domain.stammdaten.vse.VSEStatistikKategorie k where TYPE(k) in
:typs and k.sortierung like :keyword]
Using dynamic query instead of parameters 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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:20 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5282) Query Parameters not supported for Entity Type Expression
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5282?page=c...
]
Gail Badner commented on HHH-5282:
----------------------------------
Oops, I see you don't have a proposed fix for this.
Please attach a patch for just the unit test then.
Thanks,
Gail
Query Parameters not supported for Entity Type Expression
---------------------------------------------------------
Key: HHH-5282
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5282
Project: Hibernate Core
Issue Type: Bug
Components: entity-manager
Affects Versions: 3.5.2
Reporter: Simon Martinelli
Trying to use Entity Type Expression with query parameter result in an exception:
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: : near line 1, column 90
[select k from ch.bkw.zlsc.domain.stammdaten.vse.VSEStatistikKategorie k where TYPE(k) in
:typs and k.sortierung like :keyword]
Using dynamic query instead of parameters 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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:48 a.m.
New subject: [Hibernate-JIRA] Updated: (HHH-5282) Query Parameters not supported for Entity Type Expression
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5282?page=c...
]
Michael Rudolf updated HHH-5282:
--------------------------------
Attachment: query-test-type-expression.patch
git diff for trunk containing a failing test case
Query Parameters not supported for Entity Type Expression
---------------------------------------------------------
Key: HHH-5282
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5282
Project: Hibernate Core
Issue Type: Bug
Components: entity-manager
Affects Versions: 3.5.2
Reporter: Simon Martinelli
Attachments: query-test-type-expression.patch
Trying to use Entity Type Expression with query parameter result in an exception:
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: : near line 1, column 90
[select k from ch.bkw.zlsc.domain.stammdaten.vse.VSEStatistikKategorie k where TYPE(k) in
:typs and k.sortierung like :keyword]
Using dynamic query instead of parameters 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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:06 p.m.
New subject: [Hibernate-JIRA] Resolved: (HHH-5282) Query Parameters not supported for Entity Type Expression
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5282?page=c...
]
Gail Badner resolved HHH-5282.
------------------------------
Assignee: Gail Badner
Resolution: Duplicate
Thanks for the test case. I'm resolving this as a duplicate of HHH-4881 because that
issue has more votes (which increases visibility).
Query Parameters not supported for Entity Type Expression
---------------------------------------------------------
Key: HHH-5282
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5282
Project: Hibernate Core
Issue Type: Bug
Components: entity-manager
Affects Versions: 3.5.2
Reporter: Simon Martinelli
Assignee: Gail Badner
Attachments: query-test-type-expression.patch
Trying to use Entity Type Expression with query parameter result in an exception:
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: : near line 1, column 90
[select k from ch.bkw.zlsc.domain.stammdaten.vse.VSEStatistikKategorie k where TYPE(k) in
:typs and k.sortierung like :keyword]
Using dynamic query instead of parameters 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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:03 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5282) Query Parameters not supported for Entity Type Expression
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5282?page=c...
]
Ted Young commented on HHH-5282:
--------------------------------
For what it is worth, you can at least get access to the discriminator by exposing it as a
private read-only property. I wrote up an example here:
http://tedyoung.me/2011/08/08/jpa-and-hibernate-problems-with-polymorphic...
This was particularly important for me where I had to group by and order by type. It
isn't perfect, though. Note the issues described at the end of the article. But, it
works for now.
Query Parameters not supported for Entity Type Expression
---------------------------------------------------------
Key: HHH-5282
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5282
Project: Hibernate Core
Issue Type: Bug
Components: entity-manager
Affects Versions: 3.5.2
Reporter: Simon Martinelli
Assignee: Gail Badner
Attachments: query-test-type-expression.patch
Trying to use Entity Type Expression with query parameter result in an exception:
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: : near line 1, column 90
[select k from ch.bkw.zlsc.domain.stammdaten.vse.VSEStatistikKategorie k where TYPE(k) in
:typs and k.sortierung like :keyword]
Using dynamic query instead of parameters works.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4683
days inactive
5116
days old
hibernate-issues@lists.jboss.org
6 comments
4 participants
participants (4)
-
Gail Badner (JIRA) -
Michael Rudolf (JIRA)
-
Simon Martinelli (JIRA)
-
Ted Young (JIRA)