Running the NsSample sample program
To run the NsSample program, follow these
steps.
Open a command prompt and change 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.
- derbyshared.jar
- Code shared by all configurations.
- derbytools.jar
- DataSources and tools.
Test the CLASSPATH settings by running the following Java
command:
java org.apache.derby.tools.sysinfo
This 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.NsSample
If the program runs successfully, you will receive output similar
to the following:
Using JDBC driver: org.apache.derby.jdbc.ClientDriver
Derby Network Server created
Apache Network Server started
and ready to accept connections on port 1621
[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 - 2; started.
[NsSampleWork] Thread id - 2; requests database connection,
dbUrl =jdbc:derby://localhost:1621/NSSampledb;create=true;
[NsSampleClientThread] Thread id - 1; started.
[NsSampleWork] Thread id - 1; requests database connection,
dbUrl =jdbc:derby:NSSampledb;
[NsSampleWork] Thread id - 1; inserted 1 row.
[NsSampleWork] Thread id - 1; inserted 1 row.
[NsSampleWork] Thread id - 1; deleted 1 row with t_key = 9372
[NsSampleWork] Thread id - 1 selected 1 row [920,Derby50 ,951.7808,9216]
[NsSampleWork] Thread id - 1 selected 1 row [920,Derby50 ,951.7808,9216]
[NsSampleWork] Thread id - 1; inserted 1 row.
[NsSampleWork] Thread id - 1 selected 1 row [920,Derby50 ,951.7808,9216]
[NsSampleWork] Thread id - 1; deleted 1 row with t_key = 9216
[NsSampleWork] Thread id - 1 selected 1 row [824,Derby26 ,8.802546E22,9155]
[NsSampleWork] Thread id - 1; updated 1 row with t_key = 9155
[NsSampleWork] Thread id - 1; closed connection to the database.
[NsSampleClientThread] Thread id - 1; finished all tasks.
[NsSampleWork] Thread id - 2; updated 0 row with t_key = 9372
[NsSampleWork] Thread id - 2; updated 1 row with t_key = 9155
[NsSampleWork] Thread id - 2 selected 1 row [56,Derby26 ,8.802546E22,9155]
[NsSampleWork] Thread id - 2; inserted 1 row.
[NsSampleWork] Thread id - 2; updated 1 row with t_key = 9155
[NsSampleWork] Thread id - 2; deleted 1 row with t_key = 9155
[NsSampleWork] Thread id - 2 selected 1 row [785,Derby2 ,0.30170244,8280]
[NsSampleWork] Thread id - 2 selected 1 row [785,Derby2 ,0.30170244,8280]
[NsSampleWork] Thread id - 2; updated 1 row with t_key = 8280
[NsSampleWork] Thread id - 2 selected 1 row [59,Derby2 ,0.30170244,8280]
[NsSampleWork] Thread id - 2; closed connection to the database.
[NsSampleClientThread] Thread id - 2; finished all tasks.
[NsSample] Shutting down network server.
Apache Network Server - shutdown
[NsSample] End of Network server demo.
Running the NsSample program also creates the following
new directory and file:
- NSSampledb
- This directory makes up the NSSampledb database.
- derby.log
- This log file contains
progress and error
messages.