To help you complete this activity, you must create a directory
and copy several scripts into the new directory. You will use these scripts
to quickly add tables and data to a new Derby database.
Tip: A command prompt appears after each command is run.
If an error occurs, verify the syntax and retype the command.
- Open a command window and change to a directory where you want
to store the files that you create during the self-study tutorial activities.
- Create the DERBYTUTOR directory. DERBYTUTOR will
be your working directory for this activity.
Operating System |
Command |
UNIX (Korn Shell) |
mkdir DERBYTUTOR
|
Windows |
md DERBYTUTOR
|
- Change to the DERBYTUTOR directory.
Operating System |
Command |
UNIX (Korn Shell) |
cd DERBYTUTOR
|
Windows |
cd DERBYTUTOR
|
- Copy the SQL scripts from the Derby demo\programs\toursdb subdirectory
into the DERBYTUTOR directory. You will use these scripts
to create tables and add data to a new database, toursdb.
Operating System |
Command |
UNIX (Korn Shell) |
cp $DERBY_HOME/demo/programs/toursdb/*.sql .
|
Windows |
copy %DERBY_HOME%\demo\programs\toursdb\*.sql .
|
- Verify that the files were copied to the DERBYTUTOR directory.
Operating System |
Command |
UNIX (Korn Shell) |
ls DERBYTUTOR
|
Windows |
dir DERBYTUTOR
|
Important: Include the dot (.)
at the end of each command so that your current working directory is included
in the classpath and the files are copied to the correct location.