SQLAdapter

PRODUCT CENTERS

Legal | Privacy

Printer View

E-mail this page

Bookmark

Building a Mobile Application with Oracle9iAS Wireless using the SQLAdapter

Module Objectives

Purpose

The purpose of this module is to demonstrate how to build a sample mobile application using Oracle9iAS Wireless. After creating a service for the sample application, you will be able to test it using a mobile simulator.

Objectives

After completing this module, you should be able to:

	List the steps necessary to create a mobile application
	Use the Service Designer to create a Master Service
	Test the application on a simulator

Prerequisites

Before starting this module you should have completed the following modules:

	Installing the Oracle9i Application Server
	Installing the Oracle9iAS Infrastructure module
	Installing the Oracle9i Application Server - Business Intelligence and Forms

Reference Material

The following is a list of useful reference material if you want additional information about the topics in this module:

	Website: http://otn.oracle.com/mobile
	Documentation: http://otn.oracle.com/ias

Overview

Oracle9i Wireless Overview

Oracle9iAS Wireless is the wireless component of the Oracle9i Application Server. In the wireless internet architecture, Oracle9iAS Wireless occupies the middle tier for developing and deploying wireless applications. Oracle9iAS Wireless provides the following features:

	Oracle9iAS Wireless includes pre-built Java content adapters that let you rapidly enable as wireless any content- databases, existing Web sites, e-mail systems, enterprise applications, and so on.
	Pre-built XML content transformers that enable your wireless applications to be accessible on different devices simultaneously.
	It offers a scaleable and open standards platform that enables carriers, enterprises, and internet companies to rapidly extend all their existing applications to any wireless Web devices and any phone through voice recognition and text-to-speech technology.
	It provides a platform that promotes e-businesses to become mobile e-businesses.
	A framework to create a HTML personalization portal where users can select the content they wish to access from their wireless device, as well as save often-used parameters that are called presets.
	Enables the creation of applications that push information to any messaging-enabled device (SMS, e-mail, and so on) based on the user preferences. Comprehensive support for the development of Location Based Services that personalize information based on users' locations.

Building a Mobile Application

Oracle9iAS Wireless provides an environment for you to design, build, test, and deploy your mobile applications. It provides the solution for the wireless enablement of your Web content allowing your content to be accessed by all mobile devices including phones, PDAs, pagers, and through multiple interfaces including voice. The four main steps include:

1.	Designing the application
2.	Building the application
3.	Testing the application
4.	Deploying the application

Designing the Application

Go back to List

Before you design and build mobile applications, it is important to understand the architecture of mobile applications. The developer needs to adopt a different approach when developing applications for the wireless device as compared to the traditional desktop applications or the applications designed for the Web. Some of the important factors to consider when developing mobile applications include the following:

	Mobile devices with limited input and screen capabilities
	The form factor of the target device and the browsing and navigation features of the mobile device need to be considered
	Diversity of content sources and wireless devices including issues of different protocols, mark-up languages and portability constraints
	Deploying the application

Building the Application

Go back to List

For this example, the content source is the employee information in the database itself. Instead of writing any XML files, you can create a Master Service that utilizes the SQLAdapter and retrieves the appropriate information from the database. Perform the following steps to build the application:

1.	You will invoke the Service Designer tool of Oracle9iAS Wireless and create the Master Service using the SQLAdapter. Open your browser and enter the following URL: http://<Server Name.Domain>:7778/webtool/login.uix Select the Service Designer tab. Click on the Create Master Service at the bottom of the window.
2.	The Basic Information window of the Master Service is displayed. Enter Employee Information as the name, select the SQLAdapter from the list, and then click Next.
3.	The Caching window of the Master Service appears. Caching is an optional parameter you will leave blank. Click Next.
4.	The Init Parameters of the Master Service appears. For the Init Parameters, the connection information is necessary to connect to the database including the servername, port, SID, username and password. You are also required to select the type of statement which enables the data to be retrieved. Enter jdbc:oracle:thin@<DB hostname>:1521:iasdb for the JDBC Connect String, hr for username and password select QUERY for the Type of Statement and enter select * from employees for The Statement. Then click Next.
5.	The Input Parameters Window appears. Since the SQLAdapter was chosen, no input parameters are required. Click Next to go to the Output Parameters window.
6.	In this window, you have the option of limiting what data you want to see from the employee table. Once you are done, click Next.
7.	For this example, enabling this application as asynchronous is not necessary. Leave the box blank and click Next.
8.	The final screen, Result Transformers, appears. Since Result Transformers are not required for our specific application, click Finish.
9.	The new Master Service is listed in the Service Designer:

Testing and Deploying the Application

Go back to List

To test the application in the simulator, click on the Test icon and you see the data of the employee table displayed:

Once you are satisfied with the output, you can deploy the application on a number of devices depending on your end users.

Module Summary

In this module, you should have learned how to:

	Identify the steps necessary to create a mobile application
	Create a Master Service based on the SQLAdapter in the Service Manager webtool
	Test and deploy the application on a simulator