Hi,
I've got a question regarding results streaming. The J/Connector for
MySQL supports results streaming, which means
that you can stream and process rows in a ResultSet one by one.
Normally, all rows in a ResultSet will be retrived
before you can process the ResultSet. However, i am curious as to wether
this "feature" also exists in Derby?
In MySQL, you would do the following to stream results from the database
as you iterate through a ResultSet:
stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY,
java.sql.ResultSet.CONCUR_READ_ONLY);
stmt.setFetchSize(Integer.MIN_VALUE);
Kind regards,
Stian Brattland