Oracle9i Application Server Wireless Edition Implementation Guide Release 1.1 Part Number A86699-01 |
Library | Service | Contents | Index

# 2
Wireless Edition Tools

This document describes the tools you can use to develop and maintain the Oracle9i Application Server Wireless Edition. Each section of this document presents a different topic. These sections include:

- Section 2.1, "Overview"

- Section 2.2, "Development Tools"

- Section 2.3, "Personalization"

## 2.1 Overview

The Wireless Edition provides tools to help you create, manage, and deliver mobile services. These tools include visual interfaces for developing and managing repository objects, and utilities for managing the server and deploying the Wireless Edition.

## 2.2 Development Tools

The Wireless Edition provides the following visual development tools:

- Service Designer

- Master Service Creation Wizard

- Region Modeling Tool

### 2.2.1 Service Designer

The Service Designer is a visual interface for implementing and managing the Wireless Edition.

#### Figure 2-1 The Service Designer

Text description of the illustration too_svcd.gif

You use the Service Designer to create and modify objects in the Wireless Edition repository. These objects include:

Table 2-1 Objects in the Wireless Edition Repository

Object Type | Description
--- | ---
Adapter | Adapter objects represent the Wireless Edition interface to content sources. Adapter objects have an attribute called `classes`. This attribute identifies the archive file that contains the actual Java implementation of the adapter.
Master service | The master service object implements the service and invokes a specific adapter. You can associate a custom transformer with a master service. Custom transformers are service- and device-specific. They can be used by only one device and one master service.
Alias | An alias is a pointer to a master service, folder, bookmark, or other alias. You can use aliases to distribute access to services and to override default parameter values defined by the master service. You can make a service accessible to a user by placing an alias to the service in a tree the user owns or can access.
Folder | You can use folders to group services. Folders make services available to end users. Every user has a "home" folder. This contains the services, usually referenced by an alias, that the user can access. A user can also access any service in a folder owned by a group to which the user belongs.
User group | User groups help you manage service access for multiple users. You can create user groups based on factors such as subscription level, geographic location, or interests.
Transformer | A transformer converts the content returned by the Wireless Edition adapters. Transformer types include: Result transformers, which convert Adapter Result content into SimpleResult content. Device transformers, which convert SimpleResult content into the final target format. A device transformer can be either the default transformer for a logical device, or a custom transformer, which is used to render a specific master service for a specific logical device.
Logical device | A logical device object associates a physical device or an abstract device, such as email, with a transformer.
Bookmarks | End users can set bookmarks to external URLs at the Personalization Portal. The bookmark appears as a menu selection in the device portal. The Wireless Edition does not process the content of the URL target. The format of the target content must be supported by the user's device.

The Service Designer provides a tree view of the Wireless Edition repository. The tree shows Wireless Edition object classes, such as adapters and transformers, as folders, or branch nodes. For more information on using the Service Designer, see Chapter 3, "Wireless Edition Services". See the Oracle9i Application Server Wireless Edition Developer's Guide for more information on transformers and adapters.

The Service Designer includes the following tools:

- Master Service Creation Wizard

- Transformer Creation and Testing Tool

- Region Modeling Tool

These tools, which you access from the Tools menu in the Service Designer, enable you perform administrative tasks quickly and easily.

#### 2.2.1.1 Master Service Creation Wizard

In addition to the Service Designer, The Wireless Edition enables you to successfully create a service with the Master Service Creation Wizard. The Master Service Creation Wizard guides you through the creation of a master service by presenting a separate screen for each step in the sequence. For more information using the Master Service Creation Wizard, see Section 3.3, "Creating a Master Service" in Chapter 3, "Wireless Edition Services" and Chapter 9, "Walkthroughs".

#### Figure 2-2 The Welcome Screen of the Master Service Creation Wizard

Text description of the illustration too_mswi.gif

### 2.2.2 The Transformer Testing Tool

The Wireless Edition includes the Transformer Testing Tool, a tool for testing and creating transformers. Transformers, in the form of XSLT stylesheets or Java classes, convert the content returned by the Wireless Edition adapters into the format best suited to a particular platform. See the Oracle9i Application Server Wireless Edition Developer's Guide for more information on Wireless Edition XML.

