NOTE: If you use special characters such as '%' in the query, use them as binding parameter value.
For example, do not use query as
select m from Movie m where m.title like '%CHINA%'
Instead use
select m from Movie m where m.title like :title
and then set the value of named parameter title to %CHINA%
If using named query, check the Named Query Box.