Skip Headers

Oracle9i Lite Developer's Guide for Web-to-Go
Release 5.0.2
Part No. A97671-01
Go To Index
Index

Next

Contents

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

1 Introduction

1.1 What Is Web-to-Go?
1.2 Concepts and Terminology
1.3 Developing Web-to-Go Applications
1.4 The Web-to-Go Tutorial

2 Concepts

2.1 Web-to-Go
2.2 The Web-to-Go Environment
2.2.1 Web-to-Go Applications
2.2.2 Mobile Client for Web-to-Go
2.2.2.1 Sites
2.2.3 Mobile Server
2.2.4 Database Server
2.2.5 Workspace
2.2.6 Managing Web-to-Go
2.3 Synchronization Concepts
2.3.1 Data Replication
2.3.2 Offline Mode
2.3.3 Online Mode
2.3.4 Synchronizing the Data and Applications
2.3.5 Client Synchronization Modes
2.4 Web-to-Go Development
2.4.1 The Mobile Development Kit for Web-to-Go
2.4.1.1 Connection Pooling
2.4.1.2 The Java-based HTML Library
2.4.2 The Packaging Wizard
2.5 Access Control Management
2.5.1 The Mobile Server Control Center

3 Developing Web-to-Go Applications

3.1 Overview
3.2 Building Web-to-Go Applications
3.2.1 Static Components
3.2.2 Dynamic Components
3.2.2.1 Java Applets
3.2.2.2 Java Servlets
3.2.2.3 JavaServer Pages
3.2.3 Database Components
3.2.3.1 Snapshots
3.2.3.2 Sequences
3.2.3.3 DDLs
3.2.3.4 Database Component Access
3.2.4 Database Connections
3.3 Application Roles
3.4 Developing JavaServer Pages
3.4.1 The Mobile Client Web Server
3.4.2 Mobile Server or Mobile Client for Web-to-Go
3.5 Developing Java Servlets for Web-to-Go
3.5.1 Limitations
3.5.2 Accessing Applications on the Mobile Development Kit for Web-to-Go
3.5.3 Creating a Servlet
3.5.3.1 Packages
3.5.3.2 Web-to-Go User Context
3.5.3.3 Database Connectivity in the Java Code
3.5.3.4 Accessing the Mobile Server Repository
3.5.4 Running a Servlet
3.5.4.1 Registering Servlets Using wtgpack.exe
3.5.4.2 The webtogo.ora File
3.5.4.3 Using wtgdebug.exe
3.5.4.4 Using WebToGoServer.class
3.5.4.5 Controlling Web Server Properties
3.5.4.6 Registering Servlets
3.5.4.7 Registering MIME Types
3.5.4.8 Registering Name/Value Pairs
3.5.5 Debugging a Servlet
3.5.6 Accessing the Schema Directly in Oracle Lite
3.6 Using Web-to-Go Applets
3.6.1 Creating the Web-to-Go Applet
3.6.2 Creating the HTML Page for the Applet
3.6.2.1 Static HTML Page
3.6.2.2 HTML page generated from a Servlet
3.7 Developing Applet-JDBC Communication
3.7.1 getConnection()
3.7.2 Design Issue
3.8 Developing Applet-Servlet Communication
3.8.1 Creating the Web-to-Go Servlet
3.8.1.1 getResultObject()
3.8.1.2 setSessionId()
3.8.1.3 showDocument()
3.9 Debugging Web-to-Go Applications
3.9.1 Running Sample 1 by Using Oracle9i JDeveloper
3.9.1.1 Creating a Debug Project
3.9.1.2 Creating a Library
3.9.1.3 Adding Files to the Project
3.9.1.4 Running and Debugging
3.9.1.5 Troubleshooting
3.10 Customizing the Workspace Application
3.10.1 Webtogo.ora Parameters
3.10.2 Sample Workspace
3.11 Using the Mobile Server Admin API

4 The Web-to-Go Tutorial

