Upgrading Java applications that use IBM Data Server Driver for JDBC and SQLJ

Upgrading Java™ applications that use previous releases of the IBM Data Server Driver for JDBC and SQLJ involves managing the changes between different releases of this driver and the changes in Db2® version 12.1 that can impact these applications.

Before you begin

• Review the upgrade essentials for applications to identify key changes that might impact your Java database applications.
• Ensure that you have access to a Db2 version 12.1 server, including instances and databases. The Db2 server can be part of a testing environment.
• Ensure that the Java application development software and IBM Data Server Driver for JDBC and SQLJ are at a version level that is supported by Db2 database products.
• Perform the previous steps in the upgrading database applications task.

Restrictions

• This procedure applies only to Java applications using the IBM Data Server Driver for JDBC and SQLJ.

To upgrade your Java database applications using the IBM Data Server Driver for JDBC and SQLJ to Db2 version 12.1:

1. Install the version of the IBM Data Server Driver for JDBC and SQLJ that corresponds to the version and fix pack level of your Db2 copy. See Java software support for Db2 products for a complete list of supported drivers.

   • For methods in JDBC 4.0 or earlier specifications in your applications, install IBM Data Server Driver for JDBC and SQLJ Version 4.13 or later.

2. Adjust your applications to manage the differences between the current version of the IBM Data Server Driver for JDBC and SQLJ and the previous versions.
3. If you changed your Java application source code, rebuild your Java application. Refer to one of the following tasks for details on how to rebuild them:
   • Building JDBC applications

   • Building SQLJ applications

Results

Upon completion of this task, your Java application should perform successfully using Db2 version 12.1.

What to do next

After upgrading your Java applications, perform the remaining steps in the upgrading database applications task.