The Transformer Testing Tool enables you to both test and create transformers using a single screen. The tool allows you to view and edit adapter input parameters and the transformers of the source content. For more information on using the Transformer Testing Tool, see the Oracle9i Application Server Wireless Edition Developer's Guide.

#### Figure 2-3 The Transformer Testing Tool

Text description of the illustration too_tctt.gif

### 2.2.3 Region Modeling Tool

The Wireless Edition enables you to create location-based services using the Region Modeling Tool. Using this graphical interface, you can create services that are visible to Wireless Edition users at specific locations.

The Region Modeling Tool enables developers to create these location-based services by assigning a location to a folder or to a master service from the spatial data repository. The tool enables you to view a spacial object as a map image with its corresponding geometry. In addition, the tool enables you to access, view, and modify the data stored in the spatial database in the Wireless Edition repository. For more information on the Region Modeling Tool, see Chapter 4, "Using the Region Modeling Tool".

#### Figure 2-4 The Region Modeling Tool

Text description of the illustration too_stal.gif

### 2.2.4 The Web Integration Developer

The Web Integration Developer is a visual interface for creating and testing WIDL services. The Web Integration adapter uses WIDL services to map Web content. You also use the Web Integration Developer to publish the WIDL interfaces to the Web Integration Server.

When you create a WIDL service, you parameterize a source page. You create input parameters for input elements, such as text fields and selection lists, and output parameters for returned content. The Web Integration adapter renders the Web content in one of the Wireless Edition result formats. It converts the content according to the rules defined in the adapter. For example, record variables, which you can create in the Web Integration Developer, are data structures that assemble related variables in a group. The Web Integration adapter converts record variables into menu items, and assumes that the first element in a record is a linked name and the second is the target URL.

For more information on creating WIDL services and interfaces, see Oracle9i Application Server Wireless Edition Developer's Guide and Section 9.8, "Creating a Master Service Using the Web Integration Adapter" in Chapter 9, "Walkthroughs".

### 2.2.5 XML Editor

The Wireless Edition XML Editor is a text editor that allows you to create, modify, and delete repository objects as XML elements. You should not attempt to use the XML Editor unless you understand the XML structure of the Wireless Edition repository. Wireless Edition does not validate the changes you make with the XML Editor. You should always back up your repository before modifying it with the XML Editor.

#### Figure 2-5 The XML Editor

Text description of the illustration too_xmle.gif

For more information on using the XML Editor, see the Oracle9i Application Server Wireless Edition Developer's Guide.

### 2.2.6 Oracle XML Parser

The Wireless Edition processes XML documents using the Oracle XML Version 2 parser. The parser supports the Document Object Model (DOM) and the Simple API for XML (SAX) interfaces. It supplements the DOM interface with extensions, which are detailed in the Oracle9i Application Server Wireless Edition API Specification.

## 2.3 Personalization

Wireless Edition enables users to personalize their portals from a desktop computer or from a variety of wireless devices.

### 2.3.1 Personalization from Desktop

The Personalization Portal enables users to personalize their portals from a desktop computer by providing default pages for modifying service, folder, job, user, group and other Wireless Edition repository objects. Users can also create their own customized pages, or they can add pages to update customer data objects. The framework and interface are designed to be extensible for including display/action JSP pages specified in the Portal.properties file or in the Wireless Edition repository. For more information, see Chapter 6, "Personalization from Desktops".

#### Figure 2-6 The Personalization Portal

Text description of the illustration too_plog.gif

### 2.3.2 Personalization from Device

Wireless Edition users can also personalize their portals from a variety of wireless devices. For more information, see Chapter 7, "Personalization from a Device".

## 2.4 Oracle Performance Manager

The Oracle Performance Manager enables you to view performance data generated by the Data Gatherer running against the Wireless Edition repository. At runtime, the Wireless Edition servers log performance metrics into the Wireless Edition repository and each Wireless Edition instance logs statistical information. The Data Gatherer then synthesizes this information and displays it as graphs and charts.

#### Figure 2-7 The Oracle Performance Manager

Text description of the illustration too_opm1.gif

