How can I get the same effect as an Order By query on an existing CachedRowSet?

Remember that RowSets are extensions of ResultSets and were not designed as mini-databases. Probably the easiest way to handle new orders is to use the toCollection method, create an ordered Collection and work off the data from there.

The other way would be to read the data ( possibly again into a Collection ) sort it and then create a new RowSet using the insertRow method or with your own Reader.