I'm guessing here, but:Hi Dan,
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.
I made it so that i was equating a filed with thee same
like <finder>
<name>findAllOrdered</name>
<query>OID = OID<query/>
<order>CREATINGTIME DESC</order>
</finder>
OID is a primary key field.
tha above code works but it just a work around
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