In this module, you create a Java™ project
in the workbench, enable the project with pureQuery support, and create
a Java application with pureQuery
client optimization enabled.
Learning objectives
After you
complete this module, you will be able to perform the following tasks:
- Create a Java project in
the workbench and enable the project with pureQuery support.
- Create a JDBC-based Java application
and enable the project with pureQuery client optimization.
- Run SQL statements that are issued by the application statically.
- Determine which packages are created and used by pureQuery Runtime
to run the SQL statements statically.
- Extract and manage SQL statements that are issued by the application.
Time required
This module takes approximately
60 minutes to complete.
System requirements
This module requires:
- IBM® Optim™ Development Studio Version 2.2.1
- DB2® Enterprise Server Edition
Version 9.5 Fix Pack 3
- The DB2 SAMPLE database.
Information about creating the database is located at Creating the sample database (Link to the DB2 information center)