Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Send Us Your Comments

1 Overview for Designing Mobile Applications

• 1.1 Introduction
• 1.2 Oracle Database Lite 10g Application Model and Architecture
  • 1.2.1 Mobile Client Database
    • 1.2.1.1 SQLite Database
    • 1.2.1.2 Oracle Lite Database
  • 1.2.2 Mobile Sync
  • 1.2.3 Mobile Server
  • 1.2.4 Message Generator and Processor (MGP)
  • 1.2.5 Mobile Server Repository
  • 1.2.6 Device Manager
• 1.3 Creating the Publish-Subscribe Model for Mobile Users
  • 1.3.1 Defining the Weight and Conflict Resolution for Publication Items
  • 1.3.2 Behavior and Requirements for Primary Keys, Foreign Keys and Not Null Fields in Publication Items
• 1.4 Mobile Development Kit (MDK)
  • 1.4.1 Mobile SQL (mSQL)
  • 1.4.2 Using the Mobile Database Workbench
  • 1.4.3 Using the Packaging Wizard
• 1.5 Mobile Application Design
  • 1.5.1 Steps for Designing Your Mobile Application
    • 1.5.1.1 Read the Documentation Before Design
    • 1.5.1.2 Gather Mobile Requirements
    • 1.5.1.3 Proof of Concept
    • 1.5.1.4 Prototype
    • 1.5.1.5 Design for Data Subsets
    • 1.5.1.6 Design for Indexing
    • 1.5.1.7 Design for Sequences
    • 1.5.1.8 Design for Synchronization
    • 1.5.1.9 Design for Administration
    • 1.5.1.10 Design for the Language Utilized for Handheld Devices
  • 1.5.2 Application Programming Interfaces
  • 1.5.3 Application Deployment into the Mobile Environment
• 1.6 Supported Languages for Application Development
  • 1.6.1 Native Applications
  • 1.6.2 Standalone Java Applications
  • 1.6.3 Web Applications

2 Synchronization

• 2.1 How Oracle Database Lite Synchronizes
  • 2.1.1 Oracle Lite Mobile Client Database Created on First Synchronization
  • 2.1.2 Using Multiple Databases for Application Data
  • 2.1.3 Deciding on Automatic or Manual Synchronization
  • 2.1.4 Deciding on Synchronization Refresh Option
    • 2.1.4.1 Fast Refresh
    • 2.1.4.2 Complete Refresh
    • 2.1.4.3 Queue-Based Refresh
    • 2.1.4.4 Forced Refresh
  • 2.1.5 Synchronizing to a File With File-Based Sync
  • 2.1.6 How Downloaded Data is Processed on the Mobile Client
  • 2.1.7 How Updates Are Propagated to the Back-End Database
  • 2.1.8 How Modified BLOB Data is Synchronized
• 2.2 Enabling Automatic Synchronization
  • 2.2.1 Enable Automatic Synchronization at the Publication Item Level
  • 2.2.2 Enable/Disable Automatic Synchronization on the Mobile Client
    • 2.2.2.1 Start or Stop Automatic Synchronization
    • 2.2.2.2 Enable or Disable Automatic Synchronization
    • 2.2.2.3 Sync Control APIs to Start or Enable Automatic Synchronization
  • 2.2.3 Define the Rules Under Which the Automatic Synchronization Starts
    • 2.2.3.1 Configure Publication-Level Automatic Synchronization Rules
    • 2.2.3.2 Configure Platform-Level Automatic Synchronization Rules
  • 2.2.4 Setting Data as High Priority in Automatic Synchronization
  • 2.2.5 Enable the Server to Notify the Client to Initiate a Synchronization to Download Data
  • 2.2.6 Notify Application on Completion of Automatic Synchronization Cycle
  • 2.2.7 Request Status for Automatic Synchronization Cycle
• 2.3 What is The Process for Setting Up a User For Synchronization?
  • 2.3.1 Creating a Snapshot Definition Declaratively
    • 2.3.1.1 Manage Snapshots
  • 2.3.2 Creating the Snapshot Definition Programmatically
