My query is:

from ResourceTable where resourceId is in ('1','3','13','14','15','16','17','18','19','20','21','7','8','9','10')

I've also tried formatting the list as
(1,2,3)
(1, 2, 3)
('1', '2', '3')
1,2,3
and
1, 2, 3

Invariably, I get

Data Access Failure

unexpected token: in near line 1, column 60 [from com.company.model.ResourceTable where resourceId is in ('1','3','13','14','15','16','17','18','19','20','21','7','8','9','10')]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: in near line 1, column 60 [from com.company.model.ResourceTable where resourceId is in ('1','3','13','14','15','16','17','18','19','20','21','7','8','9','10')]

Does anyone have any pointers on successful use of the "is in" syntax for HQL?

Lose the 'is'.