Sun Java Enterprise System 5 Update 1 Upgrade Guide for Microsoft Windows

Chapter 6 Java DB

This chapter describes how to upgrade Java DB from Java ES 5 (Release 5) to Java ES 5 Update 1 (Release 5U1): Java DB 10.2.2.

The chapter provides an overview of upgrade considerations for the different upgrade paths supported by Release 5U1. This chapter covers the following topics:

Note –

File locations in this chapter are specified with respect to a directory path referred to as JavaDB-base. This path was set by the Java ES installer when Java DB was installed.

The values of this directory path is :


C:\Program Files\Sun\JavaES5\JavaDB

Overview of Java DB Upgrades

The following sections describe general aspects of Java DB that impact upgrading to Java ES 5 Update 1 (Release 5U1):

About Release 5U1 Java DB

Release 5U1 Java DB is a maintenance release that fixes bugs in Release 5 Java DB and provides some minor enhancements.

Java DB Upgrade Roadmap

The following table shows the supported Java DB upgrade paths to Java ES Release 5U1.

Table 6–1 Upgrade Paths to Java ES 5 Update 1: Java DB 10.2.2

Java ES Release  

Java DB Release  

General Approach 

Reconfiguration Required  

Release 5 

Java DB 

Maintenance upgrade. Apply patches. 


Java DB Data

The following table shows the type of data that could be impacted by an upgrade of Java DB software.

Table 6–2 Java DB Data Usage

Type of Data 



Configuration data 

Instance configuration is application-specific and is stored in the Java DB database. 

Configuration of Java DB instance 

Persistent data 

Database directories and their contents are application-specific. Their location is specified by the database connection URL, jdbc:derby:full path to database.

Database and user certificates 

Java DB Compatibility Issues

Release 5U1 Java DB is backwardly compatible with the Release 5 version.

Java DB Dependencies

Java DB has dependency only on the J2SE shared component (see Table 1–8)

Upgrading Java DB from Java ES 5

This section includes information about upgrading Java DB from Java ES 5 to Java ES 5 Update 1. The section covers the following topics:


When upgrading Release 5 Java DB to Release 5U1, consider the following aspects of the upgrade process:

Release 5 Java DB Upgrade

This section describes how to perform an upgrade of Java DB from Java ES 5 to Java ES 5 Update 1. This section covers the following topics:

Pre-Upgrade Tasks

Before you upgrade Java DB, perform the tasks described below.

Verify Current Version Information

Verify the current version of Java DB before you upgrade.

ProcedureTo Verify Current Version Information

  1. Type the following command:

    java -cp JavaDB-base\lib\derby.jar

    This command returns the Java DB version information.

    Release 5U1

    Java DB

    Release 5

    Java DB

Upgrade Java DB Dependencies

It is generally recommended that all Java ES components on a computer system (and in a computing environment) be upgraded to Release 5U1. Release 5U1 Java DB has no hard upgrade dependencies, so upgrade of shared components is optional. However, the upgrade of Java DB to Release 5U1 requires that Windows Installer patch (126910–02) is already applied.

Backing Up Java DB Data

The Java DB upgrade from Release 5 to Release 5U1 does not modify the Release 5 configuration data. However, for the sake of security, you should back up your entire Java DB installation and your data.

Upgrading Release 5 Java DB

This section discusses considerations that impact the upgrade procedure for Java DB, followed by a description of the procedure itself.

Upgrade Considerations

The upgrade of Java DB software to Java ES Release 5U1 takes into account the following considerations:

Table 6–3 Patches to Upgrade Java DB on Windows


Patch ID [Patch revision numbers are the minimum required for upgrade to Release 5U1. If newer revisions become available, use the newer ones instead of those shown in the table.]

Java DB  


Upgrade Procedure

The procedure documented below applies to Java DB instances residing locally on the computer where the upgrade is taking place.

ProcedureTo Upgrade Java DB to Java ES 5 Update 1

  1. Log in as administrator.

  2. Stop any Java DB instances.

    If you have a network server running, use the following command:

    java -cp JavaDB-base\lib\derby.jar:JavaDB-base\lib\derbynet.jar/ org.apache.derby.drda.NetworkServerControl shutdown

    Otherwise, simply stop all applications using Java DB.

  3. Make sure you have upgraded any Java ES components upon which Java DB has hard upgrade dependencies (see Upgrade Java DB Dependencies).

  4. Obtain the required Java DB Release 5U1 upgrade patches, based on Table 6–3.

    To obtain the patch, see Accessing Java ES Patches. Patches can be downloaded to \workingDirectory.

  5. Install the patch.

    Installation is generally performed by running patch-id.exe, however, be sure to consult the README.patch-id file in the patch directory for installation instructions.

    Note –

    If you are prompted to restart the system, select No. Wait till the patch installation process is completed and then restart and re-login as the same user to complete the patch installation.

  6. Verify the patch log file.

    The log file is found at: %TEMP%\SUNJAVAES_<patch-id>.log

  7. Verify the patch installation with the utility ListJavaESPatches.exe.

    Run ListJavaESPatches.exe and check that the output includes the patch id of the patch that you have installed in Step 5. For more information, see Identifying Installed Java ES Patches.

  8. Start the Release 5 Java DB instances.

    For example, start Java DB instance for Portal Server with ANT from the command line.

    JavaES5-Install-Dir\share\ant\bin\ant.bat -DPS_CONFIG=PortalServer-base\config\ -f PortalServer-base\lib\derby.xml start-instance

  9. Start any Java DB clients.

Verifying the Upgrade

You can verify successful upgrade of Java DB by starting the Java DB instance as follows:

java -cp JavaDB-base\lib\derby.jar

The messages that indicate the Java ES release version are:

Release 5U1

Java DB

Release 5

Java DB

Post-Upgrade Tasks

When upgrading Java DB from Release 5 to Release 5 Update 1, you must convert data from the Java DB 10.1 disk format to the 10.2 format if you want to take full advantage of the enhanced functionality of Release 5U1.

To perform this conversion, connect to the database with upgrade=true appended to the JDBC URL. For example:

java -cp JavaDB-base\lib\\lib\derby.jar

ij version 10.2

ij> connect 'jdbc:derby:\databasePath;upgrade=true';

ij> exit;

For more information, see the Getting Started Guide in the docs directory of your Java DB installation.

Rolling Back the Upgrade

A rollback of the Release 5U1 upgrade cannot be achieved except by reverting to a backup Release 5 installation and its data.