• 2.4 Creating Publications Using Oracle Database Lite APIs
  • 2.4.1 Defining a Publication With Java Consolidator Manager APIs
    • 2.4.1.1 Create the Mobile Server User
    • 2.4.1.2 Create Publications
    • 2.4.1.3 Create Publication Items
    • 2.4.1.4 Define Publication-Level Automatic Synchronization Rules
    • 2.4.1.5 Data Subsetting: Defining Client Subscription Parameters for Publications
    • 2.4.1.6 Create Publication Item Indexes
    • 2.4.1.7 Adding Publication Items to Publications
    • 2.4.1.8 Creating Client-Side Sequences for the Downloaded Snapshot
    • 2.4.1.9 Subscribing Users to a Publication
    • 2.4.1.10 Instantiate the Subscription
    • 2.4.1.11 Bringing the Data From the Subscription Down to the Client
    • 2.4.1.12 Modifying a Publication Item
    • 2.4.1.13 Callback Customization for DML Operations
    • 2.4.1.14 Restricting Predicate
• 2.5 Client Device Database DDL Operations
• 2.6 Customize the Compose Phase Using MyCompose
  • 2.6.1 Create a Class That Extends MyCompose to Perform the Compose
  • 2.6.2 Implement the Extended MyCompose Methods in the User-Defined Class
    • 2.6.2.1 Implement the needCompose Method
    • 2.6.2.2 Implement the doCompose Method
    • 2.6.2.3 Implement the init Method
    • 2.6.2.4 Implement the destroy Method
  • 2.6.3 Use Get Methods to Retrieve Information You Need in the User-Defined Compose Class
    • 2.6.3.1 Retrieve the Publication Name With the getPublication Method
    • 2.6.3.2 Retrieve the Publication Item Name With the getPublicationItem Method
    • 2.6.3.3 Retrieve the DML Table Name With the getPubItemDMLTableName Method
    • 2.6.3.4 Retrieve the Primary Key With the getPubItemPK Method
    • 2.6.3.5 Retrieve All Base Tables With the getBaseTables Method
    • 2.6.3.6 Retrieve the Primary Key With the getBaseTablePK Method
    • 2.6.3.7 Discover If Base Table Has Changed With the baseTableDirty Method
    • 2.6.3.8 Retrieve the Name for DML Log Table With the getBaseTableDMLLogName Method
    • 2.6.3.9 Retrieve View of the Map Table With the getMapView Method
  • 2.6.4 Register the User-Defined Class With the Publication Item
• 2.7 Customize What Occurs Before and After Synchronization Phases
  • 2.7.1 Customize What Occurs Before and After Every Phase of Each Synchronization
    • 2.7.1.1 NullSync
    • 2.7.1.2 BeforeProcessApply
    • 2.7.1.3 AfterProcessApply
    • 2.7.1.4 BeforeProcessCompose
    • 2.7.1.5 AfterProcessCompose
    • 2.7.1.6 BeforeProcessLogs
    • 2.7.1.7 AfterProcessLogs
    • 2.7.1.8 BeforeClientCompose
    • 2.7.1.9 AfterClientCompose
    • 2.7.1.10 BeforeSyncMapCleanup
    • 2.7.1.11 AfterSyncMapCleanup
    • 2.7.1.12 Example Using the Customize Package
    • 2.7.1.13 Error Handling For CUSTOMIZE Package
  • 2.7.2 Customize What Occurs Before and After Compose/Apply Phases for a Single Publication Item
• 2.8 Initiating Client Synchronization With Synchronization APIs
  • 2.8.1 Starting Synchronization Upload and Download Phases With C or C++ Applications
  • 2.8.2 Starting Synchronization Upload and Download Phases With Java Applications
  • 2.8.3 Starting Synchronization Upload and Download Phases With the ADO.NET Provider
• 2.9 Understanding Your Refresh Options
  • 2.9.1 Fast Refresh
  • 2.9.2 Complete Refresh for Views
  • 2.9.3 Queue-Based Refresh
  • 2.9.4 Forced Refresh
