A-hah! ----- Original Message ----- From: "Gelhar, Wallace Joseph" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Sent: Thursday, September 30, 2004 1:51 PM Subject: RE: Simple DISTINCT query
getCollectionByQuery(q) is not the correct method call for a Report Query. Try broker.getReportQueryIteratorByQuery(q); which returns an Iterator of Object[]. ReportQueryByCriteria q = QueryFactory.newReportQuery (BillItem.class, c, true); q.setAttributes(new String[] { "billingRun" }); q.addOrderByDescending("billingRun"); DataStore ds = new DataStore (user); Collection result = ds.getCollectionByQuery(q); // <--- exception is thrown here --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]