[hibernate-issues] [Hibernate-JIRA] Created: (HHH-5713) Member of doesn't work with a @ElementCollection of String

Tuesday, 2 November 2010

Member of doesn't work with a @ElementCollection of String
----------------------------------------------------------

                 Key: HHH-5713
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5713
             Project: Hibernate Core
          Issue Type: Bug
    Affects Versions: 3.6.0
            Reporter: Antonio Goncalves
         Attachments: JavaEE6Devoxx.zip

Also see https://forum.hibernate.org/viewtopic.php?f=1&t=1007606&p=2437844

I have the following @Entity :

{code}
public class Book {

    @Id @GeneratedValue
    private Long id;
    private String title;
    private Float price;
    private String isbn;

    @ElementCollection
    @CollectionTable(name = "tags")
    private List<String> tags = new ArrayList<String>();
{code}

I use {{@ElementCollection}} to have a list of strings (tags you can add to books). I want
to find all the books that have a tag equals to "scifi", so I wrote the
following named query :

{code}
SELECT b FROM Book b WHERE 'scifi' member of b.tags
{code}

But here is what I get (with log level at debug) :

{code}
10:53:14,512 DEBUG QueryTranslatorImpl:272 - parse() - HQL: SELECT b FROM
org.beginningee6.tutorial.Book b WHERE 'scifi' member of b.tags
10:53:14,527 DEBUG AST:291 - --- HQL AST ---
\-[QUERY] Node: 'query'
    +-[SELECT_FROM] Node: 'SELECT_FROM'
    |  +-[FROM] Node: 'FROM'
    |  |  \-[RANGE] Node: 'RANGE'
    |  |     +-[DOT] Node: '.'
    |  |     |  +-[DOT] Node: '.'
    |  |     |  |  +-[DOT] Node: '.'
    |  |     |  |  |  +-[IDENT] Node: 'org'
    |  |     |  |  |  \-[IDENT] Node: 'beginningee6'
    |  |     |  |  \-[IDENT] Node: 'tutorial'
    |  |     |  \-[IDENT] Node: 'Book'
    |  |     \-[ALIAS] Node: 'b'
    |  \-[SELECT] Node: 'SELECT'
    |     \-[IDENT] Node: 'b'
    \-[WHERE] Node: 'WHERE'
       \-[IN] Node: 'in'
          +-[QUOTED_STRING] Node: ''scifi''
          \-[IN_LIST] Node: 'inList'
             \-[QUERY] Node: 'QUERY'
                \-[SELECT_FROM] Node: 'SELECT_FROM'
                   \-[FROM] Node: 'from'
                      \-[RANGE] Node: 'RANGE'
                         \-[DOT] Node: '.'
                            +-[IDENT] Node: 'b'
                            \-[IDENT] Node: 'tags'

10:53:14,527 DEBUG ErrorCounter:91 - throwQueryException() : no errors
10:53:14,527 DEBUG HqlSqlBaseWalker:111 - select << begin [level=1,
statement=select]
10:53:14,527 DEBUG FromElement:157 - FromClause{level=1} :  org.beginningee6.tutorial.Book
(b) -> book0_
10:53:14,527 DEBUG FromReferenceNode:74 - Resolved :  b -> book0_.id
10:53:14,527 DEBUG HqlSqlBaseWalker:111 - select << begin [level=2,
statement=select]
10:53:14,543 DEBUG FromElementFactory:131 - createFromElementInSubselect() : path =
b.tags
10:53:14,543 DEBUG PathHelper:69 - parsePath() : b.tags -> [  ( . b tags ) ]
10:53:14,543 DEBUG FromReferenceNode:74 - Resolved :  b -> book0_.id
10:53:14,543 DEBUG DotNode:613 - getDataType() : tags ->
org.hibernate.type.BagType(org.beginningee6.tutorial.Book.tags)
10:53:14,543 DEBUG FromElement:157 - FromClause{level=2} :  null (no alias) -> tags1_
10:53:14,543 DEBUG FromClause:368 - addCollectionJoinFromElementByPath() : b.tags ->
tags
10:53:14,543 DEBUG DotNode:306 - dereferenceCollection() : Created new FROM element for
b.tags : tags tags1_
10:53:14,543 DEBUG FromReferenceNode:74 - Resolved :  b.tags -> .
10:53:14,543 DEBUG FromElementFactory:164 - createFromElementInSubselect() : b.tags ->
tags tags1_
10:53:14,543 DEBUG HqlSqlBaseWalker:117 - select : finishing up [level=2,
statement=select]
10:53:14,543 DEBUG HqlSqlWalker:620 - processQuery() :  ( SELECT ( FromClause{level=2}
tags tags1_ ) )
10:53:14,543 DEBUG HqlSqlWalker:863 - Derived SELECT clause created.
10:53:14,543 DEBUG SyntheticAndFactory:94 - Using unprocessed WHERE-fragment
[book0_.id=tags1_.Book_id]
10:53:14,543 DEBUG SyntheticAndFactory:125 - Using processed WHERE-fragment
[book0_.id=tags1_.Book_id]
10:53:14,543 DEBUG QueryNode:74 - getWhereClause() : Creating a new WHERE clause...
10:53:14,543 DEBUG HqlSqlBaseWalker:123 - select >> end [level=2, statement=select]
10:53:14,543 DEBUG HqlSqlBaseWalker:117 - select : finishing up [level=1,
statement=select]
10:53:14,543 DEBUG HqlSqlWalker:620 - processQuery() :  ( SELECT ( {select clause}
book0_.id ) ( FromClause{level=1}  ) ( WHERE ( in 'scifi' ( inList ( SELECT
{derived select clause} ( FromClause{level=2} tags tags1_ ) ( WHERE ( {theta joins}
book0_.id=tags1_.Book_id ) ) ) ) ) ) )
10:53:14,543 DEBUG JoinProcessor:179 - Using FROM fragment [Book book0_]
10:53:14,543 DEBUG HqlSqlBaseWalker:123 - select >> end [level=1, statement=select]
10:53:14,559 DEBUG AST:258 - --- SQL AST ---
\-[SELECT] QueryNode: 'SELECT'  querySpaces (tags,Book)
    +-[SELECT_CLAUSE] SelectClause: '{select clause}'
    |  +-[ALIAS_REF] IdentNode: 'book0_.id as id0_' {alias=b,
className=org.beginningee6.tutorial.Book, tableAlias=book0_}
    |  \-[SQL_TOKEN] SqlFragment: 'book0_.contentLanguage as contentL2_0_,
book0_.description as descript3_0_, book0_.illustrations as illustra4_0_, book0_.isbn as
isbn0_, book0_.nbOfPage as nbOfPage0_, book0_.price as price0_, book0_.title as
title0_'
    +-[FROM] FromClause: 'FROM' FromClause{level=1, fromElementCounter=1,
fromElements=1, fromElementByClassAlias=[b], fromElementByTableAlias=[book0_],
fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
    |  \-[FROM_FRAGMENT] FromElement: 'Book book0_'
FromElement{explicit,collection join,not a fetch join,fetch non-lazy
properties,classAlias=b,role=null,tableName=Book,tableAlias=book0_,origin=null,columns={,className=org.beginningee6.tutorial.Book}}
    \-[WHERE] SqlNode: 'WHERE'
       \-[IN] InLogicOperatorNode: 'in'
          +-[QUOTED_STRING] LiteralNode: ''scifi''
          \-[IN_LIST] SqlNode: 'inList'
             \-[SELECT] QueryNode: 'SELECT'  querySpaces (tags,Book)
                +-[SELECT_CLAUSE] SelectClause: '{derived select clause}'
                +-[FROM] FromClause: 'from' FromClause{level=2,
fromElementCounter=0, fromElements=1, fromElementByClassAlias=[],
fromElementByTableAlias=[tags1_], fromElementsByPath=[],
collectionJoinFromElementsByPath=[b.tags], impliedElements=[]}
                |  \-[FROM_FRAGMENT] ImpliedFromElement: 'tags tags1_'
ImpliedFromElement{implied,collection join,not a fetch join,fetch non-lazy
properties,classAlias=null,role=org.beginningee6.tutorial.Book.tags,tableName={none},tableAlias=tags1_,origin=Book
book0_,columns={,className=null}}
                \-[WHERE] SqlNode: 'WHERE'
                   \-[THETA_JOINS] SqlNode: '{theta joins}'
                      \-[SQL_TOKEN] SqlFragment: 'book0_.id=tags1_.Book_id'

10:53:14,574 DEBUG ErrorCounter:91 - throwQueryException() : no errors
10:53:14,574 ERROR PARSER:56 - <AST>:0:0: unexpected end of subtree
10:53:14,574 DEBUG ErrorCounter:51 - <AST>:0:0: unexpected end of subtree
<AST>:0:0: unexpected end of subtree
   at org.hibernate.hql.antlr.SqlGeneratorBase.selectClause(SqlGeneratorBase.java:523)
   at org.hibernate.hql.antlr.SqlGeneratorBase.selectStatement(SqlGeneratorBase.java:175)
   at org.hibernate.hql.antlr.SqlGeneratorBase.parenSelect(SqlGeneratorBase.java:3438)
   at org.hibernate.hql.antlr.SqlGeneratorBase.inList(SqlGeneratorBase.java:3315)
   at
org.hibernate.hql.antlr.SqlGeneratorBase.exoticComparisonExpression(SqlGeneratorBase.java:3158)
   at org.hibernate.hql.antlr.SqlGeneratorBase.comparisonExpr(SqlGeneratorBase.java:1297)
   at org.hibernate.hql.antlr.SqlGeneratorBase.booleanExpr(SqlGeneratorBase.java:910)
   at org.hibernate.hql.antlr.SqlGeneratorBase.whereExpr(SqlGeneratorBase.java:768)
   at org.hibernate.hql.antlr.SqlGeneratorBase.selectStatement(SqlGeneratorBase.java:191)
   at org.hibernate.hql.antlr.SqlGeneratorBase.statement(SqlGeneratorBase.java:119)
   at org.hibernate.hql.ast.QueryTranslatorImpl.generate(QueryTranslatorImpl.java:238)
   at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:205)
   at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
   at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
   at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
   at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124)
   at
