The Derby ij tool is a JDBC tool that you can use to run scripts or interactive queries against a Derby database.
| 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
Setting the environment variables 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 Java programming language. | You must set the
DERBY_HOME environment variable
before you can run the ij tool using this method.
On UNIX, the command is: java -jar $DERBY_HOME/lib/derbyrun.jar ij On Windows, the command is: java -jar %DERBY_HOME%\lib\derbyrun.jar ij |
| Run ij 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
Manually setting the CLASSPATH/MODULEPATH environment variables. Then specify the class name in the
java command. For example:
java org.apache.derby.tools.ij |
| Run ij using the java command with a modulepath. | Use this method if you are familiar with both the Java programming language and Derby, have already added the location of the java executable file to your command execution PATH, and expect to run Derby via the modulepath. | You must set your MODULEPATH. Use the steps specified in
Manually setting the CLASSPATH/MODULEPATH environment variables. Then specify the tools module and the ij class name in the
java command.
On UNIX, the command is: java -p $MODULEPATH \ -m org.apache.derby.tools/org.apache.derby.tools.ij On Windows, the command is: java -p %MODULEPAT% ^ -m org.apache.derby.tools/org.apache.derby.tools.ij |
ij> exit;