FiteredRowSet question

I think I can see how to use a FilteredRowSet, how to build the filter etc. But, FilteredRowSet is a subclass of CachedRowSet and CachedRowSet has the toCollection methods. If I call the toCollection method on a FilteredRowSet with a filter do I get everything or will my returned collection be filtered as well?

Thanks

[332 byte] By [sasdava] at [2007-10-2 19:24:15]
# 1
If it wasn't designed by chimpanzees then you should get only the filtered rows in your collection. If it doesn't work like that, then file a bug report. Unless the API documentation says it will work wrong.
DrClapa at 2007-7-13 21:09:16 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2

The documentation doesn't say anything one way or another that I've been able to find, so I'll just try it and see what happens.

What I really need, though, is a RowSet that I can populate, then disconnect from the source, then pass SQL statements to in order to subset the data further without having to reconnect.

Anybody seen anything like that?

sasdava at 2007-7-13 21:09:16 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...