Hello Janardhan, JAWS was replaced with JBossCMP a long time ago and is not supported anymore. Sorry, I really don't know what is wrong with your finder.
alex Tuesday, July 01, 2003, 12:03:42 PM, Janardhan Burugupalli wrote: JB> Hi All, JB> I have a finder defined in the jwas.xml like this below JB> <finder> JB> <name>findAllOrdered</name> JB> <query/> JB> <order>CREATINGTIME DESC</order> JB> </finder> JB> i dont have any query because i want all results only in the Creating JB> time desc format JB> but jboss is generating the following sql query JB> 2003-07-01 10:55:24,007 DEBUG JB> [org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand] findAllOrdered command JB> executing: SELECT PeerTask.OID, CREATINGTIME FROM PeerTask where ORDER JB> BY CREATINGTIME DESC JB> in the above sql statement there should not be a where condition as the JB> query has nothing in it which is generated by Jboss JB> can any one help me urgently how to fix this JB> thanks janardhan ------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user