Server tool to start JavaDB in a network client environment

To start JavaDB:

Set the Path environment variable to include the <JAVA_HOME>/db/lib directory.

Open the command prompt and type the following command:

java �jar derbyrun.jar server start

Ping JavaDB 

Stop JavaDB 

Using the ij Tool

The ij tool enables you to connect to a running JavaDB server and execute scripts and queries against a database.

The command to use the ij tool is:

java �jar derbyrun.jar ij

Commands of the ij Tool

CommandDescriptionDriverLoads the specified JDBC driver.ProtocolSets the specified protocol to use for connecting to a database.ConnectEstablishes a connection with a database.Set ConnectionSwitches from the existing connection to a different connection specified with a connection name.Show ConnectionsLists all active connections.DisconnectDisconnects the current connection, a connection specified by a connection name, or all active connections.Show SchemasLists all schemas present in the current database.Show TablesLists all tables present in the current database.Show ViewsLists all views present in the current database.Show ProceduresLists all stored procedures present in the current database.Show IndexesLists all indexes present in a specified table.DescribeDisplays information about columns, such as column name and data type, for a specified table.rumitCommits the current transaction.RollbackRolls back the current transaction.

Stop JavaDB

java �jar derbyrun.jar server shutdown

Ping JavaDB

Ping JavaDB.

The command to ping JavaDB is:

java �jar derbyrun.jar server ping
java �jar derbyrun.jar server ping 192.168.0.1 1555