Running ij
Getting Started with Derby
17
Method
When to Use
Command
java [options] -jar
$DERBY_HOME/lib/derbyrun.jar
sysinfo
On Windows, the command is:
java [options] -jar
%DERBY_HOME%\lib\derbyrun.jar
sysinfo
Run
sysinfo
using
the
java
command.
Use this method
if you are familiar
with both the Java
programming
language and
Derby, and you
have already added
the location of the
java
executable file
to your command
execution PATH.
You must set your CLASSPATH. Use
the steps specified in
.
Then specify the class name in the
java
command. For example:
java org.apache.derby.tools.sysinfo
See "sysinfo" in the Derby Tools and Utilities Guide for more information about using the
sysinfo
utility.
Running ij
The Derby
ij
tool is a JDBC tool that you can use to run scripts or interactive queries
against a Derby database.
· Choose the method that you will use to run the
ij
script. The methods are listed in
the following table.
Table 6.
Methods of running the
ij
utility
Method
When to Use
Command
Run
ij
as a
standalone
command.
Use this method if
you are relatively
new to the Java
programming
language and new
to Derby.
Follow the steps in
before you run
the
ij
tool using this method. To run
the
ij
script from the command line,
use:
ij
You must add the
DERBY_HOME/bin
directory to your PATH environment
variable before you can run the
ij
tool.
The
ij
script sets the appropriate
environment variables, including the
CLASSPATH, and starts the
ij
tool.
Run
ij
using
the jar file that
is located in the
directory where
ij
resides.
Use this method
if you are new to
Derby, but are
familiar with the
You must set the DERBY_HOME
environment variable before you can
run the
ij
tool using this method.
On UNIX, the command is:
