Hi,

I get incorrect SQL generated for finders with empty where clause, but 
with a (non-empty) order by, e.g.:

in jaws.xml:
      
<finder><name>findByAll</name><query></query><order>name</order></finder>

in the server log:
      2002-06-13 10:37:22,742 DEBUG 
[org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand] findByAll command 
executing: SELECT department.objectid, name FROM department where  ORDER 
BY name

which causes an sql parse error on "where order by"...

Is this is known bug, or did i miss something w.r.t. jaws.xml syntax 
or....? It did work in 2.4.4. Of course, there is a simple work-around 
by supplying a dummy where clause, but i'm just curious if i'm doing 
something wrong or if anybody else run into similar problems....

Regards,
Peter



_______________________________________________________________

Don't miss the 2002 Sprint PCS Application Developer's Conference
August 25-28 in Las Vegas - 
http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink

_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to