Java DB

Apache Derby

Getting Started With Derby

Derby Getting Started
Derby Reference Manual
Derby Developer's Guide
Derby Performance Tuning
Derby Server and Admin Guide
Derby Tools and Utilities
Derby Getting Started
-Introduction to Derby
-Installing and configuring Derby
-Self-study tutorial for users new to Derby
-Quick start guide for experienced JDBC users
-Documentation conventions
-Derby libraries and scripts: complete reference

 

Syntax for the derbyrun.jar file

The derbyrun.jar file is a special JAR file that simplifies how you invoke the Derby tools and the Network Server.

With the derbyrun.jar file, you can run the Derby tools and utilities using shortened names and you do not need to set the java CLASSAPATH environment variable. The derbyrun.jar file must be in the same folder as the other Derby JAR files.

Syntax

The syntax for using derbyrun.jar for each of the Derby tools is as follows:
Operating System Command
UNIX (Korn Shell) 
java -jar $DERBY_HOME/lib/derbyrun.jar ij [-p propertiesfile] [sql_script] 
java -jar $DERBY_HOME/lib/derbyrun.jar sysinfo [-cp ...] [-cp help]

java -jar $DERBY_HOME/lib/derbyrun.jar dblook [arg]* (or no arguments for usage) 
java -jar $DERBY_HOME/lib/derbyrun.jar server [arg]* (or no arguments for usage)
Windows 
java -jar %DERBY_HOME%\lib\derbyrun.jar ij [-p propertiesfile] [sql_script] 
java -jar %DERBY_HOME%\lib\derbyrun.jar sysinfo [-cp ...] [-cp help] 
java -jar %DERBY_HOME%\lib\derbyrun.jar dblook [arg]* (or no arguments for usage) 
java -jar %DERBY_HOME%\lib\derbyrun.jar server [arg]* (or no arguments for usage)

To see this syntax reminder, run the command java -jar derbyrun.jar with no arguments.

Additional information

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.

 

javadb@jdbcurl.com