|
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