WebSphere Adapter for JDBC

Introduction

The tutorial provides a complete set of instructions for configuring the adapter so that it can be used by a J2EE component to send requests to the database. The tutorial demonstrates creating a record, which has a parent-child relationship, in a database table. The scenario also shows how to use a stored procedure attached to a business object.

Learning objectives

After completing the tutorial, you should be able to perform the following tasks:

Time required

This tutorial should take less than one hour to finish.

Audience

The tutorial is intended for the integration developer who will be configuring the Adapter for JDBC for deployment on WebSphere Process Server or WebSphere Enterprise Service Bus.

Prerequisites

Before you begin the tutorial, make sure you have performed the following tasks:

Create tables and stored procedures

The following tables and stored procedures must be created in the database to run the tutorial.
  • Script for creating the Customer and Address tables:
    CREATE TABLE CUSTOMER (
              "PKEY" VARCHAR(10) NOT NULL PRIMARY KEY,
              "FNAME" VARCHAR(20),
              "LNAME VARCHAR(20),
              "CCODE" VARCHAR(10);
    
    CREATE TABLE ADDRESS (
              "ADDRID" VARCHAR(10) NOT NULL PRIMARY KEY,
              "CUSTID" VARCHAR(10),
              "CITY" VARCHAR(20),
              "ZIPCODE" VARCHAR(10);        
  • Creating the stored procedure:

    You can create the stored procedure using the IBM® DB2® Development Center. In the development center, create a new Java™ stored procedure using the wizard. Create a stored procedure that does an insert on the Address table.


Terms of use |

Last updated: Tue 12 Dec 2006 03:32:39

(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)