background image

Content 1

Version 10.8 Derby Server and Administration Guide

i

Contents

About this guide....................................................................................................................9

Purpose of this guide................................................................................................9
Audience..................................................................................................................... 9
How this guide is organized.....................................................................................9

Part one: Derby Server Guide........................................................................................... 11

Derby in a multi-user environment........................................................................ 11

Derby in a server framework...............................................................................11
About this guide and the Network Server documentation................................... 14

Using the Network Server with preexisting Derby applications..........................14

The Network Server and JVMs........................................................................... 14
Installing required jar files and adding them to the classpath............................. 14
Starting the Network Server................................................................................ 15
Shutting down the Network Server..................................................................... 17
Obtaining system information..............................................................................18
Accessing the Network Server by using the network client driver.......................20
Accessing the Network Server by using a DataSource object............................ 27
XA and the Network Server................................................................................ 29
Using the Derby tools with the Network Server.................................................. 29
Differences between running Derby in embedded mode and using the Network
Server.................................................................................................................. 30
Setting port numbers........................................................................................... 33

Managing the Derby Network Server.....................................................................33

Overview.............................................................................................................. 34
Setting Network Server properties...................................................................... 34
Verifying Startup.................................................................................................. 40

Managing the Derby Network Server remotely by using the servlet
interface.................................................................................................................... 40

Start-up page.......................................................................................................41
Running page...................................................................................................... 41
Trace session page............................................................................................. 42
Trace directory page........................................................................................... 42
Set Network Server parameters .........................................................................42

Derby Network Server advanced topics................................................................42

Network Server security...................................................................................... 42
Running the Network Server under the security manager.................................. 43
Running the Network Server with User Authentication....................................... 47
Network encryption and authentication with SSL/TLS........................................ 48
Configuring the Network Server to handle connections...................................... 51
Controlling logging by using the log file.............................................................. 52
Controlling tracing by using the trace facility...................................................... 52

Derby Network Server sample programs.............................................................. 53

The NsSample sample program......................................................................... 53
Network Server sample programs for embedded and client connections........... 56

Part two: Derby Administration Guide..............................................................................59

Checking database consistency............................................................................ 59

The SYSCS_CHECK_TABLE function................................................................59
Sample SYSCS_CHECK_TABLE error messages............................................. 59
Sample SYSCS_CHECK_TABLE queries.......................................................... 60