I'm guessing here, but: 1) Can you remove the <query/> element? Does this stop JBoss from generating the where clause? 2) Can you set the query to something like "1=1"?
Dan. -- Danny Yates -----Original Message----- From: Janardhan Burugupalli [mailto:[EMAIL PROTECTED] Sent: 01 July 2003 10:04 To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Finder generating wrong SQL statement in Jboss-3.2.1 Hi All, I have a finder defined in the jwas.xml like this below <finder> <name>findAllOrdered</name> <query/> <order>CREATINGTIME DESC</order> </finder> i dont have any query because i want all results only in the Creating time desc format but jboss is generating the following sql query 2003-07-01 10:55:24,007 DEBUG [org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand] findAllOrdered command executing: SELECT PeerTask.OID, CREATINGTIME FROM PeerTask where ORDER BY CREATINGTIME DESC in the above sql statement there should not be a where condition as the query has nothing in it which is generated by Jboss can any one help me urgently how to fix this 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 _____________________________________________________________________ Notice to recipient: The information in this internet e-mail and any attachments is confidential and may be privileged. It is intended solely for the addressee. If you are not the intended addressee please notify the sender immediately by telephone. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to external clients any opinions or advice contained in this internet e-mail are subject to the terms and conditions expressed in any applicable governing terms of business or client engagement letter issued by the pertinent Bank of America group entity. If this email originates from the U.K. please note that Bank of America, N.A., London Branch, Banc of America Securities Limited and Banc of America Futures Incorporated are regulated by the Financial Services Authority. _____________________________________________________________________ ------------------------------------------------------- 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