I'm facing the very same problem.
I have a query (on Postgres) with an order by clause, and the query results are OK when browsed with the console.
But when the query is executed by iBats, and the result map applies the groupBy clause, the ordering is not the same.
Please, post here the solution for this problem if you find it. I'll do the same.
Thank you
[ December 14, 2008: Message edited by: Corrado Alesso ]