How To Install derby-tools on Ubuntu
Posted on April 1, 2023 (Last modified on May 20, 2023 )
3 minutes • 555 words
Introduction
In this tutorial we learn how to install derby-tools on Ubuntu.
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 Ubuntu. 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 Ubuntu. 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 Ubuntu
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 Ubuntu, 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 Ubuntu 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 Ubuntu using different package management tools: apt, apt-get and aptitude.