org.hibernate.QueryException: illegal attempt to dereference collection

Question

I am trying following hql query to execute

SELECT count(*) 
  FROM BillDetails as bd
 WHERE bd.billProductSet.product.id = 1002
   AND bd.client.id                 = 1

But it is showing

org.hibernate.QueryException: illegal attempt to dereference collection 
[billdetail0_.bill_no.billProductSet] with element property reference [product] 
[select count(*) from iland.hbm.BillDetails as bd where bd.billProductSet.product.id=1001 and bd.client.id=1]
    at org.hibernate.hql.ast.tree.DotNode$1.buildIllegalCollectionDereferenceException(DotNode.java:68)
    at org.hibernate.hql.ast.tree.DotNode.checkLhsIsNotCollection(DotNode.java:558)

Can you add your classes' definitions? Do they contain relationship definitions in them? — AlikElzin-kilaka
– AlikElzin-kilaka, Commented Jan 24, 2016 at 8:43

kostja · Accepted Answer · 2015-07-24 12:43:54Z

171

billProductSet is a Collection. As such, it does not have an attribute named product.

Product is an attribute of the elements of this Collection.

You can fix the issue by joining the collection instead of dereferencing it:

SELECT count(*) 
  FROM BillDetails        bd 
  JOIN bd.billProductSet  bps 
 WHERE bd.client.id       = 1
   AND bps.product.id     = 1002

edited Jul 24, 2015 at 12:43

answered Jul 15, 2014 at 6:16

kostja

61.8k51 gold badges186 silver badges227 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Stony Over a year ago

It doesn't work in my testing, if billProductSet is got be @JoinTable, and the relation is ManyToMany.

Andrea Ligios Over a year ago

@Stony It does work with @JoinTable and @ManyToMany. I've that running right now.

Cavaleiro Over a year ago

Just for reference: in my case I was already doing the join of the collection but without giving it an alias it won't work. Thanks!

S_K Over a year ago

Only JOIN isn't worked for me. I used LEFT JOIN for my query.

Soumen Ghosh Over a year ago

your answer saved me a lot of time. Thanks.

J.K · Accepted Answer · 2016-11-19 11:13:03Z

1

because billProduct is one to many mapping and there is many billProduct entity from one BillDetails entity you can't dereference it in query.you must join BillDetails model to billProduct and filter result with where cluase.

answered Nov 19, 2016 at 11:13

J.K

112 bronze badges

Collectives™ on Stack Overflow

org.hibernate.QueryException: illegal attempt to dereference collection

2 Answers 2

5 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related