• Copyright
• License
• About this guide
  • Purpose of this guide
  • Audience
  • How this guide is organized
• Part One: Derby Server Guide
  • Derby in a multi-user environment
    • Derby in a server framework
      • Connectivity configurations
      • Multiple-client features available in Derby
        • Row-level locking
        • Multiple concurrency levels
        • Multi-connection and multi-threading
        • Administrative tools
      • The Derby Network Server
      • Embedded servers
      • How to start an embedded server from an application
      • Embedded server example
    • About this guide and the Network Server documentation
  • Using the Network Server with preexisting Derby applications
    • The Network Server and Java Virtual Machines (JVMs)
    • Installing required jar files and adding them to the classpath
    • Starting the Network Server
      • Starting the Network Server from a Java application
      • Starting the Network Server on IPv6/IPv4 dual stack Windows machines
    • Shutting down the Network Server
      • Shutting down by using the command line
      • Shutting down by using the API
    • Obtaining system information
      • Obtaining system information by using the command line
      • Obtaining system information by using the API
        • Obtaining Network Server runtime information
        • Obtaining Network Server properties by using the getCurrentProperties method
    • Accessing the Network Server by using the network client driver
      • Network client tracing
      • Network client driver examples
    • Accessing the Network Server by using a DataSource object
      • DataSource access examples
    • XA and the Network Server
      • Using XA with the network client driver
    • Using the Derby tools with the Network Server
      • Using the Derby ij tool with the Network Server
      • Using the Derby dblook tool with the Network Server
    • Differences between running Derby in embedded mode and using the Network Server
      • Differences between the embedded client and the network client driver
      • Updatable result sets
      • Differences in JDBC methods
      • Differences using the Connection.setReadOnly method
    • Setting port numbers
  • Managing the Derby Network Server
    • Overview of Derby Network Server management
      • Using the NetworkServerControl API
    • Setting Network Server properties
      • derby.drda.host property
      • derby.drda.keepAlive property
      • derby.drda.logConnections property
      • derby.drda.maxThreads property
      • derby.drda.minThreads property
      • derby.drda.portNumber property
      • derby.drda.securityMechanism property
      • derby.drda.sslMode property
      • derby.drda.startNetworkServer property
      • derby.drda.streamOutBufferSize property
      • derby.drda.timeSlice property
      • derby.drda.traceAll property
      • derby.drda.traceDirectory property
    • Verifying startup
  • Using Java Management Extensions (JMX) technology
    • Introduction to the Derby MBeans
    • Enabling and disabling JMX
      • Enabling remote JMX with no authentication or SSL
      • Enabling remote JMX with password authentication only
      • Enabling remote JMX with password authentication and SSL
      • Simple authorization using an access file
      • Fine-grained authorization using a security policy
      • Disabling access to MBeans
    • Using JConsole to access the Derby MBeans
    • Using custom Java code to access the Derby MBeans
    • Troubleshooting JMX connection issues
  • Managing the Derby Network Server remotely by using the servlet interface
    • Start-up page
    • Running page
    • Trace session page
    • Trace directory page
    • Set Network Server parameters
  • Derby Network Server advanced topics
    • Configuring the Network Server to handle connections
    • Controlling logging by using the log file
    • Controlling tracing by using the trace facility
      • Turning on the trace facility
      • Turning off the trace facility
  • Derby Network Server sample programs
    • The NsSample sample program
      • Running the NsSample sample program
    • Network Server sample programs for embedded and client connections
      • Overview of the SimpleNetworkServerSample program
      • Running the SimpleNetworkServerSample program
      • Connecting a client to the Network Server with the SimpleNetworkClientSample program
      • Running the SimpleNetworkClientSample program
• Part Two: Derby Administration Guide
  • Maintaining database integrity
  • Checking database consistency
    • The SYSCS_CHECK_TABLE function
    • Sample SYSCS_CHECK_TABLE error messages
    • Sample SYSCS_CHECK_TABLE queries
  • Backing up and restoring databases
    • Backing up a database
      • Offline backups
      • Online backups
        • Using the backup procedures to perform an online backup
        • Using operating system commands with the freeze and unfreeze system procedures to perform an online backup
      • When the log is in a non-default location
      • Backing up encrypted databases
    • Restoring a database from a backup copy
    • Creating a database from a backup copy
    • Roll-forward recovery
  • Importing and exporting data
    • Methods for running the import and export procedures
    • Bulk import and export requirements and considerations
    • Bulk import and export of large objects
    • File format for input and output
    • Importing data using the built-in procedures
      • Parameters for the import procedures
      • Import into tables that contain identity columns
    • Exporting data using the built-in procedures
      • Parameters for the export procedures
    • Examples of bulk import and export
    • Running import and export procedures from JDBC
    • How the import and export procedures process NULL values
    • CODESET values for import and export procedures
  • Replicating databases
    • Starting and running replication
    • Stopping replication
    • Forcing a failover
    • Replication and security
    • Replication failure handling
  • Logging on a separate device
    • Using the logDevice=logDirectoryPath attribute
    • Example of creating a log in a non-default location
    • Example of moving a log manually
    • Issues for logging in a non-default location
  • Obtaining locking information
    • Monitoring deadlocks
  • Reclaiming unused space
• Trademarks