unable to use ORDER BY clause
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=3826085#3826085";>View
the original post</a>
<a
href="http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3826085>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-Development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
