I've got a problem returning a large resultset (approx 1.2-1.5 million rows), in that sometimes the query doesn't run to completion because either I'm pretty sure the client keels over, dies, you get the picture. I've used
stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY,
java.sql.ResultSet.CONCUR_READ_ONLY);
stmt.setFetchSize(Integer.MIN_VALUE);
to try and stream the resultset but I'm not sure if it is. If not, could anyone suggest how I perform such an operation, or else suggest a way to deal with such a large set of results.
Thanks