Oracle9i Lite Developer's Guide for EPOC
Release 5.0

Part Number A90106-01
Go To Index
Index

Go to next page

Contents

Title and Copyright Information

List of Figures

List of Tables

Send Us Your Comments

Preface

1 Overview

Introduction
Oracle Lite Database
Mobile Sync
Mobile SQL
Samples
Mobile Server
Environment
Database Interface
JDBC
ODBC
Oracle Lite OKAPI
Development Process Using the API
Development Environment
Publication Item Creation
Creating a Publication Item Declaratively
Creating the Publication Item Programmatically
Creating the Database Manually
Configuring Synchronization
Replication with the Emulator
Application Development
Testing on the Device
Application Packaging

2 Configuring the Development System

General Requirements
Configuring the Development Environment
EPOC Development Environment
Requirements
Directory Structure
Installing and Configuring the Development Environment
Setting Up the EPOC SDK
Installing PsiWin

3 Synchronization

Overview
Publication and Subscription
Client Device Database DDL Operations
Database Support
Binding User-Defined PL/SQL Packages
Flexible Naming
Fast Refresh and Update Operation for Views
Updatable Parent Tables
Using Parent Table Hints and INSTEAD OF Triggers
Fast Refresh for Views
Complete Refresh for Views
Foreign Key Constraints in Updatable Publication Items
Foreign Key Constraint Violation Example
Avoiding Constraint Violations with BeforeApply and After Apply
Avoiding Constraint Violations with Table Weights
Replication Errors and Conflicts
Versioning
Winning Rules
Mapping Datatypes Between the Oracle Server and Devices
Oracle Lite Datatypes
The Publish and Subscribe Model
Connecting to Mobile Server
User Functions of the Mobile Server Admin API
Create User
Change Password
Drop User
Creating Publications
Defining Publication Items
Data Subsetting
Creating Publication Items
Null Sync Callout
Retrieving Publication Item Names
Creating Publication Item Indexes
Define Client Indexes
Adding Publication Items to the Publication
Read-only Publication Items
Defining Conflict Rules
Using Table Weight
Creating Sequences
Subscribing Users to a Publication
Partitioning Sequences for Client Devices
Defining Client Subscription Parameters to Publications
Instantiating the Subscription
Schema Evolution Using Alter Publication Item
Alter Publication Item
Publish and Subscribe Method Specialized Functions
Callback Customization Using Compose and Apply
Defining Customized DML Operations
Virtual Primary Key
Create Virtual Primary Key Column
Drop Virtual Primary Key Column
Restricting Predicate
Resolving Conflicts Using the Error Queue
Execute Transaction
Purge Transaction
Setting Up the EPOC Emulator
Installing Mobile Sync on the EPOC Emulator
Configuring Transport for the Emulator
Testing Replication on the Emulator
Setting Up the Mobile Client on the Device
Installing Oracle Lite on the EPOC Device
Installing Mobile SQL on the EPOC Device
Configuring Transport on a Device
Configuring Windows NT RAS for TCP/IP Communications
Create a RAS User Account for the Device
Configuring Transport on EPOC Devices
Configuring the Client
Mobile Server System Catalog Views

4 Sample Orders Application

Overview
Sample Orders Application Files
Installing the Sample Application on the Device
Using the Sample Application for the EPOC Platform
The Main Form
The Order Form
Changing the Sort Order
The Order Item Form

5 Database Programming for EPOC

Development Interfaces
JDBC
ODBC
Oracle Lite Object Kernel API (OKAPI)
Mobile Sync API
ocSessionInit
ocSessionTerm
ocSaveUserInfo
ocDoSynchroize
ocSetTableSyncFlag
Mobile Sync API Data Structures
ocEnv
ocTransportEnv
Developing Applications for the EPOC Platform
Creating a Project File
Compiling Mobile SQL for the Emulator
Building the Emulator Debug Version of Mobile SQL
Building the Emulator Release Version of Mobile SQL
Compiling and Testing okdemo on the Development System
Compiling and Running okdemo on the WINS Emulator
Compiling and Running the Debug Version of okdemo
Creating the AptData JDBC Application
Compiling for the EPOC Device
Installing the Application on the EPOC Device

6 Using the Packaging Wizard

Packaging Wizard Overview
Starting the Packaging Wizard
Naming New Applications
Naming Platform Files
Listing Application Files
Sorting
Filters
Entering Database Information
Defining Snapshots For Replication
Creating New Snapshots
Importing Snapshots
Editing Snapshots
Completing the Application
The XML File
Creating JAR Files
Creating SQL Files
Restarting the Packaging Wizard
Publishing the Application
Editing Applications

A Mobile Server System Catalog

"MOBILEADMIN".CV$ALL_CLIENTS
"MOBILEADMIN".CV$ALL_PUBLICATIONS
"MOBILEADMIN".CV$ALL_SUBSCRIPTIONS
"MOBILEADMIN".CV$ALL_SEQUENCES
"MOBILEADMIN".CV$ALL_SEQUENCE_PARTITIONS
"MOBILEADMIN".CV$ALL_PUBLICATION_ITEMS_ADDED
"MOBILEADMIN".CV$ALL_PUBLICATION_ITEMS
"MOBILEADMIN".CV$ALL_PUBLICATION_INDEXES
"MOBILEADMIN".CV$ALL_SUBSCRIPTION_PARAMS

B SQL Support

Oracle Lite for EPOC SQL Support

C Mobile SQL

Overview
Database Access
Installation and Setup
Starting and Stopping Mobile SQL
Main Form
Table Form
The SQL Form
The Edit Row Dialog

Glossary

Index


Go to next page
Oracle
Copyright © 2001 Oracle Corporation.

All Rights Reserved.
Go To Index
Index