Cannot connect to heroku PostgreSQL db

Question

I will connect with a simple java programme to my heroku Postgres database. But if i try to connect i get an error. Can anyone explain me the problem or can solve this problem?

Thx :D

Code:

public static void main(String[] args) throws InstantiationException,
        IllegalAccessException, ClassNotFoundException {
    System.out.println("-------- PostgreSQL "
            + "JDBC Connection Testing ------------");
    try {
        Class.forName("org.postgresql.Driver");
    } catch (ClassNotFoundException e) {
        System.out.println("Where is your PostgreSQL JDBC Driver? "
                + "Include in your library path!");
        e.printStackTrace();
        return;
    }
    System.out.println("PostgreSQL JDBC Driver Registered!");
    Connection connection = null;
    try {
        // ========>     from heroku website
        String url = "jdbc:postgresql://ec2-107-20-214-225.compute-1.amazonaws.com:5432/databasename";
        Properties props = new Properties();
        props.setProperty("user", "someusername");
        props.setProperty("password", "somepassword");
        props.setProperty("ssl", "true");
        connection = DriverManager.getConnection(url, props);
    } catch (SQLException e) {

        System.out.println("Connection Failed! Check output console");
        e.printStackTrace();
        return;
    }...

Output:

-------- PostgreSQL JDBC Connection Testing ------------
PostgreSQL JDBC Driver Registered!
Connection Failed! Check output console
org.postgresql.util.PSQLException: The connection attempt failed.
    at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:225)
    at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
    at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:138)
    at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
...
Caused by: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
    at sun.security.ssl.Alerts.getSSLException(Alerts.java:192)
    ...

See here: stackoverflow.com/questions/9386803/… and here: stackoverflow.com/questions/11832361/… — Lukas Eklund
– Lukas Eklund, Commented Feb 27, 2014 at 16:27

Maroun · Accepted Answer · 2016-08-18 11:11:07Z

26

Thanks Lukas Eklund!

My url should look like this:

String url = "jdbc:postgresql://ec2-107-20-214-225.compute-1.amazonaws.com:5432/databasename
?user=someusername&password=somepassword
&ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory";

edited Aug 18, 2016 at 11:11

Maroun

96.3k30 gold badges195 silver badges249 bronze badges

answered Feb 27, 2014 at 18:00

user2372976

7251 gold badge8 silver badges19 bronze badges

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

2 Comments

Chris Grenz Over a year ago

Working around by not validating the cert isn't great from security standpoint...

Markus Over a year ago

see jdbc.postgresql.org/documentation/head/ssl-client.html documentation how to set it up correctly including certificates to validate

SkyWalker · Accepted Answer · 2017-04-29 01:32:20Z

7

Add sslmode to the database url:

String url = "jdbc:postgresql://ec2-107-20-214-225.compute-.amazonaws.com:5432/databasename?sslmode=require

edited Apr 29, 2017 at 1:32

SkyWalker

29.3k14 gold badges77 silver badges134 bronze badges

answered Apr 4, 2017 at 11:48

Hansel

711 silver badge1 bronze badge

1 Comment

Ala Eddine Menai Over a year ago

I guess just ssl not sslmode.

Sami Badawi · Accepted Answer · 2018-06-12 20:38:24Z

1

I had the same problem but I had to use 2 settings to get it work:

String url = "jdbc:postgresql://ec2-107-20-214-225.compute-.amazonaws.com:5432/databasename?ssl=true&sslmode=require

ssl=true

and

sslmode=require

answered Jun 12, 2018 at 20:38

Sami Badawi

1,0321 gold badge14 silver badges27 bronze badges

Collectives™ on Stack Overflow

Cannot connect to heroku PostgreSQL db

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related