db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stian Brattland <st...@brattland.no>
Subject Streaming Results
Date Thu, 14 Jan 2010 07:43:32 GMT
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

Mime
View raw message