Hi Burkhard (and others),
No, the <query> and <order> entities are both required in jaws.xml
However, i discovered that it the empty where is caused by the fact that my
method name ("findByAll") contains the "By"-word....! When i rename it to
findAll everything works fine. This explains why nobody else seems to run
into these kinds of trouble...
Thanks for your help anyway.
Cheers,
Peter.
> 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
>>
>
-------------------------------------------------------
Bringing you mounds of caffeinated joy
>>> http://thinkgeek.com/sf <<<
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
