Babar.java

text/x-java

Download

// CREATE UNLOGGED TABLE foo(a int);
// INSERT INTO foo SELECT * FROM generate_series(1, 200000);

public class Babar {
    public static void main(String[] args)
            throws ClassNotFoundException, java.sql.SQLException {
        Class.forName("org.postgresql.Driver");

        java.sql.Connection conn =
            java.sql.DriverManager.getConnection(
                "jdbc:postgresql://127.0.0.1:5434/postgres?user=postgres"
            );

        conn.setAutoCommit(false);

        java.sql.ResultSet rs;

        java.sql.PreparedStatement stmt =
            conn.prepareStatement(
                "SELECT * FROM foo ORDER BY a OFFSET ? LIMIT 2"
            );

        java.sql.PreparedStatement stmt2 =
            conn.prepareStatement(
                "SELECT 1"
            );

	stmt.setInt(1, 100000);

        rs = stmt.executeQuery();
        rs.close();
        stmt.close();

        rs = stmt2.executeQuery();
        rs.close();
        stmt2.close();

        conn.commit();
        conn.close();
    }
}