|
Using the Derby tools
and startup utilities
There are several tools and utilities that you might want to use
as you begin to work with Derby.
The tools that are included with Derby are dblook, ij,
and sysinfo. To run these tools see:
Derby includes a set
of scripts that you can use to start the Derby tools.
The scripts are located in the DERBY_HOME/bin directory.
When you run these scripts, your CLASSPATH environment variable is set if
you have not already set it, and remains set as long as you are running the
tool.
Most of the examples in this guide that show how to use the Derby scripts
to launch the Derby tools
assume that you are using the embedded mode of the Derby database
engine. Use the instructions below to run the scripts with the Network Server.
Running the scripts with the Network ServerTo run
the scripts with the Network Server, use the following commands:
- For the sysinfo tool, issue the command
NetworkServerControl sysinfo
- For the ij tool, issue the command
set DERBY_OPTS=-Dij.protocol=jdbc:derby://localhost/
and
then start ij by issuing the command ij.
- For the dblook tool, call the script and specify the -d option
and the full connection URL to the Network Server database. For example:
dblook -d 'jdbc:derby://localhost/myDB;user=usr'
Additional Derby utilitiesIn
addition, there are Derby utilities that are system procedures that you can
call by using the ij tool. For example, there are system
procedures that you can use to import and export external files. Instructions
on how to use these system procedures are included in the Derby Tools and Utilities Guide and
the Derby Reference Manual.
- Running sysinfo
The Derby sysinfo tool displays information about your Java environment and your version of Derby.
- Running ij
The Derby ij tool is a JDBC tool that you can use to run scripts or interactive queries against a Derby database.
- Running dblook
The Derby dblook utility is a Data Definition Language (DDL) generation utility.
|
