Java DB

Apache Derby

Derby Developer's Guide

Derby Getting Started
Derby Reference Manual
Derby Developer's Guide
Derby Performance Tuning
Derby Server and Admin Guide
Derby Tools and Utilities
Derby Developer's Guide
-After installing
-Upgrades
-JDBC applications and Derby basics
-Application development overview
-Derby embedded basics
-Derby JDBC driver
-Derby JDBC database connection URL
-Derby system
-A Derby database
-Connecting to databases
-Working with the database connection URL attributes
-Using in-memory databases
-Working with Derby properties
-Deploying Derby applications
-Deployment issues
-Creating Derby databases for read-only use
-Loading classes from a database
-Derby server-side programming
-Programming database-side JDBC routines
-Programming trigger actions
-Programming Derby-style table functions
-Programming user-defined types
-Controlling Derby application behavior
-The JDBC connection and transaction model
-Result set and cursor mechanisms
-Locking, concurrency, and isolation
-Working with multiple connections to a single database
-Working with multiple threads sharing a single connection
-Working with database threads in an embedded environment
-Working with Derby SQLExceptions in an application
-Using Derby as a J2EE resource manager
-Derby and Security
-Configuring security for your environment
-Working with user authentication
-Users and authorization identifiers
-User authorizations
-Encrypting databases on disk
-Signed jar files
-Notes on the Derby security features
-User authentication and authorization examples
-Running Derby under a security manager
-Developing tools and using Derby with an IDE
-SQL tips
-Localizing Derby
-Derby and standards

 

The installation directory

You may install the Derby software in a directory of your choice.

See the index.html file for pointers to information on Derby.

The distribution includes setup scripts that use an environment variable called DERBY_HOME. The variable's value is set to the Derby base directory.

C:>echo %DERBY_HOME%
C:\DERBY_HOME

If you want to set your own environment, Getting Started with Derby instructs you on setting its value to the directory in which you installed the Derby software.

The distribution for Derby contains all the files you need, including the documentation set, some example applications, and a sample database.

Details about the installation:

  • index.html in the top-level directory is the top page for the on-line documentation.
  • RELEASE-NOTES.html, in the top-level Derby base directory, contains important last-minute information. Read it first.
  • /bin contains utilities and scripts for running Derby.
  • /demo contains some sample applications, useful scripts, and prebuilt databases.
    • /databases includes prebuilt sample databases.
    • /programs includes sample applications.
  • /docs contains the on-line documentation (including this document).
  • /javadoc contains the documented APIs for the public classes and interfaces. Typically, you use the JDBC interface to interact with Derby; however, you can use some of these additional classes in certain situations.
  • /lib contains the Derby libraries.
 

javadb@jdbcurl.com