Search code examples
postgresqldbeaver

Can't connect to databases in DBeaver

I'm having problems trying to connect to databases with DBeaver. I've managed to connect to one database fine with no problems. However, any additional connections is causing issues.

I keep getting the error

SCRAM authentication is not supported by this driver. You need JDK >= 8 and pgjdbc >= 42.2.0 (not ".jre" versions)

I've tried the exact same details in pgadmin, and can get into the database just fine.

I just much prefer DBeaver as pgadmin seems to lack some really basic features like autocompletion.

I've reinstalled postgres and dbeaver multiple times, ensuring that its the latest version of each, still nothing.

Solution

  • Fixed the issue. It appears that DBeaver was holding on to an outdated library, which was being checked first, and therefore failing the test.

    Steps to solve issue.

    1. Download latest JDBC and move to \Program Files\DBeaver\shared_drivers
    2. Open DBeaver and click Database -> Driver Manager
    3. Double click on PostgreSQL
    4. Under libraries click Add file and find the new JDBC
    5. Delete any of the previous libraries, so it remains the only one