This article explores how to effectively use the official driver, covering setup, CRUD operations, connection pooling, and advanced features like LISTEN / NOTIFY and COPY . The PostgreSQL JDBC Driver (Group ID: org.postgresql , Artifact ID: postgresql ) is a Type 4 JDBC driver. This means it’s written purely in Java and connects directly to the database using the PostgreSQL wire protocol—no native libraries or ODBC bridges required.
conn.setAutoCommit(false); // Required for streaming PreparedStatement pstmt = conn.prepareStatement("SELECT * FROM large_table"); pstmt.setFetchSize(1000); // Fetch in chunks of 1000 rows try (ResultSet rs = pstmt.executeQuery()) while (rs.next()) processRow(rs); // No memory blow-up postgresql java driver
for (int i = 0; i < 10000; i++) pstmt.setString(1, "data" + i); pstmt.addBatch(); This article explores how to effectively use the
This article explores how to effectively use the official driver, covering setup, CRUD operations, connection pooling, and advanced features like LISTEN / NOTIFY and COPY . The PostgreSQL JDBC Driver (Group ID: org.postgresql , Artifact ID: postgresql ) is a Type 4 JDBC driver. This means it’s written purely in Java and connects directly to the database using the PostgreSQL wire protocol—no native libraries or ODBC bridges required.
conn.setAutoCommit(false); // Required for streaming PreparedStatement pstmt = conn.prepareStatement("SELECT * FROM large_table"); pstmt.setFetchSize(1000); // Fetch in chunks of 1000 rows try (ResultSet rs = pstmt.executeQuery()) while (rs.next()) processRow(rs); // No memory blow-up
for (int i = 0; i < 10000; i++) pstmt.setString(1, "data" + i); pstmt.addBatch();