Hibernate NamedQuery two parameters

Asked Feb 13 '15 at 09:46

Active Feb 13 '15 at 09:53

Viewed 81 times

I want to create NamedQuery like this:

@NamedQuery(name = Advertisement.getBySubcategoryList, query = "From Advertisement where subcategoryId IN (:subcategoryId) order by :sort :order "),

But on IDE i see error, that i cant set parameter after parameter: :sort :order

Do you know how to create this query ?

Thanks

StackTrace:

 ERROR: org.hibernate.internal.SessionFactoryImpl - HHH000177: Error in named query: Advertisement.getBySubcategoryList
org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: : near line 1, column 101 [From org.ogloszenia.app.domain.Advertisement where subcategoryId IN (:subcategoryId) order by :sort :order ]

edited Feb 13 '15 at 09:53

asked Feb 13 '15 at 09:46

Ilkar

2,113
9
45
71

Please share full stacktrace – erhun Feb 13 '15 at 09:49
2

possible duplicate of [Hibernate Named Query Order By parameter](http://stackoverflow.com/questions/4120388/hibernate-named-query-order-by-parameter) – Paco Abato Feb 13 '15 at 09:50
not supported for that you have create query and concat the sortBy to that query – singhakash Feb 13 '15 at 10:05

Hibernate NamedQuery two parameters

0 Answers0