org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:547)
   at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:411)
   at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1842)
   at
org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:902)
   at
org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:57)
   at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:48)
   at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:32)
   at org.beginningee6.tutorial.BookTest.initEntityManager(BookTest.java:42)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
   at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
   at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
   at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:27)
   at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
   at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
   at org.junit.runner.JUnitCore.run(JUnitCore.java:157)
   at
com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:94)
   at
com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:192)
   at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:64)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at com.intellij.rt.execution.application.AppMain.main(AppMain.java:115)
10:53:14,590 ERROR PARSER:56 - <AST>:0:0: expecting "from", found
'<ASTNULL>'
10:53:14,590 DEBUG ErrorCounter:51 - <AST>:0:0: expecting "from", found
'<ASTNULL>'
<AST>:0:0: expecting "from", found '<ASTNULL>'
   at antlr.TreeParser.match(TreeParser.java:68)
   at org.hibernate.hql.antlr.SqlGeneratorBase.from(SqlGeneratorBase.java:570)
   at org.hibernate.hql.antlr.SqlGeneratorBase.selectStatement(SqlGeneratorBase.java:177)
   at org.hibernate.hql.antlr.SqlGeneratorBase.parenSelect(SqlGeneratorBase.java:3438)
   at org.hibernate.hql.antlr.SqlGeneratorBase.inList(SqlGeneratorBase.java:3315)
   at
