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 
 

Reply via email to