Page tree
Skip to end of metadata
Go to start of metadata

Purpose

The purpose of this page is to provide instructions for updating the SQL Anywhere Oracle (formerly Sun) Java Runtime Environment (JRE).

Overview

An update of the Oracle JRE should only be performed if corporate policy prevents you from using a JRE without the most recent security updates. Regular updates of the JRE are not required and do not affect the stability or performance of SQL Anywhere.

*** Note that the SAP JRE is now shipped with SQL Anywhere instead of the Oracle JRE as of builds 12.0.1.3994 and 16.0.1691 and higher. Once you have upgraded SQL Anywhere to these builds or higher, please do NOT update the SAP JRE to use the Oracle JRE. ***

A copy of the JRE is included with SQL Anywhere for Microsoft Windows, Linux, and Solaris operating systems. The SQL Anywhere administration tools, including Interactive SQL, Sybase Central, MobiLink Monitor, and DBConsole, use the JRE. In addition, MobiLink and the database server use the JRE for the Java external environment. The most recent version of the JRE is included with the SQL Anywhere general availability (GA) release. If the JRE is updated after the GA release and it affects the functionality of the SQL Anywhere application, an updated JRE is provided in an express bug fix (EBF). Security improvements made to the JRE that do not affect the functionality of SQL Anywhere are not provided.

Although updating the JRE should not affect the functionality of SQL Anywhere, the update might cause unexpected results. Updating the JRE installed with SQL Anywhere should not affect other Java software running on the computer. The administration tools use the JRE included with SQL Anywhere and are unaffected by any other JRE that is installed on the same computer..

Update Restrictions

Updates to the JRE are subject to the following restrictions:

  • You cannot install a JRE with a different version number. For example, SQL Anywhere 10.0.1 includes JRE version 1.5.0 update 10. You can update to JRE 1.5.0 update 16, but not JRE 1.6.0 or JRE 1.4.2.
  • You cannot replace a 32-bit JRE with a 64-bit JRE.
  • You cannot replace the SAP JRE with an Oracle JRE.

SQL Anywhere JRE Versions

A different JRE is included with most SQL Anywhere releases. The following table lists the JRE versions that are included with SQL Anywhere.

SQL Anywhere VersionJRE VersionLast Update Tested
9.0.21.4.218
10.0.01.5.016
10.0.11.5.016
11.0.01.6.004
11.0.11.6.004
12.0.01.6.016 
12.0.1.3993 (and lower)1.6.0 16
16.0.1690 (and lower)1.7.0 07

Upgrading the JRE on Microsoft Windows Operating Systems

  1. Shut down all SQL Anywhere software.
  2. Open the Task Manager and confirm that the fast launcher processes for Interactive SQL (dbisql) and Sybase Central are not running.
  3. Rename the JRE directory of your SQL Anywhere software. Administrator permissions are required to make these changes on Microsoft Windows Vista operating systems.

    VersionExisting File PathNew Name
    9.0.2C:\Program Files\Sybase\Shared\Sun\jre142jre142.bak
    10.0.xC:\Program Files\SQL Anywhere 10\Sun\jre142jre150.bak
    11.0.xC:\Program Files\SQL Anywhere 11\Sun\jre160_x86jre160_x86.bak
    12.0.1.3993 (and lower)C:\Program Files\SQL Anywhere 12\Sun\jre160_x86jre160_x86.bak
    16.0.1690 (and lower)C:\Program Files\SQL Anywhere 16\bin32\jre170 jre170.bak 

    If you are using a 64-bit application for version 11.0.x, 12.0.x, or 16.0.x, you also need to rename the directory to jre16_x64.

  4. Download and install the new JRE. Do not install the Java Development Kit (JDK).
  5. Use one of the following xcopy commands to copy the new JRE files into the SQL Anywhere directory:
    For JRE 1.4.2_18: xcopy "C:\Program Files\java\j2re1.4.2_18" "C:\Program Files\Shared\Sun\jre142\" /s /b
    For JRE 1.5.0_16: xcopy "C:\Program Files\java\jre1.5.0_16" "C:\Program Files\SQL Anywhere 10\Sun\jre150\" /s /b
    For a 32-bit JRE 1.6.0_05: xcopy "C:\Program Files\java\jre1.6.0_05" "C:\Program Files\SQL Anywhere 11\Sun\jre160_x86" /s /b
    For a 64-bit JRE 1.6.0_05: xcopy "C:\Program Files\java\jre1.6.0_05" "C:\Program Files\SQL Anywhere 11\Sun\jre160_x64" /s /b
    For a 32-bit JRE 1.7.0_08: xcopy "C:\Program Files\java\jre1.7.0_08" "C:\Program Files\SQL Anywhere 16\bin32\jre170" /s /b
    For a 64-bit JRE 1.7.0_08: xcopy "C:\Program Files\java\jre1.7.0_08" "C:\Program Files\SQL Anywhere 16\bin34\jre170" /s /b
  6. Uninstall the JRE from step 4.

