JDBC connect problem with Postgres

[Sharalk]

I have a problem connecting to my local Postgres DB from Base on my win10 machine.
I get “The connection could not be established” when testing the connection.
And “The connection to the data source “PG_JDBC” could not be established.” with
“SQL Status: HY000
The connection to the external data source could not be established. An unknown error occurred. The driver is probably defective.”
when trying to check tables.

The driver and RTE should be ok, I have tested with a little java code and was able to connect using the driver and RTE.
The connect string is simple;jdbc:postgresql://localhost:5432/postgres
I have also tried to add “currentSchema” to the connect string without luck.

The jave RTE is checked in Advanced options as is the classpath to the JDBC driver.

Any suggestions?

Env:
java version “23.0.1” 2024-10-15
Java™ SE Runtime Environment (build 23.0.1+11-39)
Java HotSpot™ 64-Bit Server VM (build 23.0.1+11-39, mixed mode, sharing)

Version: 24.8.2.1 (X86_64) / LibreOffice Community
Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13
CPU threads: 8; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win
Locale: nb-NO (nb_NO); UI: en-US
Calc: CL threaded

[RobertG]

This isn’t Site Feedback. Please choose English as language instead.

Did you download JDBC-driver for PostgreSQL?
Did you look for the JDBC *.jar-fiel and set it in class path for java?

Have a look here for PostgreSQL and Base: Base Guide 7.3 → PostgreSQL

[Sharalk]

Thank you for your reply and link to the Base guide.
I made me realize I had a typo in my connection string, I had “jdbc:postgresql://localhost:5432/postgres” but it should only be a partial connection string in the input field since the “jdbc:” part is prefixed.
So my correct input to the connections string is now “postgresql://localhost:5432/postgres” and the connection is working.

Can I correct the wrong category of “Site feedback” ?