Java DB

Apache Derby

Derby Server and Administration Guide

Derby Getting Started
Derby Reference Manual
Derby Developer's Guide
Derby Performance Tuning
Derby Server and Admin Guide
Derby Tools and Utilities
Derby Server and Admin Guide
-Part one: Derby Server Guide
-Derby in a multi-user environment
-Using the Network Server with preexisting Derby applications
-The Network Server and JVMs
-Installing required jar files and adding them to the classpath
-Starting the Network Server
-Shutting down the Network Server
-Obtaining system information
-Accessing the Network Server by using the network client driver
-Accessing the Network Server by using a DataSource object
-XA and the Network Server
-Using the Derby tools with the Network Server
-Differences between running Derby in embedded mode and using the Network Server
-Setting port numbers
-Managing the Derby Network Server
-Managing the Derby Network Server remotely by using the servlet interface
-Derby Network Server advanced topics
-Derby Network Server sample programs
-Part two: Derby Administration Guide
-Checking database consistency
-Backing up and restoring databases
-Replicating databases
-Logging on a separate device
-Obtaining locking information
-Reclaiming unused space

 

Using the logDevice=logDirectoryPath attribute

To specify a non-default location for the log directory, set the logDevice=logDirectoryPath attribute on the database connection URL when you create the database.

This attribute is meaningful only when you are creating a database. You can specify logDevice=logDirectoryPath as either an absolute path or as a path that is relative to the directory where the JVM is executed.

Setting logDevice=logDirectoryPath on the database connection URL adds an entry to the service.properties file. If you ever move the log manually, you will need to alter the entry in service.properties. If you move the log back to the default location, remove the logDevice entry from the service.properties file.

To check the log location for an existing database, you can retrieve the logDevice=logDirectoryPath attribute as a database property by using the following statement:

VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('logDevice')

For more information, see "logDevice=logDirectoryPath attribute" in the Derby Reference Manual.

 

javadb@jdbcurl.com