Skip to main content

Error The Specified driver class (org.postgres.Driver) is not available!

SQL Workbench error for PostgreSQL connection: The Specified driver class (org.postgres.Driver) is not available!


Below is the error which can appears while connecting to a PostgreSQL databases in SQL workbench:
This could be due to Postgres driver is not found by the Workbench tool. This could happen if the folder containing the driver is moved or deleted.

Solution:

To fix this issue, 
1. Open Workbench and go to File - > Manage Drivers
2. Select PostgreSQL
3. Under the Library option select the Folder where the driver is located and select the driver and click on Open.
you can download the latest Postgres JDBC drivers at: https://jdbc.postgresql.org/download.html
4. Click on OK to to close the Manage Drivers window.
5. Now try to connect to the PostgreSQL database with correct credentials, it should connect.

Comments

Popular posts from this blog

Install pip on Windows

If you haven't downloaded get-pip.py yet: You need to download this file from the official pip website or use curl in your command prompt. Using curl (recommended): Open Command Prompt and type: DOS curl https://bootstrap.pypa.io/get-pip.py -o get-pip.py This will download the file to your current directory in the Command Prompt. Manual Download: Go to https://bootstrap.pypa.io/get-pip.py in your web browser, right-click on the page, select "Save as...", and save the file as get-pip.py to a location you can easily navigate to (e.g., your Downloads folder, or a dedicated Python projects folder). The file is in a different directory: You might have downloaded get-pip.py to your Downloads folder, your Desktop, or another location, but you're trying to run the command from C:\Users\gparn . Solution: Navigate to the directory where you saved get-pip.py in your Command Prompt using the cd (change directory) command. Example (if in Downloads): DOS cd C:\User...