Starting ij

Derby provides batch and shell scripts for users in Windows and UNIX environments that can be used to start ij. By calling the appropriate script you will start ij and be able to connect with a simple command. The scripts are found in the bin directory of your Derby installation. You can also customize the ij scripts to suit your environment.

If you are using Derby as a client/server environment, start the Network Server before connecting to the Derby database. (See "Starting the Network Server" in the Derby Server and Administration Guide for details.) You can start ij by running the ij scripts for your environment. Follow the instructions in "Setting up your environment" in Getting Started with Derby to set the DERBY_HOME and JAVA_HOME environment variables and to add DERBY_HOME/bin to your path. Then use the following command:

ij [-p propertyFile] [inputFile]
Alternatively, set the DERBY_HOME environment variable, then use one of these commands:
(UNIX) java [options] -jar $DERBY_HOME/lib/derbyrun.jar ij
    [-p propertyFile] [inputFile]
(Windows) java [options] -jar %DERBY_HOME%\lib\derbyrun.jar ij
    [-p propertyFile] [inputFile]
java [options] org.apache.derby.tools.ij 
    [-p propertyFile] [inputFile]

If you use the last form of the command, be sure that derbyrun.jar is in your classpath (for pre-10.2 distributions derbytools.jar and usually derby.jar were required in the classpath).

If you need to use other classes in addition to derbyrun.jar, 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).

The command line items are:

For detailed information about ij commands, see ij commands and errors reference.

Related concepts
Getting started with ij
Related tasks
Creating a database using ij
Starting ij using properties