4.1 Overview
4.1.1 Before You Start
4.1.1.1 Development Computer Requirements
4.1.1.2 Client Computer Requirements
4.2 Developing the Application
4.2.1 Step 1: Creating Database Objects in Oracle Lite
4.2.1.1 The To Do List Application Database Objects
4.2.1.2 Required Action
4.2.2 Step 2: Writing the Application Code
4.2.2.1 The JavaServer Page
4.2.2.2 The JavaBean
4.2.2.3 The Java Servlet
4.2.2.4 Required Action
4.2.3 Step 3: Compiling the Application
4.2.3.1 Required Action
4.2.4 Step 4: Defining the Application and Registering the Servlet
4.2.4.1 The Packaging Wizard
4.2.4.2 Required Action
4.2.5 Step 5: Running the Application
4.2.5.1 The Mobile Development Kit for Web-to-Go Web Server
4.2.5.2 Required Action
4.3 Packaging the Application
4.3.1 Step 1: Defining the Application Using the Packaging Wizard
4.3.1.1 The Packaging Wizard
4.3.1.2 Required Action
4.3.2 Step 2: Defining the Application Connection to the Oracle Database
4.3.2.1 Required Action
4.3.3 Step 3: Defining the Snapshot
4.3.3.1 The Snapshots Panel
4.3.3.2 Required Action
4.3.4 Step 4: Defining the Sequences
4.3.5 Step 5: Creating SQL Files for the Application
4.3.5.1 Required Action
4.3.6 Step 6: Package the Application
4.3.6.1 Required Action
4.4 Publishing the Application
4.4.1 Step1: Create the Table Owner Account
4.4.2 Step 2: Create the Database Objects in Oracle Database
4.4.2.1 Required Action
4.4.3 Step 3: Start the Mobile Server
4.4.3.1 Required Action
4.4.4 Step 4: Log on to the Mobile Server and Start the Mobile Server Control Center
4.4.4.1 Requied Action
4.4.5 Step 5: Upload the Application
4.4.5.1 Required Action
4.5 Administering the Application
4.5.1 Step 1: Starting the Mobile Server Control Center
4.5.1.1 Required Action
4.5.2 Step 2: Using the Control Center to Create a New User
4.5.2.1 Required Action
4.5.3 Step 3: Setting the Application Properties
4.5.3.1 Required Action
4.5.4 Step 4: Granting User Access to the Application
4.5.4.1 Required Action
4.5.5 Step 5: Defining Snapshot Template Values for the User
4.5.5.1 Required Action
4.5.6 Step 6: Starting the Message Generator and Processor (MGP)
4.5.6.1 Required Action
4.6 Running the Application on the Mobile Client for Web-to-Go
4.6.1 Step 1: Installing the Mobile Client for Web-to-Go
4.6.1.1 Required Action
4.6.2 Step 2: Logging into the Mobile Client for Web-to-Go
4.6.2.1 Required Action
4.6.3 Step 3: Synchronizing the Mobile Client for Web-to-Go
4.6.3.1 Required Action

5 Defining Web-to-Go Applications

5.1 Overview
5.2 Using Sequence Support for Disconnected Clients
5.2.1 Web-to-Go Sequences
5.2.2 The Window Sequence
5.2.2.1 Window Sequence Example
5.2.2.2 Creating the Window Sequence
5.2.2.3 Defining Window Sequences for Online Mode
5.3 Using the Packaging Wizard
5.3.1 Starting the Packaging Wizard
5.3.2 Selecting a Platform
5.3.3 Starting the Packaging Wizard in Development Mode
5.3.4 Naming New Applications
5.3.4.1 Locating Platform Files in the Local Application Directory
5.3.5 Listing Application Files
5.3.5.1 Compile JSP
5.3.5.2 Sorting
5.3.5.3 Filters
5.3.6 Adding Servlets
5.3.7 Entering Database Information
5.3.8 Defining Application Roles
5.3.9 Defining Snapshots For Replication
5.3.9.1 Creating New Snapshots
5.3.9.2 Creating Indexes for Snapshots
5.3.9.3 Importing Snapshots
5.3.9.4 Editing Snapshots
5.3.10 Defining Sequences For Replication
5.3.10.1 Importing Sequences
5.3.11 Defining Application DDLs
5.3.11.1 Importing Views and Indexes Definitions
5.3.12 Defining Name/Value Pairs in the Registry
5.3.13 Completing the Application
5.3.13.1 The XML File
5.3.13.2 Creating Files
5.3.13.3 Publishing the Application
5.3.13.4 Restarting the Packaging Wizard
5.3.14 Editing Applications
5.4 Support for the web.xml Format
5.4.1 Location of the web.xml File
5.4.2 Supported Tag in web.xml

