When I modified dynamic query to use literal with "LIKE" it's still give me the same error.
SELECT ic.investmentCompanyId FROM InvestmentCompany ic WHERE ic.investmentCompanyTypeCd <> 'D' AND UCASE(ic.investmentCompanyName) LIKE 'A%' AND ic.investmentCompanyTypeCd = ?1 ORDER BY ic.investmentCompanyId
This is a bug, I think. Is anybody using DynamicQL with "LIKE"? (Is anybody wants to use DynamicQL with "LIKE"?)
Forgot to include jboss version:
3.0.1 Date 200208062340
You can't use a function in the like clause. You should be able to do this, but I forgot to add it to the grammer. Can you file a feature request at source fourge on this?
Just did it.