0 Replies Latest reply on Sep 24, 2004 1:48 PM by lorange

    EJB QL Error Using LIKE Statement

    lorange Newbie

      Hello,

      I would appreciate anyone's help/insight on this problem:

      I'm using jboss-3.2.3 and in a finder method am using the following EJB QL statement:

      SELECT OBJECT(st) FROM StockType st WHERE st.stockTypeCode LIKE 'BLANK%'

      which gets put into the ejb-jar.xml as:

      <ejb-ql>
      <![CDATA[SELECT OBJECT(st) FROM StockType st WHERE st.stockTypeCode LIKE 'BLANK%']]>
      </ejb-ql>

      When starting jboss, I get the following error:

      org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement ''; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: FROM not found) at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery. (JDBCEJBQLQuery.java:50) at ...

      Thank you in advance!

      Lorange