Platform: Jbuilder 9 Server:jboss-3.0.3_tomcat-4.1.12 i have to sort data by one column in a CMP. though i copy following statements from ejb-jar.xml to jbosscmp-jdbc.xml, these statements disappear after i rebuild the application.
<query-method> <method-name>findByTypeID</method-name> <method-params> <method-param>java.lang.Integer</method-param> </method-params> </query-method> <ejb-ql>SELECT OBJECT(i) FROM TblWebInfo AS i WHERE i.infoTypeID=?1 ORDER BY i.pbulishTime DESC</ejb-ql> and system throws following information: actually that ejb-ql is used for another table, not TblWebProduct. Depends On Me: , ObjectName: jboss.j2ee:jndiName=TblWebProduct,service=EJB state: FAILED I Depend On: Depends On Me: org.jboss.deployment.DeploymentException: Error compiling ejbql; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountere d "ORDER" at line 1, column 61. Was expecting one of: "AND" ... "OR" ... "+" ... "-" ... "*" ... "/" ... )] then how i can use ORDER BY clause in JBoss under Jbuilder9? I am appreciated if you can give me piece of advice. <a href="http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3826083#3826083">View the original post</a> <a href="http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3826083>Reply to the post</a> ------------------------------------------------------- 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