I am trying to use the LIKE keyword in a finder with a wildcard, using an input parameter, I want the ejb ql to look like this: SELECT OBJECT(i) FROM Person i WHERE i.lastName LIKE ?1%
I have used LIKE '?1%', (obviously doesn't work, looks for last names that start with ?1. so I tried LIKE CONCAT(?1,'%'). The descriptor won't parse, compains about expecting a string literal after the LIKE keyword. I have tried several other configurations as well, and nothing I do works. Either the descriptor won't parse, or the ejb ql doesn't do what I want. I am fairly sure this is not a new issue, but i cannot find the solution. I have read the spec, and it says I should be able to do LIKE CONCAT(?1,'%'). I also rigorously inspected a deployment descriptor from a different app that is running in a different app server, and it is written JUST LIKE THAT. Imagine my frustration. I can only assume I am making a noob error, but if you could, would you please let me know what it is. Your help is appreciated. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3830295#3830295 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3830295 ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