• 2.10 Synchronizing With Database Constraints
  • 2.10.1 Synchronization And Database Constraints
  • 2.10.2 Primary Key is Unique
  • 2.10.3 Foreign Key Constraints
    • 2.10.3.1 Set Update Order for Tables With Weights
    • 2.10.3.2 Defer Constraint Checking Until After All Transactions Are Applied
  • 2.10.4 Unique Key Constraint
  • 2.10.5 Not Null Constraint
  • 2.10.6 Generating Constraints on the Mobile Client
    • 2.10.6.1 The assignWeights Method
• 2.11 Resolving Conflicts with Winning Rules
  • 2.11.1 Resolving Errors and Conflicts on the Mobile Server Using the Error Queue
  • 2.11.2 Viewing Client-Side Synchronization Conflicts from Automatic Synchronization
  • 2.11.3 Customizing Synchronization Conflict Resolution Outcomes
• 2.12 Using the Sync Discovery API to Retrieve Statistics
  • 2.12.1 getDownloadInfo Method
  • 2.12.2 DownloadInfo Class Access Methods
  • 2.12.3 PublicationSize Class
• 2.13 Customizing Synchronization With Your Own Queues
  • 2.13.1 Customizing Apply/Compose Phase of Synchronization with a Queue-Based Publication Item
    • 2.13.1.1 Queue Creation
    • 2.13.1.2 Queue-Based PL/SQL Callouts
    • 2.13.1.3 Create a Publication Item as a Queue
    • 2.13.1.4 Register the PL/SQL Package Outside the Repository
  • 2.13.2 Creating Data Collection Queues for Uploading Client Collected Data
    • 2.13.2.1 Creating a Data Collection Queue
  • 2.13.3 Selecting How/When to Notify Clients of Composed Data
• 2.14 Synchronization Performance
• 2.15 Troubleshooting Synchronization Errors
  • 2.15.1 Foreign Key Constraints in Updatable Publication Items
    • 2.15.1.1 Foreign Key Constraint Violation Example
    • 2.15.1.2 Avoiding Constraint Violations with Table Weights
    • 2.15.1.3 Avoiding Constraint Violations with BeforeApply and After Apply

3 APIs for Client and Database Administration

• 3.1 Deleting a Client Device
• 3.2 Register a Remote Oracle Database for Application Data
  • 3.2.1 Set up a Remote Application Repository With the APPREPWIZARD Script
  • 3.2.2 Register or Deregister a Remote Oracle Database for Application Data
  • 3.2.3 Create Publication, Publication Item, Hints and Virtual Primary Keys on a Remote Database
  • 3.2.4 Using Callbacks on Remote Databases
    • 3.2.4.1 Customize Callbacks on the Remote Database
    • 3.2.4.2 Publication Item Level Callbacks for the MGP Apply/Compose Phases
    • 3.2.4.3 Customizing the Apply/Compose Phase for a Queue-Based Publication Item on a Remote Database
• 3.3 Create a Synonym for Remote Database Link Support For a Publication Item
  • 3.3.1 Publishing Synonyms for the Remote Object Using CreatePublicationItem
  • 3.3.2 Creating or Removing a Dependency Hint
• 3.4 Parent Tables Needed for Updateable Views
  • 3.4.1 Creating a Parent Hint
  • 3.4.2 INSTEAD OF Triggers
• 3.5 Manipulating Application Tables
  • 3.5.1 Creating Secondary Indexes on Client Device
  • 3.5.2 Virtual Primary Key
• 3.6 Facilitating Schema Evolution
  • 3.6.1 Schema Evolution Involving a Primary Key
• 3.7 Set DBA or Operational Privileges for the Mobile Server
• 3.8 Datatype Conversion Between the Oracle Server and the Oracle Lite Database

4 Invoking Synchronization in Applications With the Mobile Sync APIs

