![Close [x]](http://dw1.s81c.com/i/c.gif){kind=small}
Before you start
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.
In this tutorial, take a tour of Data Studio and pureQuery using Informix® Dynamic Server (IDS). Easily work with Informix databases and build Java™ database applications using numerous unique scenarios. Learn how to productively customize SQL inside your Java program and create your own data access layers for Informix.
For additional information, refer to the other parts of the "Increase productivity in Java database development with new IBM pureQuery tools" series.
In this tutorial, see Data Studio and pureQuery in action on Informix databases. More specifically, see the following:
- Get a snapshot diagram of the Informix database. Visit the Overview Diagram from Database Explorer feature.
- Get a peek into the database, work with database objects. Visit the features within Database Explorer.
-
Start with an Informix table and create a pureQuery data access layer.
Visit the following features:
- Bottom-Up application development from tables
- pureQuery inline style sample
-
Customize the pureQuery data access layer. Visit the following
features:
- SQL Java integration productivity boost
- pureQuery host variable syntax in SQL
- Create pureQuery application development around the customized SQL. Visit the bottom-up from SQL application development.
- Start with an existing bean and existing database. Visit the following features:
- Meet-in-the-middle application development
- pureQuery annotated style
- JUnit test case samples
- Propose database schema from a bean. Visit the Top down application development feature.
- Create an Informix SQL procedure. Visit the Creating Informix procedures from the SQL editor feature.
- Create pureQuery data access for the procedure. Visit the Bottom-up application development from tables feature.
- Join results SQL queries to Informix database with Java objects. Visit the pureQuery Query over collections feature.
This article also uses the following IBM Data Studio tools:
- Database Explorer
- Integrated Query Editor
IBM® databases — IBM DB2® for Linux®, UNIX®, and Windows®, zSeries®, and iSeries®, as well as IBM IDS.
- IBM Data Studio V1.1
It is assumed that you will use the Informix 11.0 server in this tutorial. You can use this tutorial with Informix 10.0, by simply making your connection as shown in the Using an Informix JDBC driver section.
You must install and configure the DEMOXML database. Follow the steps listed below:
- Run the script found in the Download section of this tutorial. To execute the script, type dbimport -i DEMOXML (if path = c:\tmp\DEMOXML.exp, = c:\tmp).
- Ensure that you initialize your Informix server settings as listed at http://www.iiug.org/devnews/.
Table of contents
- Before you start
- Introduction to pureQuery
- Tour Data Studio and pureQuery with Informix databases
- Overview diagram from Database Explorer
- Peek into the database using the Database Explorer
- Bottom-up application development from an Informix table using pureQuery inline style
- SQL — A first-class citizen inside Java
- Bottom-up from SQL
- Meet-in-the-middle application development using annotated style and JUnit test cases
- Top-down application development
- Create SQL artifacts from the Integrated Query editor
- Bottom-up from procedures and testing using JUnit test cases
- pureQuery query over collections
- Use an Informix JDBC driver
- Summary
- Download
- Resources
- About the authors
Next steps from IBM
Tags
Use the slider bar to see more or fewer tags.
Popular tags shows the top tags for this particular content zone (for example, Java technology, Linux, WebSphere).
My tags shows your tags for this particular content zone (for example, Java technology, Linux, WebSphere).
Popular tutorial tags |
My tutorial tagsSkip to tags list
Popular tutorial tags |
My tutorial tags
