You can try to set the JDBC-level tag in repository.xml to "1.0". This will trigger usage of forward only resultsets.
cheers, Thomas > -----Urspr�ngliche Nachricht----- > Von: Matt Mastrangelo [mailto:[EMAIL PROTECTED]] > Gesendet: Montag, 16. Dezember 2002 21:18 > An: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Betreff: Cannot Use Forward Only ResultSets > > > 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. > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