• 4.1 Synchronization APIs For C or C++ Applications
  • 4.1.1 Overview of C/C++ Synchronization API
  • 4.1.2 Initializing the Environment With ocSessionInit
  • 4.1.3 Managing the C/C++ Data Structures
    • 4.1.3.1 ocEnv Data Structure
    • 4.1.3.2 ocTransportEnv Data Structure
  • 4.1.4 Retrieving Publication Information With ocGetPublication
  • 4.1.5 Managing User Settings With ocSaveUserInfo
  • 4.1.6 Manage What Tables Are Synchronized With ocSetTableSyncFlag
  • 4.1.7 Configure Proxy Information
  • 4.1.8 Start the Synchronization With the ocDoSynchronize Method
    • 4.1.8.1 See Progress of Synchronization with Progress Listening
  • 4.1.9 Clear the Synchronization Environment Using ocSessionTerm
  • 4.1.10 Retrieve Synchronization Error Message with ocGetLastError
  • 4.1.11 Enable File-Based Synchronization through C or C++ APIs
• 4.2 Synchronization API for Java Applications
  • 4.2.1 Overview
  • 4.2.2 Sync Class
  • 4.2.3 SyncException Class
  • 4.2.4 SyncOption Class
  • 4.2.5 Java Interface SyncParam Settings
  • 4.2.6 Java Interface TransportParam Parameters
  • 4.2.7 SyncProgressListener Service
  • 4.2.8 Manage What Tables Are Synchronized With Selective Sync
  • 4.2.9 Enable File-Based Synchronization through Java APIs
• 4.3 Synchronization API for Java Applications on SQLite Mobile Clients
  • 4.3.1 Overview
  • 4.3.2 OSESession Class
  • 4.3.3 OSEProgressListener Interface
  • 4.3.4 Enable Selective Synchronization
  • 4.3.5 OSEException Class
• 4.4 Synchronization API for C#
  • 4.4.1 Use the OracleSync Class for Synchronization
  • 4.4.2 Using the OracleEngine to Synchronize
    • 4.4.2.1 Launch the MSYNC Tool for User Input
    • 4.4.2.2 Set the Environment and Synchronize With the OracleEngine
  • 4.4.3 Exception Handling and Reading Log Files
  • 4.4.4 Monitor Synchronization Progress With the SyncEventHandler
    • 4.4.4.1 Using the SyncEventArgs Object
    • 4.4.4.2 Executing the SetEventHandler Method
    • 4.4.4.3 Creating the SyncEventHandler Object
  • 4.4.5 Manage What Tables Are Synchronized With Selective Sync
  • 4.4.6 Enable File-Based Synchronization through C# APIs
• 4.5 mSync/OCAPIs/mSyncCom

5 Application Development

• 5.1 Data Access APIs
  • 5.1.1 Data Source Name
  • 5.1.2 JDBC
  • 5.1.3 ODBC
  • 5.1.4 ADO.NET
    • 5.1.4.1 Data Synchronization With the OracleSync or Oracle Engine Classes
    • 5.1.4.2 Creating a Database for Testing
    • 5.1.4.3 Developing an ADO.NET Application on WinCE
• 5.2 Supported Native APIs for Oracle Database Lite
• 5.3 Developing Java Applications
  • 5.3.1 Java Support for Applications
    • 5.3.1.1 JDBC Drivers
  • 5.3.2 Oracle Database Lite Java Development Environment
    • 5.3.2.1 Setting Variables for the JDK
  • 5.3.3 Java Development Tools
• 5.4 Using Stored Procedures in Oracle Database Lite
  • 5.4.1 Load and Define Java Stored Procedures
    • 5.4.1.1 Load and Define Java Stored Procedures on the Mobile Client in an Oracle Lite Database
    • 5.4.1.2 Load and Define Java Stored Procedures in an Enterprise Mobile Server Environment
  • 5.4.2 Load and Define C, C++, or C# Stored Procedures
    • 5.4.2.1 Defining the C, C++, or C# Stored Procedure
    • 5.4.2.2 Loading the C, C++ or C# Stored Procedure to the Oracle Lite Database
• 5.5 Developing Mobile Web-to-Go Applications
  • 5.5.1 Choose the Type of Web-to-Go Mobile Client to Use
  • 5.5.2 Developing and Testing the Application
    • 5.5.2.1 Building Web-to-Go Applications
    • 5.5.2.2 Database Connections
    • 5.5.2.3 Application Roles
    • 5.5.2.4 Developing Java Server Pages
    • 5.5.2.5 Developing Java Servlets for Web-to-Go
    • 5.5.2.6 Using Web-to-Go Applets
    • 5.5.2.7 Developing Applets to use JDBC Communication
    • 5.5.2.8 Developing Applet Servlet Communication
    • 5.5.2.9 Debugging Web-to-Go Applications
    • 5.5.2.10 Customizing the Workspace Application
    • 5.5.2.11 Using the Mobile Server Admin API

