Returning large resultset problems

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

[599 byte] By [dhaval_shaha] at [2007-11-27 11:50:25]