Postgres Jdbc Driver [better] -
<dependency> <groupId>org.postgresql</groupId> <artifactId>postgresql</artifactId> <version>42.7.2</version> </dependency>
String insert = "INSERT INTO users (name, email) VALUES (?, ?)"; try (PreparedStatement pstmt = conn.prepareStatement(insert, Statement.RETURN_GENERATED_KEYS)) pstmt.setString(1, "John"); pstmt.setString(2, "john@example.com"); pstmt.executeUpdate(); ResultSet keys = pstmt.getGeneratedKeys(); if (keys.next()) long id = keys.getLong(1);
<dependency> <groupId>org.postgresql</groupId> <artifactId>postgresql</artifactId> <version>42.7.3</version> <!-- Check for latest --> </dependency> postgres jdbc driver
pgJDBC is an open source JDBC driver written in Pure Java (Type 4), and communicates in the PostgreSQL native network protocol. PostgreSQL JDBC Driver Initializing the Driver - PostgreSQL JDBC Driver
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); <dependency> <groupId>org
The air in the server room was cool, but Elias was sweating.
pstmt.setObject(1, UUID.randomUUID()); UUID id = rs.getObject("id", UUID.class); The errors were weird
He pulled up the stack trace on his monitor. The errors were weird. SSLHandshakeException , followed immediately by Connection refused , followed by IO Error: The Network Adapter could not establish the connection . It was chaotic. It didn't look like a config issue. It looked like a language barrier. The Java application and the Postgres database were shouting at each other in different dialects.
