 | Level: Intermediate Michael L. Pauser (pauser@us.ibm.com), Developer, IBM Patsy Yu (patsyyu@us.ibm.com), Software Engineer, IBM
06 Mar 2008 IBM® Data Studio V1.1 contains many new features, one of which is Data
Web Services. Data Web Services allows you to quickly and easily expose database operations (SQL SELECT, INSERT, UPDATE, and DELETE) and stored procedures CALLs as a Web service operation to client applications.
Data Web Services requires no programming knowledge or past Web service experience.
This tutorial takes you through the steps to deploy a Data Web service created by IBM
Data Studio's Data Web Services to a WebSphere® Application Server Community Edition
Web server. Objectives - Add a WebSphere Application Server Community Edition Web server instance.
- Deploy a Data Web Services Web service to a local WebSphere Application Server Community Edition Web server.
- Deploy a Data Web Services Web service to a remote WebSphere Application Server Community Edition Web server.
- Deploy a Data Web Services Web service to a WebSphere Application Server Community Edition Web server from a .WAR file.
Prerequisites
This tutorial is written for database programmers who are familiar with IBM Data
Studio and know how to create a database connection, data development project, SQL
scripts, or
stored procedures, and have completed Part 1 of this series.
System requirements
This tutorial assumes that you have the following products installed:
-
IBM DB2® for Linux®, UNIX®, Windows® V9.5. However, you can use any supported
Data Web Service DB2 database. In addition, you must have the DB2 SAMPLE
database installed. If you do not have this SAMPLE database installed, refer
to your DB2 Information Center for instructions on the installation of the
SAMPLE database.
-
IBM Data Studio V1.1. During installation, ensure that the Data Web Services
Development component is selected.
-
IBM WebSphere Application Server Community Edition V1.1.0.2, a free Web
server from IBM. A WebSphere Application Server Community Edition installation image may be bundled with your IBM Data
Studio installation. If not, visit the
WebSphere Application Server Community Edition download page
and follow the link for previous version(s) for additional information, or to
download the WebSphere Application Server Community Edition V1.1.0.2 installation image.
-
A Data Development Project with a Data Web Service. This tutorial uses the data
development project from Part 1 of this series.
Duration
Formats html, pdf
Tutorial overview
As discussed in Part 1 of this
series, exposing your SQL scripts and stored procedures as a Web service is an easy task to perform.
As Data Web Service supports multiple Web servers, each Web server has its own
nuances. This tutorial focuses on using WebSphere Application Server Community
Edition.
|  | |  |