org.hibernate.hql.antlr.SqlGeneratorBase.exoticComparisonExpression(SqlGeneratorBase.java:3158)
   at org.hibernate.hql.antlr.SqlGeneratorBase.comparisonExpr(SqlGeneratorBase.java:1297)
   at org.hibernate.hql.antlr.SqlGeneratorBase.booleanExpr(SqlGeneratorBase.java:910)
   at org.hibernate.hql.antlr.SqlGeneratorBase.whereExpr(SqlGeneratorBase.java:768)
   at org.hibernate.hql.antlr.SqlGeneratorBase.selectStatement(SqlGeneratorBase.java:191)
   at org.hibernate.hql.antlr.SqlGeneratorBase.statement(SqlGeneratorBase.java:119)
   at org.hibernate.hql.ast.QueryTranslatorImpl.generate(QueryTranslatorImpl.java:238)
   at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:205)
   at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
   at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
   at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
   at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124)
   at
org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:547)
   at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:411)
   at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1842)
   at
org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:902)
   at
org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:57)
   at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:48)
   at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:32)
   at org.beginningee6.tutorial.BookTest.initEntityManager(BookTest.java:42)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
   at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
   at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
   at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:27)
   at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
   at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
   at org.junit.runner.JUnitCore.run(JUnitCore.java:157)
   at
com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:94)
   at
com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:192)
   at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:64)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at com.intellij.rt.execution.application.AppMain.main(AppMain.java:115)
10:53:14,621 DEBUG QueryTranslatorImpl:241 - HQL: SELECT b FROM
org.beginningee6.tutorial.Book b WHERE 'scifi' member of b.tags
10:53:14,621 DEBUG QueryTranslatorImpl:242 - SQL: select book0_.id as id0_,
book0_.contentLanguage as contentL2_0_, book0_.description as descript3_0_,
book0_.illustrations as illustra4_0_, book0_.isbn as isbn0_, book0_.nbOfPage as
nbOfPage0_, book0_.price as price0_, book0_.title as title0_ from Book book0_ where
'scifi' in (select )
10:53:14,621 DEBUG SessionFactoryImpl:557 - Checking 0 named SQL queries
10:53:14,621 ERROR SessionFactoryImpl:422 - Error in named query: findAllScifiBooks
org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [SELECT b FROM
org.beginningee6.tutorial.Book b WHERE 'scifi' member of b.tags]
   at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
   at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
   at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
   at org.hibernate.hql.ast.QueryTranslatorImpl.generate(QueryTranslatorImpl.java:244)
   at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:205)
   at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
   at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
   at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
   at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124)
   at
org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:547)
   at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:411)
   at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1842)
   at
org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:902)
   at
org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:57)
   at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:48)
   at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:32)
   at org.beginningee6.tutorial.BookTest.initEntityManager(BookTest.java:42)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
   at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
   at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
   at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:27)
   at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
   at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
   at org.junit.runner.JUnitCore.run(JUnitCore.java:157)
   at
com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:94)
   at
com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:192)
   at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:64)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at com.intellij.rt.execution.application.AppMain.main(AppMain.java:115)
{code}

Attached is the entity and the unit test that makes it break. The Maven project uses
GlassFish (EclipseLink) by default, so you can make it run using {{mvn -Pjboss test}}.
Also you need the Derby database running (I'm not using an inmemory DB for this test)

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

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

[hibernate-issues] [Hibernate-JIRA] Created: (HHH-5713) Member of doesn't work with a @ElementCollection of String