Choosing a method to run the tools
and startup utilitiesThere are several ways that you can run the tools
and startup utilities. Derbytools, runningtoolsin Derby
The method that you choose to run the tools and utilities determines
the environment variables that you set for .
Choose the method that you want to use. The methods are listed in
the following table.
Methods of running the tools and utilitiesMethodWhen to UseRequirementsRun the tools using the command shell scripts that are
provided with .Use this method when you want to run the tools with the
least amount of typing and have installed the full bin
distribution of .
Set the environment variable
Include the location of the java executable file (usually
JAVA_HOME\bin) in the PATH environment variable
Include the \bin directory in the PATH environment
variable
Run the tools using the derbyrun.jar
archive file.Use this method when:
You have only the
jar files available (see ), and
do not have the full bin distribution of
You do not want to use the scripts that are provided with
Set the environment variable
Include the location of the java executable file (usually
JAVA_HOME\bin) in the PATH environment variable
The derbyrun.jar file must be in the same folder
as the other .jar
files.
For more information, see
.
Run the tools using the complete java
syntax, or use in a Java
program.Use this method when:
You do not have the derbyrun.jar file or the
scripts installed
You want to learn the full syntax of each command and understand the details
of setting up the execution environment
You are developing application programs with
Set the environment variable
Include the location of the java executable file (usually
JAVA_HOME\bin) in the PATH environment variable
You must know the full package name for the Java class that supports the
tool
The CLASSPATH environment variable must be set to include the required
JAR files
For details on setting the CLASSPATH, see
.
Based on the requirements of the method that you chose to run the
tools, follow the instructions to set
the environment variables.