[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - EJB QL Query Problem using LIKE adn ORDER BY operator

[tok199hz]

Hi all,
I have to use some queries with LIKE and ORDER BY operators. Is correct to override ejb-ql in ejb-jar.xml writing these queries in jbosscmp-jdbc.xml file using <jboss-ql>...</jboss-ql>?
have I to use ...LIKE CONCAT(?1,'%')...?
hope this is the rights place,
thanks!

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3996864#3996864

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3996864