Try setting: <query>true</query>
On Tue, 2003-07-01 at 10:55, Alexey Loubyansky wrote: > 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 -- Peter Beck BEng (hons) MIEE - Managing Director, Electrostrata Ltd. http://www.electrostrata.com --+-+-- Experts in e-business and e-commerce ------------------------------------------------------- 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