### 2.4.1 Accessing the Oracle Performance Manager

To access the Oracle Performance Manger:

1. From Programs in Windows NT, select Oracle for Windows NT.

2. Point to Diagnostics Pack.

3. Select Performance Manager. The Oracle Performance Manager appears.

### 2.4.2 Logging into the Oracle Performance Manager

To log into the Oracle Performance Manager:

1. From the Oracle Enterprise Manager Navigator Tree in the left frame of the screen, select a service. For example, 0817. The Login Screen appears.

2. Select Standalone Login.

#### Figure 2-8 The Login Screen of the Oracle Performance Manager

Text description of the illustration too_opl1.gif

1. In the login screen, enter the database user name and password and the database service ID number (for example, 0817). These are the same as the user name and password for the Wireless Edition System Logger.

2. Enter the host name of the machine where the Data Gatherer is installed (for example, `mymachine.us.oracle.com`). The Data Gatherer must in the same host as the Oracle Instance.

   Note: The Oracle Performance Manger uses SQL*Net to connect to the repository. Therefore, tnsnames.ora must be configured properly.

After you have logged in successfully, a list of statistics that have been collected by the Wireless Edition Data Gatherer cartridge displays in the Navigator Tree under PTG Performance Manager Targets.

#### Figure 2-9 The Navigator Tree

Text description of the illustration too_opnt.gif

Each statistic displays a table chart, or as a default bar chart. The data is grouped by their Wireless Edition Instance IDs.

### 2.4.3 Performance Data Collection Schema

The Oracle Performance Manger logs performance data in the following tables.

Note: The runtime API logs the information into the tables. The collection cartridges retrieve this information and deliver it to the Oracle Enterprise Performance Manager and Capacity Planner.

#### 2.4.3.1 PTG_SERVICE_LOG

Statistical information is logged in this table when responding to a service request with consolidated service information. The request_status is 0 (for 'SUCCESS') by default. In case of an error, the status is set to 'NON-ZERO' and the corresponding error description is given.

Table 2-2 PTG_SERVICE_LOG

Column Name | Type | Comments
--- | --- | ---
Service_id | Number | Notnull
Service_name | varchar2(80) | Notnull
ptg_instance_id | varchar2(240) | Notnull
Final_Service_id | Number | Notnull
Final_Service_Name | varchar2(80) | Notnull
Session_id | Number | Notnull
Service_arguments | varchar2(240) | (can turn on/off)
Bookmark | varchar2(80) |
Service_type | varchar2(80) |
Invocation_hour | Number | Notnull-values 0-23
Invocation_time | Number | Notnull
Response_time | Number | Notnull default 0
request_status | Number | Default 0 for success
Error_description | varchar2(4000) |
Userid | number | Notnull
Username | varchar2(80) | Notnull
External_Userid | number | Notnull
External_Username | varchar2(80) | Notnull
Remote_address | varchar2(240) | Notnull
Host_id | varchar2(240) | Notnull
Transformation_time | number |
Logical_device | varchar2(80) | Notnull

Views provide the pertinent statistical information from the `PTG_SERVICE_LOG` and the `PTG_SESSION_LOG`.

#### 2.4.3.2 PTG_SESSION_LOG

This log is created at login time and updated at logout time or at session expiry.

Table 2-3 PTG_SESSION_LOG

Column Name | Type | Comments
--- | --- | ---
Session_id | Number | Notnull
User_name | varchar2(80) | Notnull
User_id | number | Notnull
Ptg_instance-id | varchar2(240) | Notnull
Remote_address | number | Notnull
Logical_device | varchar2(240) | Notnull
Login_time | date | Notnull
login_hour | number | Notnull-values 0-23
Expiry_Time | date | <updated at logout time>

#### 2.4.3.3 SERVICE_REQUEST_STATS

This view has records within a particular window (i.e., records where the service log timestamp is within a given window).

Table 2-4 SERVICE_REQUEST_STATS

Column Name | Type | Comments
--- | --- | ---
Service_id | Number | Notnull
Service_name | varchar2(80) | Notnull
Service_type | varchar2(80) | Notnull
Ptg_instance-id | varchar2(240) | Notnull
Invocation_count | number | Notnull
Avg_response_time | number | Notnull <Threshold defined on this>
Ptg_instance_id | varchar2(240) |

