According to the javadoc: _Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for ResultSet objects genrated by this Statement. If the value specified is zero, then the hint is ignored. The default value is zero. @param rows the number of rows to fetch @exception SQLException if a database access error occurs, this method is called on a closed <code>Statement</code> or the condition rows >= 0 I think you have to set the fetch size before executing the query and it does depend on the driver implimentation and the database if the entire query is executed up front or not. I cannot tell you the level of implimentation provided by SQL Server; I'm guessing around nothing. Panic, Chaos, Destruction. My work here is done. _

No i did this last week. Didn't set anything else. webtools.java: private void jButton13ActionActionPerformed(ActionEvent event) { cmdExec cmd = new cmdExec(); String s = (cmd.run("ping www.google.co.uk")); jTextPane0.setText(jTextPane0.getText() + s + "\n-----------------------------\n"); } cmdExec.java: package webtools; import java.io.BufferedReader; import java.io.InputStreamReader; public class cmdExec { public String run(String cmdLine) { String line; String output = ""; try { Process p = Runtime.getRuntime().exec(cmdLine); BufferedReader input = new BufferedReader (new InputStreamReader(p.getInputStream())); while ((line = input.readLine()) != null) { output += (line + '\n'); } input.close(); } catch (Exception ex) { ex.printStackTrace(); } return output; } } Neonlight modified on Wednesday, April 22, 2009 10:13 AM