Wednesday, 10 May 2017

How to connect Postgres Database outside Heroku?

I tried to connect to the heroku Postgres database locally in the Netbeans, but I failed.

Open heroku "database credentials", copy the host, username, password etc into Netbeans as building a new database connection.

It needs to add the following at the end of JDBC URL, otherwise connection will fail.
?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory

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


No comments:

Can Jackson Deserialize Java Time ZonedDateTime

Yes, but must include JSR310. Thus ZonedDateTime can be deserialized directly from JSON response to POJO field. <dependency> <g...