// This is auto-detected as READ WRITE → goes to primary conn.createStatement().executeUpdate("INSERT INTO users VALUES (1)"); conn.commit();

// This is READ ONLY → goes to a replica (round-robin) conn.setReadOnly(true); ResultSet rs = conn.createStatement().executeQuery("SELECT * FROM users");

Postgresql Driver Jdbc Best May 2026

// This is auto-detected as READ WRITE → goes to primary conn.createStatement().executeUpdate("INSERT INTO users VALUES (1)"); conn.commit();

// This is READ ONLY → goes to a replica (round-robin) conn.setReadOnly(true); ResultSet rs = conn.createStatement().executeQuery("SELECT * FROM users"); postgresql driver jdbc