How To Install derby-tools on Debian 9

In this tutorial we learn how to install derby-tools on Debian 9. derby-tools is Apache Derby Tools

Introduction

In this tutorial we learn how to install derby-tools on Debian 9.

What is derby-tools

derby-tools is:

The Derby tools and utilities are a set of routines supplied with Derby that are typically used to create, inspect, and update a Derby database.

These tools and utilities include:

  • NetworkServerControl, provides the ability to start a Network Server or connect to a running Network Server to shutdown, configure or retrieve diagnostic information.
  • ij, the Derby’s interactive JDBC scripting tool. It is a simple utility for running scripts against a Derby database. You can also use it interactively to run ad hoc queries. ij provides several commands for ease in accessing a variety of JDBC features. ij can be used in an embedded or a client/server environment.
  • sysinfo, provides information about your version of Derby and your environment.
  • dblook, the Derby’s Data Definition Language (DDL) Generation Utility, more informally called a schema dump tool. It is a simple utility that dumps the DDL of a user-specified database to either a console or a file. The generated DDL can then be used for such things as recreating all or parts of a database, viewing a subset of a database’s objects (for example, those which pertain to specific tables and schemas), or documenting a database’s schema.
  • SignatureChecker, a tool that identifies any SQL functions and procedures in a database that do not follow the SQL Standard argument matching rules.
  • PlanExporter, a tool to export query plan data for further analysis.

There are three methods to install derby-tools on Debian 9. We can use apt-get, apt and aptitude. In the following sections we will describe each method. You can choose one of them.

Install derby-tools Using apt-get

Update apt database with apt-get using the following command.

sudo apt-get update

After updating apt database, We can install derby-tools using apt-get by running the following command:

sudo apt-get -y install derby-tools

Install derby-tools Using apt

Update apt database with apt using the following command.

sudo apt update

After updating apt database, We can install derby-tools using apt by running the following command:

sudo apt -y install derby-tools

Install derby-tools Using aptitude

If you want to follow this method, you might need to install aptitude first since aptitude is usually not installed by default on Debian. Update apt database with aptitude using the following command.

sudo aptitude update

After updating apt database, We can install derby-tools using aptitude by running the following command:

sudo aptitude -y install derby-tools

How To Uninstall derby-tools on Debian 9

To uninstall only the derby-tools package we can use the following command:

sudo apt-get remove derby-tools

Uninstall derby-tools And Its Dependencies

To uninstall derby-tools and its dependencies that are no longer needed by Debian 9, we can use the command below:

sudo apt-get -y autoremove derby-tools

Remove derby-tools Configurations and Data

To remove derby-tools configuration and data from Debian 9 we can use the following command:

sudo apt-get -y purge derby-tools

Remove derby-tools configuration, data, and all of its dependencies

We can use the following command to remove derby-tools configurations, data and all of its dependencies, we can use the following command:

sudo apt-get -y autoremove --purge derby-tools

Dependencies

derby-tools have the following dependencies:

References

Summary

In this tutorial we learn how to install derby-tools package on Debian 9 using different package management tools: apt, apt-get and aptitude.