The derbyrun.jar file is a special JAR file that simplifies how you invoke the Derby tools and the Network Server.
The following table shows the syntax for using derbyrun.jar for each of the Derby tools.
|UNIX (Korn Shell)||
java -jar $DERBY_HOME/lib/derbyrun.jar ij [-p propertiesfile] [sql_script]
java -jar %DERBY_HOME%\lib\derbyrun.jar ij [-p propertiesfile] [sql_script]
To see this syntax reminder, run the command java -jar derbyrun.jar with no arguments.
You cannot use the -cp argument or the CLASSPATH environment variable to set CLASSPATH variables when you are using the -jar argument to start the ij tool. If you want to run the ij tool with a custom classpath, you cannot use the -jar argument. Instead, you have to use the full class name to start the ij tool (java org.apache.derby.tools.ij).
See Manually setting the CLASSPATH environment variable for more information about setting up the classpath and running the ij tool.
There is no such limitation when you run the sysinfo tool. See Running sysinfo for more information on running the sysinfo tool.
The server argument is a shortcut for running the NetworkServerControl tool. For details on using this tool, see the Derby Server and Administration Guide.
For more information on using derbyrun.jar to run the ij, sysinfo, and dblook tools, see the Derby Tools and Utilities Guide.