I have a finder method to query the client's name. SELECT OBJECT(a) FROM XXX AS a WHERE a.name LIKE... My question is the expression '%'+?1+'%' is wrong. The result of the expression '%?1%' is not my desire.How to merge input parameter with '%' or '_'.
posted 14 years ago
Now I know all ranchers are too busy to help a new java fan! After try many times,last night I overcome the EJBQL question.The answer is add "%"+parameter+"%" in my session facade before my entity finder method.