• Post Reply Bookmark Topic Watch Topic
  • New Topic

HQL not in

 
anas ma
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi !



i don't know why this HQL show me this error
antlr.NoViableAltException: unexpected token: in
not in don't exist on Hql or what ?
 
Roel De Nijs
Sheriff
Posts: 10763
148
AngularJS Chrome Eclipse IDE Hibernate Java jQuery MySQL Database Spring Tomcat Server
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi anas ma,

First of all, a warm welcome to CodeRanch!

anas ma wrote: not in don't exist on Hql or what ?

It definitely exists in JPQL, but only if you use the correct syntax

So the correct syntax for the (NOT) IN operation isApplied to your query it would probably be something like

Hope it helps!
Kind regards,
Roel
 
anas ma
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thaanks ^^
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!