Upgrade studio postgresql jdbc driver or allow to override it

Support
#1

I set my postgres instance to require ssl.

When studo tries to update or create my database with the connection paramter sslmode=required
I displays the error

Error Connecting to Database: org.postgresql.util.PSQLException: Invalid sslmode value: prefer

Running the application against that database (without extra connection paramters) or using any other tools works fine.
The difference seems to be that studio uses postgresql client 9.4.1212 (seen under lib folder for cuba plugin) while the version for the depoyed applicaton is 42.2.5

Is there a workaround for this? can I just dump the newer driver in the lib folder or is there any property i can override?

#3

Hi,

We will upgrade Studio’s PostgreSQL JDBC driver in release 13.0.

For now you can try to replace postgresql.jar in the Studio plugin release archive:
Download latest zip version from https://plugins.jetbrains.com/plugin/7249-cuba/versions

Extract the zip and replace the postgresql driver jar file there.

Then install repacked plugin using “Install plugin from disk” option in the Settings → Plugins IDEA dialog.