6 Using Mobile Database Workbench to Create Publications

• 6.1 Use MDW to Create Publications
  • 6.1.1 Set Access Privileges to SYSTEM Tables for Your Application Schema
  • 6.1.2 Launch MDW
• 6.2 Create a Project
• 6.3 Use the Quick Wizard to Create Your Publication
• 6.4 Create a Publication Item
  • 6.4.1 Create SQL Statement for Publication Item
  • 6.4.2 Create a Dependency Hint
  • 6.4.3 Specify Parent Table and Primary Key Hints
• 6.5 Define the Rules Under Which the Automatic Synchronization Starts
  • 6.5.1 Configure Publication-Level Automatic Synchronization Rules
  • 6.5.2 Configure Platform-Level Automatic Synchronization Rules
    • 6.5.2.1 Define System Event Rules for the Platform
    • 6.5.2.2 Define Automatic Synchronization Conditions for the Platform
• 6.6 Create a Sequence
  • 6.6.1 Configuring Sequences in MDW
  • 6.6.2 Configuration Scenarios for Sequence Generation
  • 6.6.3 Example of a Sequence
  • 6.6.4 Example of a Client and Server Sharing a Sequence
• 6.7 Create and Load a Script Into The Project
  • 6.7.1 Writing SQL Scripts
  • 6.7.2 Test SQL Scripts
    • 6.7.2.1 Connect to the Database
    • 6.7.2.2 Load and Execute SQL Scripts
  • 6.7.3 Load the Script Into the Project
• 6.8 Load a Resource Into the Project
• 6.9 Create a Publication
  • 6.9.1 General Tab Configures Publication Name
  • 6.9.2 Publication Item Tab Associates Publication Items With the Publication
    • 6.9.2.1 Associating a Publication Item to this Publication
  • 6.9.3 Sequence Tab Associates Existing Sequences With the Publication
  • 6.9.4 Script Tab Associates Existing Scripts With the Publication
  • 6.9.5 Resource Tab Associates Existing Resources With the Publication
  • 6.9.6 Event Tab Configures Automatic Synchronization Rules for this Publication
• 6.10 Import Existing Publications and Objects from Repository
  • 6.10.1 Import Existing Publication from Repository
  • 6.10.2 Import Existing Publication Item From the Repository
  • 6.10.3 Import Existing Sequence From the Repository
  • 6.10.4 Import Existing Resource From the Repository
  • 6.10.5 Import an Existing Script From the Repository
• 6.11 Create a Virtual Primary Key
• 6.12 Test a Publication by Performing a Synchronization
• 6.13 Deploy the Publications in the Project to the Repository

7 Using the Packaging Wizard

• 7.1 Using the Packaging Wizard
  • 7.1.1 Starting the Packaging Wizard
  • 7.1.2 Specifying New Application Definition Details
  • 7.1.3 Listing Application Files
    • 7.1.3.1 Compile JSP (For Web-to-Go Applications Only)
    • 7.1.3.2 Filters
  • 7.1.4 Adding Servlets (For OC4J and Web-to-Go Applications Only)
  • 7.1.5 Entering Database Information
  • 7.1.6 Defining Application Roles
  • 7.1.7 Defining Snapshots for Replication
    • 7.1.7.1 Creating New Snapshots
    • 7.1.7.2 Creating Indexes for Snapshots
    • 7.1.7.3 Importing Snapshots
    • 7.1.7.4 Editing Snapshots
  • 7.1.8 Defining Sequences for Replication
    • 7.1.8.1 Importing Sequences
  • 7.1.9 Defining Application DDLs
    • 7.1.9.1 Importing Views and Index Definitions
  • 7.1.10 Editing Application Definition
  • 7.1.11 Troubleshooting
