How to Connect to PostgreSQL in Java: Simple Guide

To connect to PostgreSQL in Java, use the JDBC API with the PostgreSQL driver. Load the driver class org.postgresql.Driver, then create a connection using DriverManager.getConnection with your database URL, username, and password.

Syntax

Here is the basic syntax to connect to PostgreSQL using Java JDBC:

• Load Driver: Load the PostgreSQL JDBC driver class.
• Connection URL: Use the format jdbc:postgresql://host:port/database.
• Get Connection: Use DriverManager.getConnection(url, user, password) to connect.

java

Class.forName("org.postgresql.Driver");
Connection conn = DriverManager.getConnection(
    "jdbc:postgresql://localhost:5432/mydb", "username", "password"
);

Example

This example shows a complete Java program that connects to a PostgreSQL database, prints a success message, and closes the connection.

java

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class PostgresConnectExample {
    public static void main(String[] args) {
        String url = "jdbc:postgresql://localhost:5432/mydb";
        String user = "username";
        String password = "password";

        try {
            Class.forName("org.postgresql.Driver");
            Connection conn = DriverManager.getConnection(url, user, password);
            System.out.println("Connected to PostgreSQL successfully.");
            conn.close();
        } catch (ClassNotFoundException e) {
            System.out.println("PostgreSQL JDBC Driver not found.");
            e.printStackTrace();
        } catch (SQLException e) {
            System.out.println("Connection failure.");
            e.printStackTrace();
        }
    }
}

Output

Connected to PostgreSQL successfully.

Common Pitfalls

• Missing Driver: Forgetting to add the PostgreSQL JDBC driver to your project causes ClassNotFoundException.
• Wrong URL: Incorrect JDBC URL format or wrong port/database name leads to connection failure.
• Invalid Credentials: Using wrong username or password causes authentication errors.
• Not Closing Connection: Always close the connection to avoid resource leaks.

java

/* Wrong way: Missing driver load */
Connection conn = DriverManager.getConnection(
    "jdbc:postgresql://localhost:5432/mydb", "user", "pass"
);

/* Right way: Load driver first */
Class.forName("org.postgresql.Driver");
Connection conn = DriverManager.getConnection(
    "jdbc:postgresql://localhost:5432/mydb", "user", "pass"
);

Quick Reference

Remember these key points when connecting to PostgreSQL in Java:

• Use the correct JDBC URL format: jdbc:postgresql://host:port/database
• Load the driver class org.postgresql.Driver before connecting
• Handle SQLException and ClassNotFoundException properly
• Close your Connection to free resources

Key Takeaways

Always load the PostgreSQL JDBC driver class before connecting.

Use the correct JDBC URL format with host, port, and database name.

Handle exceptions to catch connection and driver loading errors.

Close the database connection to avoid resource leaks.

Add the PostgreSQL JDBC driver library to your project dependencies.