Cannot connect to heroku postgres database using Netbeans

Question

I am trying to connect to a database hosted in https://postgres.heroku.com/databases using Netbeans (build-in) Services/Databases. I am getting this error

Cannot establish a connection to jdbc:postgresql://ec2-xx-xxx-xxx-xxx.compute-1.am

I tried this with no issues: 1. Netbeans connecting to a local postgres database. 2. Using PgAdmin III connecting to heroku postgres databases.

I tried downloading the latest postgres driver and use it in netbeans to create connection but the same error.

Thanks in advance!

ryanbrainard · Accepted Answer · 2013-06-12 06:45:59Z

10

When connecting outside of Heroku (e.g. locally), add this to the end of your JDBC connection URL:

?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory

answered Jun 12, 2013 at 6:45

ryanbrainard

6,0871 gold badge39 silver badges43 bronze badges

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

Collectives™ on Stack Overflow

Cannot connect to heroku postgres database using Netbeans

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related