What are the Derby tools and utilities
Derby Tools and Utilities Guide
11
What are the Derby tools and utilities?
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.
For more complete information on developing a system using Derby, see the Derby
Developer's Guide.
Overview
Derby is a database management system (DBMS), accessed by applications through the
JDBC API.
Included with the product are some standalone Java tools and utilities that make it easier
to use and develop applications for Derby.
These tools and utilities include:
· ij
ij
is 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
sysinfo
provides information about your version of Derby and your environment.
· dblook
dblook
is 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
The
SignatureChecker
tool identifies any SQL functions and procedures in a
database that do not follow the SQL Standard argument matching rules.
Environment setup and the Derby tools
The tools
ij
,
sysinfo
,
dblook
, and
SignatureChecker
can all be used in either an
embedded or a client/server environment.
Java 2 Platform, Standard Edition, Version 1.4
All Derby tools require the Java 2 Platform, Standard Edition, Version 1.4 or later.
Classpath
The jar file
derbyrun.jar
simplifies the process of setting up the
CLASSPATH
environment variable to run Derby and the tools. Adding this jar file to your classpath has
the effect of putting all the Derby jar files in your classpath.
For details on using the Derby jar files for deploying applications, see the sections on
deploying Derby applications in the Derby Developer's Guide.