#### 2.4.3.4 SERVICE_ERROR_STATS

Table 2-5 SERVICE_ERROR_STATS

Column Name | Type | Comments
--- | --- | ---
Service_id | Number | Notnull
Service_name | varchar2(80) | Notnull
Service_type | varchar2(80) | Notnull
Total_Error_count | varchar2(80) | <Threshold defined on this>
Ptg_instance_id | varchar2(240) |

### 2.4.4 Performance Statistics

Oracle Performance Manger console uses the following statistical methods to measure system events. Each of these methods has a corresponding folder in the Oracle Enterprise Manager Navigator tree displayed in the left frame of the Oracle Performance Manager screen. Selecting one of these folders (for example, Connection Duration), displays the statistics as a graph in the right frame of the screen.

#### 2.4.4.1 Session Duration Statistics

Session duration statistics are a class of statistics that present the duration of each session. The data is grouped by instance IDs. The duration of each session is computed using the login time and the expiry time (or the current time if the session is still operational). The Oracle Performance Manager presents session duration statistics either as a pie chart or as a table chart.

#### 2.4.4.2 Session Error Statistics

Session error statistics are a class of statistics that represent the number of errors for each session. For session duration statistics, the data is grouped by instance IDs.

#### 2.4.4.3 Session Service Statistics

Session service statistics is a class of statistics that represent the number of services invoked during each session. The data is grouped by instance IDs.

#### 2.4.4.4 Service Error Statistics

Service error statistics are a class or statistics that represent the number of services which have runtime errors. The service error data is grouped by instance IDs. When the number of service errors exceeds a configurable threshold, the Oracle Performance Manager generates a warning and an error event on the Oracle Enterprise Manager Console. The warning and error threshold values are configurable from the Oracle Enterprise Manager Console.

#### 2.4.4.5 User Service Statistics

User service statistics are a class of statistics that presents the number of services invoked by a specific user across instances. The user service statistics data is grouped by user name and by instance IDs.

#### 2.4.4.6 Service Invocation Statistics

Service invocation statistics are a class of statistics that represent the number of times a particular service was invoked across instances. The service invocation statistics data is grouped by service names and instance IDs.

#### 2.4.4.7 Service Response Time Statistics

The service response time statistics are a class of statistics that present the average response times for each service that was invoked across instances. The service response time statistics are grouped by service names and instance IDs. If the response time exceeds a configurable threshold value, then the Oracle Performance Manager generates a warning or an error even onto the Oracle Enterprise Manager Console.

### 2.4.5 Fault Management

The event framework of the Oracle Enterprise Manager enables asynchronous notification of error information. When an error occurs, the Wireless Edition generates an Oracle Enterprise Manager event at the node where the error occurred and provides the details necessary for fault diagnosis. The Intelligent Agent running on each node picks up these Oracle Enterprise Manager events and forwards them to the Oracle Enterprise Manager Console, where they are immediately displayed. You can configure the console to notify the administrator of an error using pages or email.

### 2.4.6 Configuration Management

The Wireless Edition provides a framework for Wireless Edition discovery on the console. When you discover this node on the Oracle Enterprise Manager Console, you can use the console to both monitor runtime objects and to perform limited performance tuning.

Each Wireless Edition instance starts an RMI server, which listens to commands sent from the RMI client running on the client. The Oracle Enterprise Manager Navigator Tree enables real-time control of thread pool, connection pool, status query, and update.

#### Figure 2-10 Using the Oracle Enterprise Manager Console to Increment Pool Size

Text description of the illustration too_opcp.gif

In the above figure, the Oracle Enterprise Manager Console displays a node with an instance name of PTG1. The controls for PTG1 display under the PTG1 folder. You can modify these controls through a right-click. For example, clicking the Dispatcher Pool control invokes the option to increment the pool size.

For more information on configuration, see the Oracle9i Application Server Wireless Edition Configuration Guide.

| Copyright © 2001 Oracle Corporation. All Rights Reserved. |
Library | Service | Contents | Index