• 7.2 Packaging Wizard Synchronization Support

8 Create and Manage Jobs with APIs

• 8.1 Managing Scheduled Jobs Using ConsolidatorManager APIs
• 8.2 Start a Standalone Job Engine In Separate JVM
• 8.3 Using the ConsolidatorManager APIs to Create Jobs

9 Using Symbian Devices

• 9.1 Installing Oracle Database Lite on Symbian Devices
  • 9.1.1 Supported Platforms and Environment
    • 9.1.1.1 Supported Devices for Symbian Platform
    • 9.1.1.2 Symbian Operating System Support
    • 9.1.1.3 Supported Development Environments for the Symbian Platform
  • 9.1.2 Prerequisites for Installation
  • 9.1.3 Installing Oracle Database Lite
    • 9.1.3.1 Installing Oracle Database Lite for Symbian on the Development PC
    • 9.1.3.2 Installing Oracle Database Lite on the Symbian Device
• 9.2 Developing Applications for Symbian Devices to Use Oracle Database Lite
• 9.3 Using CSQL, ODBC or JDBC to Access Oracle Database Lite
  • 9.3.1 Using CSQL to Connect to the Database on Symbian
  • 9.3.2 Using ODBC to Connect to the Database on Symbian
  • 9.3.3 Using JDBC to Connect to the Database on Symbian
• 9.4 Invoking Synchronization from Applications on Symbian Devices
  • 9.4.1 Using MSync UI to Invoke Synchronization
  • 9.4.2 Invoking Synchronization through Programmatic APIs
    • 9.4.2.1 Prepare Your Application for Synchronization
    • 9.4.2.2 How to Use the Synchronization API for Symbian Devices
• 9.5 Use the Utility Tools on Symbian Devices
  • 9.5.1 Using Utility Tools on Symbian 7 and 8
  • 9.5.2 Using Utility Tools on Symbian 9

10 Customizing Oracle Database Lite Security

• 10.1 Providing Your Own Authentication Mechanism for Authenticating Users for the Mobile Server
  • 10.1.1 Implementing Your External Authenticator
    • 10.1.1.1 Initialization for the External Authenticator
    • 10.1.1.2 Destruction of the External Authenticator
    • 10.1.1.3 The Authentication Method for the External Authenticator
    • 10.1.1.4 The User Instantiation Method for the External Authenticator
    • 10.1.1.5 Retrieve the User Name or the User Global Unique ID
    • 10.1.1.6 Log Off User
    • 10.1.1.7 Change User Password
  • 10.1.2 Registering External Authenticator
  • 10.1.3 User Initialization Scripts

11 Tutorial for Building Mobile Web-to-Go Applications

• 11.1 Develop the Application
  • 11.1.1 Create Database Objects in the Oracle Server
    • 11.1.1.1 Create the Table Owner Account
    • 11.1.1.2 Create the Database Objects in the Oracle Database
  • 11.1.2 Compile the Application
• 11.2 Create Publication for Application
  • 11.2.1 Create a Project
  • 11.2.2 Create Publication Items
    • 11.2.2.1 Create Publication Item
    • 11.2.2.2 Create Sequence
    • 11.2.2.3 Create Script
  • 11.2.3 Create Publication
• 11.3 Package the Application Using the Packaging Wizard
• 11.4 Administer the Application
  • 11.4.1 Start the Mobile Server and the Mobile Manager
  • 11.4.2 Using the Mobile Manager to Create a New User
  • 11.4.3 Setting Application Properties
  • 11.4.4 Granting User Access to the Application
  • 11.4.5 Defining Snapshot Template Values for the User
• 11.5 Execute the Application on the Mobile Client for Web-to-Go
  • 11.5.1 Install the Mobile Client for Web-to-Go
  • 11.5.2 Log into the Mobile Client for Web-to-Go
  • 11.5.3 Manually Synchronize the Mobile Client for Web-to-Go

12 Tutorial for Building Mobile Web Applications Using ADF/BC4J

• 12.1 Overview
  • 12.1.1 Before You Start
• 12.2 Creating a Database Connection
  • 12.2.1 Creating a Database Connection to Oracle Database
  • 12.2.2 Specify The Connection To The Oracle Lite Database
