"invalid database address" for PostgreSQL in JDBC

Question

I use PostgreSQL to create my database and save my users list to it, when i try to connect db by java jdbc, i get error that say:

"java.sql.SQLException: invalid database address: jdbc:postgresql://localhost:5432/users".

i use "JDBC41 Postgresql Driver, Version 9.3-1102" from PostgreSQL website. and this is my code:

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

public class javaconnect {

private static Connection c = null;

public static Connection connectDb() {

    try {
        Class.forName("org.postgresql.Driver");
        c = DriverManager.getConnection("jdbc:postgresql://localhost:5432/users", "postgres", "12345");
        return c;
    } catch (ClassNotFoundException | SQLException e) {
        System.err.println(e.getClass().getName() + ": " + e.getMessage());
        System.exit(0);
        return null;
    }

}
}

Thanks.

Santhosh · Accepted Answer · 2014-11-05 07:03:16Z

6

As the error,

"java.sql.SQLException: invalid database address:

says your database name is incorrect . check for the database name if you have something like sql developer installed.

Valid database name should be specified here "jdbc:postgresql://localhost:5432/users" after the /localhost:5432/

Read JDBC using postgresql to connect to PostgreSQL database using jdbc

answered Nov 5, 2014 at 7:03

Santhosh

8,2355 gold badges32 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Foad Tahmasebi Over a year ago

Thank you, i was used table name instead db name :D

Collectives™ on Stack Overflow

"invalid database address" for PostgreSQL in JDBC

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related