Starting ij using properties

You set ij properties in any of the following ways:

  1. by using the -D command on the command line
  2. by specifying a properties file using the -p propertyfile option on the command line

ij property names are case-sensitive, while commands are case-insensitive.

The following examples illustrate how to use ij properties:

To start ij by using a properties file called ij.properties, use the following command: java org.apache.derby.tools.ij -p ij.properties

To start ij with a maximumDisplayWidth of 1000: java -Dij.maximumDisplayWidth=1000 org.apache.derby.tools.ij

To start ij with an ij.protocol of jdbc:derby: and an ij.database of sample, use the following command: java -Dij.protocol=jdbc:derby: -Dij.database=sample org.apache.derby.tools.ij

To start ij with two named connections, using the ij.connection.connectionName property, use the following command: java -Dij.connection.sample=jdbc:derby:sample -Dij.connection.History=jdbc:derby:History -Dderby.system.home=c:\derby\demo\databases org.apache.derby.tools.ijTo see a list of connection names and the URL's used to connect to them, use the following command: (If there is a connection that is currently active, it will show up with an * after its name.) ij version 10.1 ij(HISTORY)> show connections; HISTORY* - jdbc:derby:History SAMPLE - jdbc:derby:sample * = current connection ij(HISTORY)>

 To start ij to connect to the Network Server, you must specify the user and password attributes on the URL. For more information, see the .