Hi, AFAIK, a <query></query> means query = empty (!=null) try <finder><name>findByAll</name><order>name</order></finder> hth Burkhard ----- Original Message ----- From: "Peter Doornbosch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 13, 2002 3:54 AM Subject: [JBoss-user] EJB finder with order by and empty where clause generates incorrect SQL
> 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 > _______________________________________________________________ Sponsored by: ThinkGeek at http://www.ThinkGeek.com/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
