1 Reply Latest reply on Sep 5, 2002 8:21 PM by Peter Ineson

    return top 10 rows when query

    hongmei Newbie

      hi, all.

      I am using jboss3.0.0+jetty, and I want to have a findby method to return top 10 rows in some order, but when I deployed onto jboss using the following descriptor in jbosscmp-jdbc.xml, it gave me an expcetion complaining about"...org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "weight" at line 2,column 113.Was expecting one of:<NUMERIC_VALUED_PATH> ...
      Any idea?

      the part for this findby in jbosscmp-jdbc.xml is:

      <![CDATA[SELECT OBJECT(a) FROM Concept AS a WHERE a.description LIKE ?1 ORDER BY weight DESC ]]>