Increase productivity in Java database development with new IBM pureQuery tools, Part 3: pureQuery rapid application development

Level: Intermediate

Sonali Surange (ssurange@us.ibm.com), pureQuery Tools Lead, IBM　
Shahneela Rahman (rahmans@us.ibm.com), Quality Engineer, IBM
Mark Hager (mhager@us.ibm.com), Quality Engineer, IBM

08 Nov 2007

	Register now or sign in using your IBM ID and password.

With IBM® pureQuery platform and Eclipse tools, rapidly build simple, high-performing data access layers and applications with much less code than JDBC and much higher productivity than any other Eclipse-based tools.

Objectives

• Rapidly build pureQuery applications.
  
  
• Get an introduction to the pureQuery programming styles.
  
  
• Use the sample program and JUnit generation features to execute the generated applications without writing a single line of code.
  
  
• Learn how pureQuery Eclipse integration provides flexibility and facilitates highly productive application development.
  
  
• Modify the generated application.
  
  
• Use pureQuery SQL editor integration inside Java programming using code assist.
  
  
• Execute SQL functionality.
  

Prerequisites

Though it is not required, it may be helpful to have completed the first two parts in this series.

Refer to Part 1 of this series for an overview of pureQuery tools.

Refer to Part 2 of this series to detect and fix SQL errors as you type in your Java program.

System requirements

To run the examples in this tutorial, you must install and configure the SAMPLE database that is included with DB2 V9.5. See the DB2 product documentation and first steps for more information. You need installation access and authority to the Data Studio 9.5 source code. You must be able to connect to the SAMPLE database with a user ID and password.

Duration

Formats

Series overview

This tutorial is part of a series of articles and tutorials that explore how you can increase productivity in Java database development with new IBM pureQuery tools.

Tutorial overview

This tutorial focuses on pureQuery rapid application development using IBM pureQuery Eclipse-based tools:

• Build pureQuery method-style applications without writing any code by:
  
  • Generating a pureQuery application from database tables and procedures
  • Generating a pureQuery application from Java beans
  • Generating JUnit test cases for your application
• Customize a pureQuery application to fit for your business requirements using pureQuery's flexible tools within the Java editor by modifying:
  
  • Your SQL, using SQL and Java integration
  • The pureQuery application to use the customized SQL

This article also uses the following IBM Data Studio tools:

• Database Explorer
• Data connection persistence options

Share this.... Digg this story del.icio.us Slashdot it!

Back to top