0 Replies Latest reply on Dec 29, 2006 9:50 AM by leo costa

    EJB QL Query Problem using LIKE adn ORDER BY operator

    leo costa Newbie

      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!