 | Level: Intermediate Tyler Anderson (tyleranderson5@yahoo.com), Freelance writer and developer, Backstop Media
05 Aug 2008 Web services are a popular way to communicate data over the
Internet in XML format; databases have long since been an integral part of any Web
application. With IBM® Data Studio, developers can integrate the two by defining SQL and SQL/XML queries that you can automatically build and deploy as a Web service. In this tutorial, you'll develop a data-driven Web service using Data Studio and craft an Ajax application for the gaming industry where users can browse games they want to play, search for them by title, and even add, edit, and delete games. The Ajax application running on the client communicates with the gaming Web service in XML format, both of which are served on WebSphere® Application Server.
In this tutorial
This tutorial shows developers how to develop data-driven Web services more efficiently
with the help of XML and IBM Data Studio. You'll use Data Studio to manage a connection to
a gaming database by creating several queries; you'll expose that connection through a
gaming Web service. Thus, with the help of Data Studio, XML, and marginal Web service
knowledge, you'll create an Ajax client to communicate with the gaming Web service to
manage free Flash games, both of which you'll deploy on the IBM WebSphere® Application Server Community Edition (hereafter referred to as Community Edition).
Objectives - Follow quick install instructions on Data Studio and Community Edition.
- Use the DB2 Control Center to create and setup a new database with table.
- Create your very first data development project in Data Studio.
- Create SQL and SQL/XML scripts using SQL editor in Data Studio.
- Expose SQL and SQL/XML scripts as a gaming Web service.
- Create an Ajax application to manage free Flash games through the gaming Web service.
Prerequisites
This tutorial is recommended for XML and Ajax developers interested in creating
data-driven Web services to provide data to their Ajax applications. It's also for
those interested in making their development time more efficient by using the
hands-free auto-creation features provided by Data Studio. Using Data Studio,
developers will build and deploy a Web service out of several SQL and SQL/XML scripts
that will communicate with an Ajax client. A server-based programming language, such
as Java™ or PHP, is unnecessary.
System requirements
You will need JavaScript enabled in your browser. To follow along in this tutorial, you're going to need the following tools:
-
Data Studio
—This free plug-in, previously DB2 Developer Workbench, contains the data-development and SQL editor capabilities you'll use for efficient database and XML-driven Web services development. This tutorial uses version 1.1.2.
- Java application server—You'll need a Java application server to host the Web service you'll create and deploy through Data Studio. Since the Community Edition installer comes with the Data Studio installation and Community Edition has all the Web services support you'll need, it's a good candidate to use as an application server. This tutorial uses version 1.1.
- Database—Data Studio requires a live database connection for data development and Web service creation. This tutorial requires an XML database. IBM DB2 Express-C is such a database. This tutorial uses version 9.5. For instructions on installing DB2, see the IBM developerWorks tutorial "Use an XML database in PHP and Java applications."
Duration
1 hour
Formats html, pdf
| | | |
