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:
Before you upgrade Java DB, perform the tasks described below.
Verify the current version of Java DB before you upgrade.
Type the following command:
java -cp JavaDB-base\lib\derby.jar org.apache.derby.tools.sysinfo
This command returns the Java DB version information.
Java DB 10.2.2.1
Java DB 10.1.3.1
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.
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.
This section discusses considerations that impact the upgrade procedure for Java DB, followed by a description of the procedure itself.
The upgrade of Java DB software to Java ES Release 5U1 takes into account the following considerations:
In a deployment architecture in which there are multiple instances of Java DB running on a single computer (all corresponding to the same installed Java DB image), you only have to upgrade the Java DB image once.
In a maintenance upgrade, you do not have to migrate schema, configuration, security or user data.
The Release 5U1 Java DB upgrade patches for Windows are shown in the following table:
The procedure documented below applies to Java DB instances residing locally on the computer where the upgrade is taking place.
Log in as administrator.
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.
Make sure you have upgraded any Java ES components upon which Java DB has hard upgrade dependencies (see Upgrade Java DB Dependencies).
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.
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.
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.
Verify the patch log file.
The log file is found at: %TEMP%\SUNJAVAES_<patch-id>.log
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.
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\PSConfig.properties -f PortalServer-base\lib\derby.xml start-instance
Start any Java DB clients.
You can verify successful upgrade of Java DB by starting the Java DB instance as follows:
java -cp JavaDB-base\lib\derby.jar org.apache.derby.tools.sysinfo
The messages that indicate the Java ES release version are:
Java DB 10.2.2.1
Java DB 10.1.3.1
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\derbytools.java:JavaDB-base\lib\derby.jar org.apache.derby.tools.ij
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.
A rollback of the Release 5U1 upgrade cannot be achieved except by reverting to a backup Release 5 installation and its data.