Install JDBC on Linux in 3 steps

When you write an software, it’s normal to require information storage. Sometimes you are storing belongings your software must perform, and different occasions you are storing consumer information, together with preferences and save information. One option to retailer information is in a database, and to be able to talk between your code and a database, you want a database binding or connector to your language. For Java, a typical database connector is JDBC (Java database connectivity.)

1. Install Java

Of course, to develop with Java you have to even have Java put in. I like to recommend SDKman for Linux, macOS, and WSL or Cygwin. For Windows, you’ll be able to obtain OpenJDK from developers.redhat.com.

2. Install JDBC with Maven

JDBC is an API, imported into your code with the assertion import java.sql.*, however for it to be helpful you have to have a database driver and a database put in for it to work together with. The database driver you utilize and the database you need to talk with should match: to work together with MySQL, you want a MySQL driver, to work together with SQLite3, you have to have the SQLite3 driver, and so forth.

For this text, I take advantage of PostgreSQL, however all the key databases, together with MariaDB and SQLite3, have JDBC drivers.

You can obtain JDBC for PostgreSQL from jdbc.postgresql.org. I take advantage of Maven to handle Java dependencies, so I embrace it in pom.xml (adjusting the model quantity for what’s present on Maven Central):

<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <model>42.5.0</model>
</dependency>

3. Install the database

You have to put in the database you need to hook up with by JDBC. There are a number of excellent open supply databases, however I had to decide on one for this text, so I selected PostgreSQL.

To set up PostgreSQL on Linux, use your software program repository. On Fedora, CentOS, Mageia, and comparable:

$ sudo dnf set up postgresql postgresql-server

On Debian, Linux Mint, Elementary, and comparable:

$ sudo apt set up postgresql postgresql-contrib

Database connectivity

If you are not utilizing PostgreSQL, the identical common course of applies:

1. Install Java.

2. Find the JDBC driver to your database of alternative and embrace it in your pom.xml file.

3. Install the database (server and shopper) in your growth OS.

Three steps and also you’re prepared to begin writing code.