import java.sql.*;




/** A quick test of the fetch size stuff.
 *
 * @author Nic Ferrier <nferrier@tapsellferrier.co.uk>
 */
public class fetchsize
{

  public static void main (String[] argv) throws Exception
  {
    Class driver = Class.forName("org.postgresql.Driver");
    Connection con = DriverManager.getConnection("jdbc:postgresql:test", "nferrier", "killa77");
    con.setAutoCommit(false);
    Statement st = con.createStatement();
    st.setFetchSize(1);
    ResultSet rs = st.executeQuery("select * from t1;");
    // ResultSet rs = st.executeQuery("BEGIN; DECLARE JDBC_CURS_1 CURSOR FOR select * from t1 ;"
    // 				   + "FETCH FORWARD 0 FROM JDBC_CURS_1;");
    while (rs.next()) {
      System.out.println(rs.getString(1));
    }
    con.commit();
    st.close();
    con.close();
  }
}
