DB2 10.5 for Linux, UNIX, and Windows

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 10.5 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 10.5 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.

Procedure

To upgrade your Java database applications using the IBM Data Server Driver for JDBC and SQLJ to DB2 Version 10.5:

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.
- If you use 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.
- If you use methods in JDBC 3.0 or earlier specifications in your applications, install IBM Data Server Driver for JDBC and SQLJ Version 3.63 or later
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.
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 10.5.

What to do next

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