Please use the Apache issue tracking system for new NetBeans issues ( !!
Bug 155219 - Certain subselect queries doesn't work in the HQL Editor
Certain subselect queries doesn't work in the HQL Editor
Product: javaee
Classification: Unclassified
Component: Hibernate
All All
: P2 (vote)
: 6.x
Assigned To: Vadiraj Deshpande
Depends on:
  Show dependency treegraph
Reported: 2008-12-11 12:11 UTC by Jan Horvath
Modified: 2009-02-19 23:27 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT

IDE log file (702.21 KB, text/plain)
2008-12-12 06:21 UTC, Vadiraj Deshpande

Note You need to log in before you can comment on or make changes to this bug.
Description Jan Horvath 2008-12-11 12:11:51 UTC
I'm not able to run a query with subselect in the HQL Editor. Sakila db is used here:

from Actor as actor where actor.actorId in (select from FilmActor as filmActor where

However another query works fine:

from Actor as actor where (select count( from actor.filmActors as f) > 10
Comment 1 Vadiraj Deshpande 2008-12-12 06:19:14 UTC
Reproducible in latest build. May be this is due error in pre-processing of mapping files. Here's the exception :
org.hibernate.DuplicateMappingException: Duplicate collection role mapping sakila.Actor.filmActors
        at org.hibernate.cfg.Mappings.addCollection(
        at org.hibernate.cfg.HbmBinder.createClassProperties(
        at org.hibernate.cfg.HbmBinder.createClassProperties(
        at org.hibernate.cfg.HbmBinder.bindRootPersistentClassCommonValues(
        at org.hibernate.cfg.HbmBinder.bindRootClass(
        at org.hibernate.cfg.HbmBinder.bindRoot(
        at org.hibernate.cfg.Configuration.add(
Comment 2 Vadiraj Deshpande 2008-12-12 06:21:17 UTC
Created attachment 74876 [details]
IDE log file
Comment 3 Vadiraj Deshpande 2008-12-12 09:47:31 UTC
Comment 4 Jan Horvath 2008-12-12 12:10:40 UTC
Comment 5 Vadiraj Deshpande 2008-12-13 17:24:51 UTC
Adjusting the target milestone.
Comment 6 pslechta 2008-12-16 14:19:47 UTC
The fix was ported into release65_fixes repository.

By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2014, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo