Integrating the spring framework and data Studio

PureQuery is a new IBM development platform included in Data Studio for developing Java™ database access applications. Its simple API and integration tools not only improve the efficiency of data access developers, but also encourage adherence to coding best practices for better application performance. Spring is an open source JAVA/J2EE application framework that provides more advanced data access features such as transaction management, resource management, and the data access Object hierarchy. Integrating it with PureQuery will lead to a simpler application development and maintenance experience. This tutorial guides you through building a pureQuery application with the Spring Framework data access feature.

About this tutorial

This tutorial shows you how to create a variety of Java data access applications step-by-step in the IBM database Studio. It is described in two ways: one with pureQuery or spring support, and one without pureQuery or spring support.

Learn the following:

Use IBM data Studio Developer to create a simple Java data Access application that accesses the DB2 sample database

Implementing the same Java data Access application using Spring's JdbcTemplate

Use Spring to create a Data Studio pureQuery application by using the following steps:

Build a pureQuery application and run it

To add Spring data access support to a generated pureQuery application

Run this application through the PureQuery static binding feature

Prerequisite

This tutorial is intended for database programmers who have a certain understanding of data Studio or Eclipse environment, but not necessarily familiar with the pureQuery or Spring Framework.

System Requirements

This tutorial requires that you install the following products:

IBM DB2 9.5 with SAMPLE database for Linux, UNIX and Windows

IBM Data Studio Developer V 1.1.x. You can also use IBM Data Studio 1.1.x, which is downloaded from the Web, but it does not support the static binding that will be described in the last section

Spring Framework 2.0.x with dependencies

IBM PureQuery and Spring Integration Toolkit