WebSphere Adapter for JDBC
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.
After completing the tutorial, you should be able to perform the following tasks:
This tutorial should take less than one hour to finish.
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.
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);
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.
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)