Cannot connect to heroku postgres database using Netbeans

Question

I am trying to connect to a database hosted at https://postgres.heroku.com/databases using Netbeans (built-in) services / databases. I get this error

Cannot establish connection with JDBC: PostGreSQL: //ec2-xx-xxx-xxx-xxx.compute-1.am

I tried this without problems: 1. Netbeans connects to the local postgres database. 2. Using PgAdmin III to access postgres heroku databases.

I tried to download the latest postgres driver and use it in netbeans to create a connection, but with the same error.

Thanks in advance!

Answer 1

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

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