Next >

Tutorial: Developing a Java application that uses pureQuery annotated methods

This tutorial introduces you to some of the features in IBM® Data Studio that you can use to develop an application that uses pureQuery annotated methods.
A company is using IBM Data Studio and pureQuery to develop applications that query and update the company's primary database: GSDB. You are a Java™ developer assigned to this project, and one of your tasks is to develop Java objects that these applications can use to query and update the INVENTORY_LEVELS table. This table records the levels of inventory of the company's products in different warehouses over different periods of time.

You need to create a bean that represents the INVENTORY_LEVELS table. You also need to create an interface that declares pureQuery annotated methods that run SQL statements against this table.

Finally, because the GSDB database is a DB2® database, your project lead wants to take advantage of the speed and security of static SQL. So, you need to bind the SQL and test running the statements statically.

Learning objectives

In this tutorial, you will learn how to:

Time required

This tutorial should take approximately 60 minutes to finish. If you explore other concepts related to this tutorial, it could take longer to complete.

Skill level


You should have experience developing Java applications. You should also have a good understanding of SQL.

Finally, you should have a good understanding of pureQuery annotated methods and reasons for using them. For an excellent introduction to pureQuery annotated methods, see "Write high performance, Java data access applications, Part 1: Introducing pureQuery annotated method style."


Java developers

System requirements

For this tutorial, you need to install:
Next >