HikariCP Postgresql Driver Claims to not accept JDBC URL

Question

I've pushed my application to cloudfoundry. However every time I connect to my postgresql/elephant sql I received this error

 Driver org.postgresql.Driver claims to not accept JDBC URL jdbc:postgres://cwkqmdql:SsVqwdLxQObgaJAYu68O-8gTY1VmS9LX@pellefant.db.elephantsql.com:5432/cwkqmdql/

Is there anything I've missed?

The URL is indeed invalid. If the part `cwkqmdql:SsVqwdLxQObgaJAYu68O-8gTY1VmS9LX` is supposed to be username and password, then you can't specify it like that. See the manual for the correct URL: https://jdbc.postgresql.org/documentation/94/connect.html — a_horse_with_no_name, Jan 12 '16 at 11:26
@a_horse_with_no_name I tried changing my spring.datasource.url to this jdbc:postgres://pellefant-01.db.elephantsql.com:5432/cwkqmdql and the same error still persists — user962206, Jan 12 '16 at 23:17

score 63 · Answer 1 · answered Jul 06 '16 at 23:16

63

There are a few issues with that URL and a latest PSQL driver may complain.

jdbc:postgres: should be replaced with jdbc:postgresql:
Do not use jdbc:postgresql://<username>:<passwor>..., user parameters instead: jdbc:postgresql://<host>:<port>/<dbname>?user=<username>&password=<password>
In some cases you have to force SSL connection by adding sslmode=require parameter

So your URL should be:

jdbc:postgresql://@pellefant.db.elephantsql.com:5432/cwkqmdql?user=cwkqmdql&password=SsVqwdLxQObgaJAYu68O-8gTY1VmS9LX

or

jdbc:postgresql://@pellefant.db.elephantsql.com:5432/cwkqmdql?user=cwkqmdql&password=SsVqwdLxQObgaJAYu68O-8gTY1VmS9LX&sslmode=require

I hope that will help.

answered Jul 06 '16 at 23:16

Tom

24,084
18
92
104

5

In my case, I needed a trailing forward slash. Like `jdbc:postgresql://db:5432/` – David Groomes Jan 31 '18 at 03:32
didn´t work for me with Spring Boot 2 on Heroku Postgres. – jonashackt Apr 23 '18 at 08:50
2

Thanks, it was caused by jdbc:postgre:/ I replaced it by jdbc:postgresql:/ and it's ok – Walterwhites Dec 16 '18 at 22:04
1

why @ is added along with host name? In my case it worked when I removed '@' from host name. – UVM Apr 20 '19 at 06:21
1

This answer relly helped with me connecting to Heroku Postgres from local machine – Holger L Feb 09 '21 at 09:49

score 15 · Answer 2 · answered Nov 05 '18 at 10:41

15

In my case it was defining the property in double quotes in the java.properties file

by changing

jdbcUrl="url"

to

jdbcUrl=url

it works again

answered Nov 05 '18 at 10:41

Thami Bouchnafa

1,449
1
12
18

6

ooops, that was my issue, too. Thank you – rob Nov 13 '18 at 08:16
1

This was the issue too. For my case, the confusion comes from different syntax for different config files (application.properties vs application.yml) – Hoàng Long Dec 14 '18 at 08:04
what if i am using helm chart to create secret and while creating secrets we need to surround each value with quotes.. then in applications.properties, we inject the env var. – Abdennour TOUMI Feb 21 '21 at 11:19

score 1 · Answer 3 · answered Nov 09 '20 at 17:00

1

also had this error, but realized it was because i had typed postgressql instead of postgresql in my url

answered Nov 09 '20 at 17:00

breadman0

123
8

HikariCP Postgresql Driver Claims to not accept JDBC URL

3 Answers3

Linked