background image
| Contents 2 >>
| Contents 2 >>

Contents 1

Version 10.8 Derby Developer's Guide
i
Contents
Copyright................................................................................................................................5
About this guide..................................................................................................................10
Purpose of this guide..............................................................................................10
Audience................................................................................................................... 10
How this guide is organized...................................................................................10
After installing..................................................................................................................... 12
The installation directory........................................................................................ 12
Batch files and shell scripts................................................................................ 12
Derby and JVMs.......................................................................................................12
Derby libraries and classpath................................................................................ 13
UNIX-specific issues................................................................................................13
Configuring file descriptors..................................................................................13
Scripts.................................................................................................................. 13
Upgrades.............................................................................................................................. 14
Preparing to upgrade.............................................................................................. 14
Upgrading a database............................................................................................. 14
Soft upgrade limitations..........................................................................................15
JDBC applications and Derby basics............................................................................... 16
Application development overview........................................................................16
Derby embedded basics......................................................................................... 16
Derby JDBC driver.............................................................................................. 16
Derby JDBC database connection URL..............................................................17
Derby system.......................................................................................................18
A Derby database............................................................................................... 22
Connecting to databases.....................................................................................25
Working with the database connection URL attributes....................................... 28
Using in-memory databases................................................................................... 31
Working with Derby properties.............................................................................. 33
Properties overview............................................................................................. 33
Setting Derby properties......................................................................................34
Properties case study..........................................................................................37
Deploying Derby applications............................................................................................39
Deployment issues.................................................................................................. 39
Embedded deployment application overview...................................................... 39
Deploying Derby in an embedded environment.................................................. 40
Creating Derby databases for read-only use........................................................ 41
Creating and preparing the database for read-only use..................................... 41
Deploying the database on the read-only media................................................ 41
Transferring read-only databases to archive (jar or zip) files.............................. 41
Accessing a read-only database in a zip/jar file..................................................42
Accessing databases within a jar file using the classpath.................................. 43
Databases on read-only media and DatabaseMetaData.................................... 43
Loading classes from a database..........................................................................44
Class loading overview........................................................................................44
Dynamic changes to jar files or to the database jar classpath............................ 46
Derby server-side programming........................................................................................47
Programming database-side JDBC routines.........................................................47