Spring Boot + JPA, PostgreSQL driver returns null for Heroku Remote DB URL

Question

I know this question appeared on stackoverflow, but none of the solutions worked for me. I have a Spring Boot application that is auto-configured. I have this application.properties :

#HEROKU CREDENTIALS
spring.datasource.url=jdbc:postgres://my_url/database?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory

spring.datasource.username=username
spring.datasource.password=my_password
spring.datasource.driver-class-name=org.postgresql.Driver
spring.jpa.database-platform=org.hibernate.dialect.PostgreSQLDialect
spring.jpa.show-sql=true

When application is deployed on Heroku everything works perfectly. When I try to run it on my local machine I can't connect to the database.

java.sql.SQLException: Driver:org.postgresql.Driver@69ec93c2 returned null for URL: my_url
at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:329) ~[tomcat-jdbc-8.5.14.jar:na]
at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:203) ~[tomcat-jdbc-8.5.14.jar:na]
at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:735) [tomcat-jdbc-8.5.14.jar:na]
at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:667) [tomcat-jdbc-8.5.14.jar:na]

As you can see in the application.properties I added the ssl and sslfactory but no success.

I think jdbc:postgres:// should be jdbc:postgresql://, but that doesn't seem to be the main problem. — codefinger
– codefinger, Commented Jul 14, 2017 at 8:33

codefinger · Accepted Answer · 2017-07-14 16:29:20Z

1

The URL prefix jdbc:postgres:// should be jdbc:postgresql://

answered Jul 14, 2017 at 16:29

codefinger

10.4k8 gold badges42 silver badges52 bronze badges

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

Comments

BillMan · Accepted Answer · 2017-07-13 19:35:18Z

0

Looks like it could be related to an underscore in the hostname. Looks like underscores are allowed in hostnames : See https://stackoverflow.com/a/7852692/227986

answered Jul 13, 2017 at 19:35

BillMan

10.1k10 gold badges35 silver badges55 bronze badges

1 Comment

Schidu Luca Over a year ago

No underscores. If there were underscores I suppose it wouldn't work at all : jdbc:postgres://ec2-174-129-224-33.compute-1.amazonaws.com:5432/d84d5t07vqtcfj

Collectives™ on Stack Overflow

Spring Boot + JPA, PostgreSQL driver returns null for Heroku Remote DB URL

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related