[Geoserver-users] Cannot create JDBC driver of class 'org.postgresql.Driver'

Patrick_L_Jones · August 11, 2021, 2:31pm

Greetings,

When I try to create a Vector Data Store I get the following error:

Error creating data store, check the parameters. Error message: Unable to obtain connection: Cannot create JDBC driver of class ‘org.postgresql.Driver’ for connect URL ‘jdbc:postgresql://https://xx.x.xxx.xxx:xxxx/mout?sslmode=ALLOW&binaryTransferEnable=bytea’

Any thoughts on how to get past this?

I’m using · GeoServer Version 2.19.0

Thank you,

ianturton · August 11, 2021, 3:48pm

Is that a JNDI connection string or something that GeoServer has constructed for you. I’ve never seen a PostgreSQL url with parameters like that before.

Next step is probably to turn up the logging level and see what happens in the log file

Ian

···

Ian Turton

Humphries_Graham · August 11, 2021, 10:17pm

A quick google search shows that the URL for the postgres connection is of the form:

· jdbc:postgresql://host:port/database

You probably want something like

Jdbc:postgresql://myserver:5432/mydatabase

see this link for more info:

https://jdbc.postgresql.org/documentation/80/connect.html

Hope this helps

Cheers,

Graham

···

From: Patrick L Jones plj@anonymised.com
Sent: Thursday, 12 August 2021 12:31 AM
To: geoserver-users@lists.sourceforge.net
Subject: [Geoserver-users] Cannot create JDBC driver of class ‘org.postgresql.Driver’