background image

<< Getting Started with Derby | Copyright >>

<< Getting Started with Derby | Copyright >>

Contents

Version 10.8 Getting Started with Derby

i

Contents

Copyright................................................................................................................................3

Introduction to Derby........................................................................................................... 8

Deployment options...................................................................................................8
System requirements.................................................................................................8
Product documentation for Derby........................................................................... 8

Installing and configuring Derby.......................................................................................10

Installing Derby........................................................................................................ 10
Setting up your environment..................................................................................10

Choosing a method to run the Derby tools and startup utilities...........................11
Setting the environment variables.......................................................................12
Syntax for the derbyrun.jar file............................................................................ 13
Manually setting the CLASSPATH environment variable....................................14

Using the Derby tools and startup utilities........................................................... 15

Running sysinfo................................................................................................... 16
Running ij.............................................................................................................17
Running dblook....................................................................................................18

Verifying the Derby system configuration............................................................ 19

Self-study tutorial for users new to Derby.......................................................................21

Tutorial overview......................................................................................................21
Activity 1: Run SQL using the embedded driver..................................................22

Creating a directory and copying scripts into the directory................................. 22
Creating a Derby database and running SQL statements.................................. 23

Activity 2: Run SQL using the client driver.......................................................... 25
Activity 3: Run a JDBC program using the embedded driver............................. 27

The WwdEmbedded program............................................................................. 28

Activity 4: Create and run a JDBC program using the client driver and Network
Server........................................................................................................................ 32
What next with Derby?............................................................................................35

Quick start guide for experienced JDBC users............................................................... 37

Environments in which Derby can run..................................................................37

Embedded environment...................................................................................... 37
Client/server environment....................................................................................37

Available drivers...................................................................................................... 37
Database connection URL...................................................................................... 37

Documentation conventions.............................................................................................. 39

Terminology.............................................................................................................. 39
SQL syntax............................................................................................................... 39
Typographical conventions.................................................................................... 39

Derby libraries and scripts: complete reference ............................................................ 41

Libraries provided by Derby...................................................................................41
Scripts included with Derby................................................................................... 42

Trademarks.......................................................................................................................... 44