6 BC4J Tutorial

6.1 Overview
6.1.1 Before You Start
6.1.1.1 Development Computer Requirements
6.2 Developing the Application
6.2.1 Creating the Database Connection
6.2.2 Creating the BC4J Component
6.2.3 Configuring the BC4J Component to Use the WTGJdbc Connection
6.2.4 Building and Deploying the BC4J Component as a Simple Archive
6.2.5 Writing the JSP Application to Access the BC4J Component
6.2.6 Deploying the JSP Application as a Simple Archive
6.3 Packaging the JSP Application
6.4 Publishing and Configuring the JSP Application from the Control Center
6.5 Testing the BC4J Application
6.6 Running the BC4J Application on the Mobile Client for Web-To-Go
6.7 Deploying the Sample Application

A Web-to-Go Sample Applications

A.1 Introduction
A.1.1 The Mobile Server
A.1.2 The Mobile Development Kit for Web-to-Go
A.1.3 Accessing Sample Programs from the Mobile Development Kit for Web-to-Go
A.1.4 Accessing Sample Programs from the Mobile Server
A.2 Sample 1 - Hello World
A.2.1 Source Code Location
A.2.2 Application Files
A.3 Sample 3 - Recording Tracker
A.3.1 Using Sample 3
A.3.2 Sample 3 Database Tables
A.3.3 Sample 3 Servlets
A.3.4 Sample 3 Resource Bundle
A.3.5 Source Code Location
A.3.6 Application Files
A.4 Sample 4 - Hello Applet
A.4.1 Sample 4 Servlets
A.4.2 Source Code Location
A.4.3 Application Files
A.5 Sample 6 - Image Gallery
A.5.1 Source Code Location
A.5.2 Application Files
A.6 Sample 7 - Employee Data Applet
A.6.1 Source Code Location
A.6.2 Application Files

B Web-to-Go Java Packages

B.1 Using the oracle.html Package
B.1.1 Creating an HtmlPage Object
B.1.2 Adding Tags to the <HEAD> Area
B.1.3 Adding Content to the <BODY> Tag
B.1.4 Adding Tags to the <BODY> Section of the HTML Page
B.1.5 Examples of Generating HTML Using Classes
B.1.5.1 Simple Unformatted Text
B.1.5.2 Headings and Text Attributes
B.1.5.3 Forms
B.1.5.4 Lists
B.1.5.5 Tables
B.1.6 Mapping HTML Elements to Java Classes
B.1.6.1 HEAD Elements
B.1.6.2 Body Elements
B.1.6.3 List Elements
B.1.6.4 Table Elements
B.1.6.5 Text-Level Elements
B.1.6.6 Form Elements
B.1.6.7 Other Elements
B.1.7 Class Hierarchy in the oracle.html Package
B.1.8 The IHtmlItem Interface
B.1.9 The Item Abstract Class
B.1.10 The CompoundItem and Container Classes
B.1.11 Constructing HTML Pages and Objects
B.1.12 Extending the oracle.html Package
B.1.12.1 Using Dynamic Content
B.2 Using the oracle.lite.web.html Package
B.2.1 Processing HTML Templates with the TemplateParser Class
B.2.1.1 Displaying Database Data Using DBTable
B.2.2 emp.html
B.2.2.1 Processing Data Using ProcessForm
B.2.3 Deleting Records Using the DeleteRecords Servlet
B.2.4 Creating and Processing Master/Detail Forms

Glossary

Index


Next
Oracle Logo
Copyright © 2002 Oracle Corporation

All rights reserved
Go To Index
Index