• 12.3 Develop the ADF/BC4J Application
  • 12.3.1 Build the Data Model with ADF Business Components
    • 12.3.1.1 Create a New Application and Projects
    • 12.3.1.2 Create Business Components
  • 12.3.2 Customize the Business Components Views
  • 12.3.3 Create a Master-Detail JavaServer Faces Page
  • 12.3.4 Run the JSF Page
  • 12.3.5 Configure the ADF/BC4J Application for the Oracle Database Lite Environment
  • 12.3.6 Deploy the Application as WAR file
• 12.4 Package the ADF/BC4J Application
  • 12.4.1 Include the ADF Runtime Libraries with the ADF/BC4J Application
  • 12.4.2 Package the Application from the Packaging Wizard
• 12.5 Publish and Configure the ADF/BC4J Application from the Mobile Manager
• 12.6 Test the ADF/BC4J Application
• 12.7 Run the ADF/BC4J Application on the Mobile Client for Oracle Lite WEB OC4J

13 Tutorial for Building Mobile Applications for Win32

• 13.1 Plan the Mobile Application Demo for Win32
• 13.2 Description of Tasks for Win32 Demo
  • 13.2.1 Create TASK Table on the Server Database
  • 13.2.2 Create Publication for Application
    • 13.2.2.1 Create a Project
    • 13.2.2.2 Create Publication Item
    • 13.2.2.3 Create Publication
  • 13.2.3 Package the Application Using the Packaging Wizard
• 13.3 Administer the Application
  • 13.3.1 Start the Mobile Server and the Mobile Manager
  • 13.3.2 Using the Mobile Manager to Create New Users for the Task Application
  • 13.3.3 Setting Application Properties
  • 13.3.4 Granting User Access to the Application
  • 13.3.5 Defining Snapshot Template Values for the User
• 13.4 Execute the Application on the Mobile Client for Web-to-Go
  • 13.4.1 Install the Mobile Client on the Win32 Device
  • 13.4.2 Browse the TASK Snapshot and Update a Row
  • 13.4.3 Develop your Mobile Field Service Application Using Oracle Database Lite
  • 13.4.4 Republish the Application with the Application Program

14 Tutorial for Building Mobile Applications for Windows CE

• 14.1 Overview of the WinCE Sample Application
  • 14.1.1 Before You Start
    • 14.1.1.1 Application Development Computer Requirements
    • 14.1.1.2 Client Device Requirements
• 14.2 Develop the Application
  • 14.2.1 Create Database Objects in the Oracle Server
    • 14.2.1.1 The WinCE Transport Application Database Objects
  • 14.2.2 Write the Application Code
    • 14.2.2.1 Transport Module (Transport.vb)
    • 14.2.2.2 Main Form (frmMain.vb)
    • 14.2.2.3 View Packages (frmView.vb)
    • 14.2.2.4 Create Package (frmNew.vb)
  • 14.2.3 Compile the Application
    • 14.2.3.1 Create CAB Files
    • 14.2.3.2 Install the Application from the CAB File
• 14.3 Create Publication for Application
  • 14.3.1 Create a Project
  • 14.3.2 Create Publication Items
    • 14.3.2.1 Create Packages Publication Item
    • 14.3.2.2 Create Routes Publication Item
    • 14.3.2.3 Create Trucks Publication Item
  • 14.3.3 Create Publication
• 14.4 Package and Publish the Application
  • 14.4.1 Define the Application Using the Packaging Wizard
    • 14.4.1.1 Create a New Application
  • 14.4.2 Publish the Application
• 14.5 Administer the Application
  • 14.5.1 Start the Mobile Server
  • 14.5.2 Launch the Mobile Manager
  • 14.5.3 Create a New User
  • 14.5.4 Set the Application Properties
  • 14.5.5 Grant User Access to the Application
• 14.6 Run the Application on the Windows Mobile/Pocket PC Device
  • 14.6.1 Install the Oracle Database Lite Mobile client for Pocket PC
  • 14.6.2 Install and Synchronize the Transport Application and Data

Index