The PersistenceBroker always seems to use scrollable ResultSets when querying using both getCollectionByQuery and getIteratorByQuery. When using the Oracle JDBC driver, scrollable ResultSets are stored entirely in system memory whereas forward only ResultSets are not. Therefore, even if you want to get only a small range of records, the entire ResultSet is loaded into memory.
Is it possible to specify the type of ResultSet being used by OJB (either scrollable or forward only). Thanks.
