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

 

Updatable Result Sets

The functionality of updatable result sets in a server environment are similar to an embedded environment in Derby, with the exception of the following differences:
  • The Network Client requires that there be at least one column in the select list from the target table. For example, the following statement will fail in a server environment:
    select 1, 2 from t1 for update of c11
    The Network Client driver looks at both of the columns in the select list and cannot determine the target table for update/delete by looking at the column metadata. This requirement is not necessary in an embedded environment.
  • The embedded driver allows for statement name changes when there is an open result set on the statement object. This is not supported in a server environment.
Other differences between updatable result sets in a server or embedded environment can be found in the following table.
Table 1. Comparison of updatable result sets features in server and embedded environments
Embedded environment Server environment
updateBytes on CHAR, VARCHAR, LONG VARCHAR datatypes supported. Not supported
updateTime on TIMESTAMP datatypes supported. Not supported
updateClob and updateBlob supported. Not supported
 

javadb@jdbcurl.com