How To Install Jdbc Driver In Windows 7 64 Bit
Introduction
SQL Workbench/J is not to be dislocated with MySQL Workbench. SQL Workbench is a tool designed to handle SQL queries no affair which fundamental Database Management Organisation (DBMS) you use.
This tutorial shows you lot how to install and fix up SQL Workbench for PostgreSQL. It includes instructions for a Debian based system (Ubuntu eighteen.04) too as Windows, macOS, and Linux GUI.
Prerequisites
Linux:
- Access to a terminal or command line
- A user account with sudo privileges
Windows and macOS:
- Administrator privileges
Install SQL Workbench for Postgres
SQL Workbench helps you manage different database systems without the demand to chief each of their proprietary tools in turn.
Installing SQL Workbench is a straightforward process that can be completed in a few short steps.
Pace 1: Download and Unzip SQL Workbench Distribution Package
Ubuntu eighteen.04
To download a generic package for all systems, enter the following command in your command line final:
sudo wget https://www.sql-workbench.european union/Workbench-Build125-with-optional-libs.zip The arrangement proceeds to download the zipped package from the official page:
Employ a compression tool to unzip the content of the downloaded file and salve it to the desired location on your system. The following control saves the extracted files in the Workbench folder on the Desktop:
unzip Workbench-Build125-with-optional-libs.zip -d Desktop/Workbench The output displays the extraction procedure.
Windows & macOS
Use your browser and access the official website with this link:
https://www.sql workbench.eu/downloads.html
Select your preferred package from the listing. The first option provides the virtually comprehensive package.
Click and download the file. Right-click the zipped binder and extract the content to a preferred location on your system. In this example, the content was extracted to the Workbench folder on the desktop in Windows.
Step 2: Install Latest Java Version (Optional)
SQL Workbench is based on Java. Y'all need to take at least Java viii on your arrangement to be able to install and employ SQL Workbench. If yous already have an up to date version installed, you tin skip to Footstep 3 of the tutorial.
There is no need to download or install Java runtime beforehand. The SQL Workbench package already contains the necessary shell scripts: download_jre.sh and download_jre.cmd . These scripts when executed, automatically download and extract the latest available Java runtime.
Ubuntu eighteen.04
Use your command final to access the folder where you have extracted the SQL Workbench packet. In our case, the files are in the Desktop/Workbench binder.
Use the following control to initiate the crush script that downloads and extracts Java runtime:
sudo sh download_jre.sh The system runs the script and installs the latest available Java version.
Windows & macOS
After unpacking the archive, run the download_jre script from within the Workbench folder. The script downloads and extracts an appropriate Java runtime to the existing folder. The Windows launcher and shell scripts automatically use that specific Java runtime.
Alternatively, utilize your browser to visit the official Oracle Java website.
This method allows you to select a dissimilar Coffee version.
Step three: PostgreSQL JDBC Plugin
JDBC is a software component that enables Java to collaborate with the PostgreSQL database. Each database direction organization requires its JDBC driver. The SQL Workbench/J distribution does not contain the JDBC driver. It's necessary to download the JDBC plugin manually.
Ubuntu xviii.04
Enter the following control to download the latest drivers and save the postgresql-42.ii.10.jar file in a PostgreJDBC binder:
wget -P Desktop/PostgreJDBC https://jdbc.postgresql.org/download/postgresql-42.2.ten.jar The output from the final confirms that the file was successfully downloaded and saved.
Windows & macOS
Download the latest driver version by using the provided link.
Download and place the file in a secure binder. No installation is necessary. However, if the file gets accidentally deleted or moved, you are non going to be able to connect to your database with SQL Workbench.
Step 4: Start SQL Workbench
There is no demand to install SQL Workbench every bit it comes as a preconfigured .jar file that tin be run in whatever Java runtime environment.
Ubuntu 18.04
Admission the Desktop/Workbench folder and enter the following command in your concluding to initiate the SQL Workbench shell:
sudo sh sqlworkbench.sh You have successfully launched the SQL Workbench control interface. You are now able to create a connectedness profile.
Windows & macOS
Admission the Workbench folder and starting time the SQLWorkbench.exe executable file. If you are using 64-bit Windows start the SQLWorkbench64.exe file.
Step five: Connect to PostgreSQL Using SQL Workbench
From this point, the SQL Workbench shell has the aforementioned functions, regardless of the system, you are running it on. The Select Connection Profile page allows you to ascertain the data necessary to establish a connection to your PostgreSQL server.
1. Define a unique name for the Connection Profile (in the example beneath: PostgreSQL Connection).
2. Open up the Driver drop-down bill of fare and select the PostgreSQL option.
3. Click Manage Drivers and set the precise path to your JDBC PostgreSQL driver.
iv. Enter the URL for your PostgreSQL server. The URL should be formatted every bit follows:
jdbc:postgresql://your.database.server.ip:port.number/name_of_database 5. Enter the username and countersign for your database in their respective fields.
6. In one case y'all enter the details correctly, click OK to institute the connection.
Determination
You take successfully connected the SQL Workbench tool to your PostgreSQL server. You lot can at present use it comfortably migrate data between your databases and manage several DBMS without the need to use several concurring interfaces.
Was this article helpful?
Yes No
Source: https://phoenixnap.com/kb/postgresql-workbench
Posted by: ramseythreake86.blogspot.com
0 Response to "How To Install Jdbc Driver In Windows 7 64 Bit"
Post a Comment