Article : Optimize your existing JDBC applications using pureQuery

Description
In Version 1.2, Data Studio Developer and Data Studio pureQuery Runtime include a new feature called client optimization that enables DBAs and developers to take advantage of the benefits of static SQL execution without having to modify their existing custom-developed, framework-based, or packaged JDBC applications. This tutorial shows you how to use the tooling provided by Data Studio Developer to enable a JDBC application to use this new capability.

Objectives

• Create a sample database and import the sample JDBC application into Data Studio Developer 1.2

• Run the application using one code path and capture its SQL

• Optionally, browse the sample application's SQL and its relationship to the Java source code

• Configure and bind the captured SQL to a database package

• Run the sample application in static SQL execution mode, and validate its correct behavior

• Run the application using another code path to capture the remaining SQL; then rebind and re-run the application using static SQL execution...

[Read More..]

Courtesy: Ibm.com