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