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

Reply via email to