I am having some difficulties creating a hibernate query using both named parameters and the %.

For instance when i search for a certain product using a named query and named parameters it looks like this :

<query name="searchProducts">
<![CDATA[from Product where amount != 0 and namelike %:searchText% or title like %:searchText%]]>
</query>

I can't get it to work.

Can anybody help me out?

Thank you.

You'll have to put the %s in the bound variable, not in the HQL.
Alternatively, you could use Criteria: the like/ilike Restrictions allow MatchMode.ANYWHERE.