did you tried latest from CVS, I think Jakob fixed a similar problem yesterday.
http://www.mail-archive.com/ojb-user%40db.apache.org/msg09400.html
regards, Armin
Stephen Ting wrote:
I encounter a bug in PB api, whenever i pass the order by attribute at
Criteria object instead of Query object, i will get error in the
broker.getCount(query);
OJB will generate an invalid SQL query which look like SELECT count(*),A0.LABEL as ojb_col_1,A0.RECEIVING_DATE as ojb_col_2
FROM LOG_RECEIVING A0 ORDER BY 2,3
whereas if i add the order by criteria at Query object it will be
correct
SELECT count(*) FROM LOG_RECEIVING A0
Regards,
Stephen
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
