Java DB

Apache Derby

Derby Tools and Utilities Guide

Derby Getting Started
Derby Reference Manual
Derby Developer's Guide
Derby Performance Tuning
Derby Server and Admin Guide
Derby Tools and Utilities
Derby Tools and Utilities
-Copyright
-License
-About this guide
-What are the Derby tools and utilities?
-Using ij
-ij properties reference
-ij commands and errors reference
-ij commands
-Absolute command
-After Last command
-Async command
-Autocommit command
-Before First command
-Close command
-Commit command
-Connect command
-Describe command
-Disconnect command
-Driver command
-Elapsedtime command
-Execute command
-Exit command
-First command
-Get Cursor command
-Get Scroll Insensitive Cursor command
-Help command
-Last command
-LocalizedDisplay command
-MaximumDisplayWidth command
-Next command
-Prepare command
-Previous command
-Protocol command
-Readonly command
-Relative command
-Remove command
-Rollback command
-Run command
-Set Connection command
-Show command
-Wait For command
-Syntax for comments in ij commands
-Syntax for identifiers in ij commands
-Syntax for strings in ij commands
-ij errors
-Using the bulk import and export procedures
-Storing jar files in a database
-sysinfo
-dblook
-SignatureChecker
-Trademarks

 

Starting ij using properties

You set ij properties in any of the following ways:

  1. by using the -D option on the command line
  2. by specifying a properties file using the -p propertyfile option on the command line
Remember: 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 a command like the following (with the addition of the file paths):
java -jar derbyrun.jar -p ij.properties
To start ij with a maximumDisplayWidth of 1000:
java -Dij.maximumDisplayWidth=1000 -jar derbyrun.jar
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 derbyrun.jar
To start ij with two named connections, using the ij.connection.connectionName property, use a command like the following (all on one line):
java -Dij.connection.sample=jdbc:derby:sample 
-Dij.connection.History=jdbc:derby:History 
-Dderby.system.home=c:\derby\demo\databases
-jar c:\derby\lib\derbyrun.jar
To see a list of connection names and the URLs 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.6
ij(HISTORY)> show connections;
HISTORY* -    jdbc:derby:History
SAMPLE -     jdbc:derby:sample
* = current connection
ij(HISTORY)>
Related concepts
 

javadb@jdbcurl.com