Open a command prompt and change directories to the %%\demo\
directory, where %%
is the directory where you installed .Set the CLASSPATH to the current directory (".") and also include
the following jar files in order to use the Network Server and the network
client driver:
derbynet.jar
The Network Server jar file. It must be in your CLASSPATH to use any of
the Network Server functions.
derbyclient.jar
This jar file must be in your CLASSPATH to use the Network Client driver.
derby.jar
The database
engine jar file.
derbytools.jar
The tools jar
file.
Test the CLASSPATH settings by running the following Java command: java org.apache.derby.tools.sysinfoThis command shows the jar
files that are in the classpath as well as their respective versions.After you set up your environment correctly, run the NsSample program
from the same directory: java nserverdemo.NsSampleIf the program runs successfully, you will receive output similar
to that shown in the following table: Network Server created
Server is ready to accept connections on port 1621.
Connection number: 1.
[NsSample] Network Server started.
[NsSample] Sample Network Server program demo starting.
Please wait .....................
Connection number: 2.
[NsSampleWork] Begin creating table - SAMPLETBL and necessary indexes.
[NsSampleClientThread] Thread id - 1; started.
[NsSampleWork] Thread id - 1; requests database connection,
dbUrl =jdbc:derby:NSSampledb;
[NsSampleClientThread] Thread id - 2; started.
[NsSampleWork] Thread id - 2; requests database connection,
dbUrl =jdbc:derby://localhost:1621/
NSSampledb;deferPrepares=true;
Connection number: 3.
[NsSampleWork] Thread id - 1 selected 1 row [313,Derby36 ,1.7686243E23,9620]
[NsSampleWork] Thread id - 1 selected 1 row [313,Derby36 ,1.7686243E23,9620]
[NsSampleWork] Thread id - 1; deleted 1 row with t_key = 9620
[NsSampleWork] Thread id - 1 selected 1 row [700,Derby34 ,8.7620301E9,9547]
[NsSampleWork] Thread id - 1 selected 1 row [700,Derby34 ,8.7620301E9,9547]
[NsSampleWork] Thread id - 2 selected 1 row [700,Derby34 ,8.7620301E9,9547]
[NsSampleWork] Thread id - 2 selected 1 row [700,Derby34 ,8.7620301E9,9547]
[NsSampleWork] Thread id - 1; inserted 1 row.
[NsSampleWork] Thread id - 1 selected 1 row [52,Derby34 ,8.7620301E9,9547]
[NsSampleWork] Thread id - 2; updated 1 row with t_key = 9547
[NsSampleWork] Thread id - 1; deleted 1 row with t_key = 9547
[NsSampleWork] Thread id - 2 selected 1 row [617,Derby31 ,773.83636,9321]
[NsSampleWork] Thread id - 2 selected 1 row [617,Derby31 ,773.83636,9321]
[NsSampleWork] Thread id - 2 selected 1 row [617,Derby31 ,773.83636,9321]
[NsSampleWork] Thread id - 2 selected 1 row [617,Derby31 ,773.83636,9321]
[NsSampleWork] Thread id - 1; inserted 1 row.
[NsSampleWork] Thread id - 2; deleted 1 row with t_key = 9321
[NsSampleWork] Thread id - 1; deleted 1 row with t_key = 8707
[NsSampleWork] Thread id - 1; closed connection to the database.
[NsSampleClientThread] Thread id - 1; finished all tasks.
[NsSampleWork] Thread id - 2; deleted 1 row with t_key = 8490
[NsSampleWork] Thread id - 2; closed connection to the database.
[NsSampleClientThread] Thread id - 2; finished all tasks.
[NsSample] Shutting down Network Server.
Connection number: 4.
Shutdown successful.
Running the NsSample program also creates the following new
directories and files:
NSSampledb
This directory makes up the NSSampledb database.
derby.log
This log file contains progress
and error messages.