Java DB

Apache Derby

Getting Started With Derby

Derby Getting Started
Derby Reference Manual
Derby Developer's Guide
Derby Performance Tuning
Derby Server and Admin Guide
Derby Tools and Utilities
Derby Getting Started
-Introduction to Derby

-Deployment options
-System requirements
-Product documentation for Derby

-Installing and configuring Derby

-Installing Derby
-Setting up your environment

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

-Using the Derby tools and startup utilities

-Running sysinfo
-Running ij
-Running dblook

-Verifying the Derby system configuration

-Self-study tutorial for users new to Derby

-Tutorial overview
-Activity 1: Run SQL using the embedded driver

-Creating a directory and copying scripts into the directory
-Creating a Derby database and running SQL statements

-Activity 2: Run SQL using the client driver
-Activity 3: Run a JDBC program using the embedded driver

-The WwdEmbedded program

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

-Quick start guide for experienced JDBC users

-Environments in which Derby can run

-Embedded environment
-Client/server environment

-Available drivers
-Database connection URL

-Documentation conventions

-Terminology
-SQL syntax
-Typographical conventions

-Derby libraries and scripts: complete reference

-Libraries provided by Derby
-Scripts included with Derby

Typographical conventions

This documentation uses some typographical conventions to highlight elements of the SQL language, operating system commands, and the Java programming language.

Table 1. Derby typographical conventions
Usage	Typeface	Examples
New terms	Italic	defined by keys
File and directory names	Italic	C:\derby
Dictionary objects	Italic	The Employees table
In syntax, items that you do not type exactly as they appear, but replace with the appropriate name	Italic	`CREATE TABLE tableName`
SQL examples	Bold and/or fixed-width	`SELECT city_name FROM Cities`
Java application examples	Bold and/or fixed-width	`Connection conn = DriverManager.getConnection ("jdbc:derby:Sample")`
Things you type in a command prompt	Bold and/or fixed-width	`java org.apache.derby.tools.ij`
Comments within examples	Bold and/or fixed-width	`--This line ignored`
SQL keywords (commands)	All caps	You can use a CREATE TABLE statement

Parent topic: Documentation conventions

javadb@jdbcurl.com