| PostgreSQL | JDBC Driver Version | |------------|---------------------| | 16.x | 42.7.x | | 15.x | 42.6.x - 42.7.x | | 14.x | 42.4.x - 42.7.x | | 13.x | 42.2.x - 42.7.x | | 12.x | 42.2.x - 42.7.x | | 11.x | 42.2.x - 42.7.x | | 10.x | 42.2.x - 42.7.x | | 9.6 | 42.2.x - 42.3.x |
Load driver (automatic since JDBC 4+):
jdbc:postgresql://localhost/mydb?ssl=true&sslmode=require¤tSchema=public&connectTimeout=10&ApplicationName=MyJavaApp 4.1 Query Execution // Statement try (Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("SELECT id, name FROM users")) while (rs.next()) int id = rs.getInt("id"); String name = rs.getString("name"); postgres jdbc driver
8.1 Common Errors | Error | Solution | |-------|----------| | The connection attempt failed | Check PostgreSQL running, firewall, pg_hba.conf | | No suitable driver found | Add JDBC jar to classpath | | FATAL: no pg_hba.conf entry | Add client IP/method to pg_hba.conf | | PSQLException: This connection has been closed | Reconnect or use connection pool | | PSQLException: Out of memory | Increase JVM heap or reduce result set size | 8.2 Best Practices Checklist ✅ Always use PreparedStatement (prevents SQL injection) ✅ Use try-with-resources for automatic closing ✅ Implement connection pooling (HikariCP) ✅ Set reasonable timeouts (connect, socket, login) ✅ Use fetchSize for large result sets It translates JDBC calls into PostgreSQL's wire protocol
CopyManager copyManager = ((PGConnection) conn).getCopyAPI(); String sql = "COPY users (name, email) FROM STDIN"; CopyIn copyIn = copyManager.copyIn(sql); BufferedWriter writer = new BufferedWriter(new OutputStreamWriter(copyIn)); writer.write("Alice\talice@example.com\n"); writer.write("Bob\tbob@example.com\n"); writer.close(); long rows = copyIn.getHandledRowCount(); 7.3 Logical Replication (PG 10+) PGConnection pgConn = conn.unwrap(PGConnection.class); PGReplicationStream stream = pgConn.getReplicationAPI() .replicationStream() .logical() .withSlotName("test_slot") .withSlotOption("proto_version", "1") .withSlotOption("publication_names", "mypub") .start(); while (true) ByteBuffer msg = stream.readPending(); if (msg != null) // process changes ResultSet rs = stmt.executeQuery("SELECT id
with your PostgreSQL version. 10. Complete Example (Production-Ready) public class PostgresDao private final HikariDataSource dataSource; public PostgresDao() HikariConfig config = new HikariConfig(); config.setJdbcUrl("jdbc:postgresql://localhost:5432/mydb"); config.setUsername(System.getenv("DB_USER")); config.setPassword(System.getenv("DB_PASS")); config.setMaximumPoolSize(10); config.addDataSourceProperty("cachePrepStmts", "true"); config.addDataSourceProperty("prepStmtCacheSize", "250"); config.addDataSourceProperty("prepStmtCacheSqlLimit", "2048"); this.dataSource = new HikariDataSource(config);
A type 4 JDBC driver that allows Java applications to connect to a PostgreSQL database using standard JDBC APIs. It translates JDBC calls into PostgreSQL's wire protocol (libpq).