import java.sql.*;

public class AutoCommitMaxRows {
	public static void main(String args[]) throws Exception {
		Class.forName("org.postgresql.Driver");
		Connection conn = DriverManager.getConnection("jdbc:postgresql://localhost:5810/jurka","jurka","");

		conn.setAutoCommit(true);

		Statement stmt = conn.createStatement();
		stmt.setMaxRows(2);

		if (stmt.execute("SELECT * FROM information_schema.parameters")) {
			ResultSet rs = stmt.getResultSet();
			while (rs.next()) {
				System.out.println("got row");
			}
		}

		conn.close();
	}
}