Upgrading the JRE on Linux Operating Systems

  1. Shut down all SQL Anywhere software.

  2. Rename the JRE directory of your SQL Anywhere software.

    VersionExisting File PathNew Name
    9.0.2/opt/sybase/shared/jre_1.4.2_linux_sun_i386jre_1.4.2_linux_sun_i386.bak
    10.0.x/opt/sqlanywhere10/sun/jre_1.5.0_linux_sun_i586jre_1.5.0_linux_sun_i586.bak
    11.0.x/opt/sqlanywhere11/sun/jre_1.6.0_linux_sun_i586jre_1.6.0_linux_sun_i586.bak
    12.0.1.3993 (and lower)/opt/sqlanywhere12/sun/jre_1.6.0_linux_sun_i586 jre_1.6.0_linux_sun_i586.bak
    16.0.1690 (and lower) /opt/sqlanywhere16/bin32/jre170jre170.bak 

    If you are using a 64-bit application with version 11.0.x or 12.0.x you also need to rename the directory jre_1.6.0_linux_sun_x64.
    If you are using a 64-bit application with version 16.0.x you also need to rename the directory /bin64/jre170

  3. Download and install the new JRE. Do not install the Java Development Kit (JDK).
  4. Use one of the following cp commands to copy the new JRE files into the SQL Anywhere directory:
    For JRE 1.4.2_18: cp –Rp j2re1.4.2_18 /opt/sybase/shared/jre_1.4.2_linux_sun_i386
    For JRE 1.5.0_16: cp –Rp jre1.5.0_16 /opt/sqlanywhere10/jre_1.5.0_linux_sun_i586
    For 32-bit JRE 1.6.0_05: cp –Rp jre1.6.0_05 /opt/sqlanywhere11/jre_1.6.0_linux_sun_i586
    For 64-bit JRE 1.6.0_05: cp –Rp jre1.6.0_05 /opt/sqlanywhere11/jre_1.6.0_linux_sun_x64
    For 32-bit JRE 1.7.0_08: cp –Rp jre1.7.0_08 /opt/sqlanywhere16/bin32/jre170
    For 64-bit JRE 1.7.0_08: cp –Rp jre1.7.0_08 /opt/sqlanywhere16/bin64/jre170

  5. Uninstall the JRE from step 3.

Upgrading the JRE on Solaris Operating Systems

  1. Shut down all SQL Anywhere software.
  2. Rename the JRE directory of your SQL Anywhere software.

    VersionExisting File PathNew Name
    9.0.2/opt/sybase/shared/jre_.4.2_solaris_sun_sparcjre_1.4.2_solaris_sun_sparc.bak
    10.0.x/opt/sqlanywhere10/sun/jre_1.5.0_solaris_sun_sparcjre_1.5.0_solaris_sun_sparc.bak
    11.0.x/opt/sqlanywhere11/sun/jre_1.6.0_solaris_sun_sparcjre_1.6.0_solaris_sun_sparc.bak
    12.0.x/opt/sqlanywhere12/sun/jre_1.6.0_solaris_sun_sparcjre_1.6.0_solaris_sun_sparc.bak
    16.0.x /opt/sqlanywhere16/bin64/jre170 jre170.bak 
  3. Download and install the new JRE. Do not install the Java Development Kit (JDK).
  4. Use one of the following cp commands to copy the new JRE files into the SQL Anywhere directory:
    For JRE 1.4.2_18: cp –Rp j2re1.4.2_18 /opt/sybase/shared/jre_1.4.2_solaris_sun_sparc
    For JRE 1.5.0_16: cp –Rp jre1.5.0_16 /opt/sqlanywhere10/sun/jre_1.5.0_solaris_sun_sparc
    For JRE 1.6.0_05: cp –Rp jre1.6.0_05 /opt/sqlanywhere11/sun/jre_1.6.0_solaris_sun_sparc
    For JRE 1.7.0_08: cp –Rp jre1.7.0_08 /opt/sqlanywhere16/bin64/jre170
  5. Uninstall the JRE from step 3.

Verifying the JRE Installation

It is recommended that you perform diagnostic testing to verify that the JRE upgrade has not affected SQL Anywhere. If you encounter issues with SQL Anywhere after the JRE upgrade, use the .bak directories to revert to the previous version of the JRE.

Related Content

Related Documents

Related SAP Notes/KBAs

 

  • No labels