Skip Headers

Oracle9i Lite Developers Guide for Windows CE
Release 5.0.1
Part No. A95913-01
Go To Index
Index

Next

Contents

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

1 Overview

1.1 Introduction
1.1.1 Supported Windows CE Operating Systems
1.1.2 Mobile Development Kit Directory Structure
1.1.2.1 Supported Languages
1.1.2.2 Supported Chipsets
1.2 Application Development
1.2.1 Oracle Lite Utilities
1.2.2 Development Tools
1.2.3 Development Interfaces
1.2.3.1 JDBC
1.2.3.2 ODBC
1.2.3.3 Object Kernel API (OKAPI)
1.2.3.4 Mobile Sync API
1.2.3.5 Active Data Objects for CE (ADOCE)
1.3 Development Process
1.3.1 Configuring the Development System
1.3.2 Publication Item Creation
1.3.2.1 Creating a Publication Item Declaratively
1.3.2.2 Creating the Publication Item Programmatically
1.3.3 Setting Up the Windows CE Device
1.3.4 Replication with the Windows CE Device
1.3.5 Developing Mobile Applications for Windows CE
1.3.6 Testing on the Device
1.3.7 Application Packaging
1.4 Limitations

2 Synchronization

2.1 Overview
2.1.1 Publication and Subscription
2.1.2 Client Device Database DDL Operations
2.1.3 Database Support
2.1.4 Binding User-Defined PL/SQL Packages
2.1.5 Flexible Naming
2.1.6 Fast Refresh and Update Operation for Views
2.1.6.1 Updatable Parent Tables
2.1.6.2 Using Parent Table Hints and INSTEAD OF Triggers
2.1.6.3 Fast Refresh for Views
2.1.6.4 Complete Refresh for Views
2.1.7 Foreign Key Constraints in Updatable Publication Items
2.1.7.1 Foreign Key Constraint Violation Example
2.1.7.2 Avoiding Constraint Violations with BeforeApply and After Apply
2.1.7.3 Avoiding Constraint Violations with Table Weights
2.1.8 Replication Errors and Conflicts
2.1.8.1 Versioning
2.1.8.2 Winning Rules
2.2 Mapping Datatypes Between the Oracle Server and Devices
2.2.1 Oracle Lite Datatypes
2.3 The Publish and Subscribe Model
2.3.1 Connecting to Mobile Server
2.3.2 User Functions of the Mobile Server Admin API
2.3.2.1 Create User
2.3.2.2 Change Password
2.3.2.3 Drop User
2.3.3 Creating Publications
2.3.3.1 Defining Publication Items
2.3.3.2 Data Subsetting
2.3.4 Creating Publication Items
2.3.4.1 Null Sync Callout
2.3.5 Retrieving Publication Item Names
2.3.6 Creating Publication Item Indexes
2.3.6.1 Define Client Indexes
2.3.7 Adding Publication Items to the Publication
2.3.7.1 Read-only Publication Items
2.3.7.2 Defining Conflict Rules
2.3.7.3 Using Table Weight
2.3.8 Creating Sequences
2.3.9 Subscribing Users to a Publication
2.3.10 Partitioning Sequences for Client Devices
2.3.11 Defining Client Subscription Parameters to Publications
2.3.12 Instantiating the Subscription
2.3.13 Schema Evolution Using Alter Publication Item
2.3.13.1 Alter Publication Item
2.4 Publish and Subscribe Method Specialized Functions
2.4.1 Callback Customization Using Compose and Apply
2.4.2 Defining Customized DML Operations
2.4.2.1 PL/SQL Code Example
2.4.3 Virtual Primary Key
2.4.3.1 Create Virtual Primary Key Column
2.4.3.2 Drop Virtual Primary Key Column
2.4.4 Restricting Predicate
2.4.5 Resolving Conflicts Using the Error Queue
2.4.5.1 Execute Transaction
2.4.5.2 Purge Transaction
2.5 Mobile Sync API
2.5.1 ocSessionInit
2.5.2 ocSessionTerm
2.5.3 ocSaveUserInfo
2.5.4 ocDoSynchronize
2.5.5 ocSetTableSyncFlag
2.6 Mobile Sync API Data Structures
2.6.1 ocEnv
2.6.2 ocTransportEnv
2.7 The Mobile Client on Your CE Device
2.7.1 Installing the Active Sync Providers
2.7.2 Installing the Active Sync Device Provider
2.7.3 Installing Files from the Mobile Server
2.7.4 Data Source Name Creation
2.7.5 Storing Databases in Flash Memory Cards
2.7.6 Active Sync Overview
2.7.7 Active Sync Configuration
2.7.7.1 Enabling the Active Sync mSync Provider
2.7.8 Syncronizing with ActiveSync
2.7.8.1 Synchronization Settings
2.7.8.2 mSync Proxy Settings
2.8 Configuring RAS Transport
2.8.1 Configuring NT RAS
2.8.2 Create a RAS User account for the device as follows:
2.8.3 Windows Desktop RAS Settings
2.8.4 Windows Desktop Settings
2.9 Installing the Sample Application on the Device
2.10 Testing Synchronization
2.11 Mobile Server System Catalog Views

3 ActiveX Data Objects for Windows CE

3.1 Overview
3.2 Functions
3.3 ActiveX Data Objects for Windows CE Objects
3.4 Active Connection Object Methods
3.4.1 Connect
3.4.2 Disconnect
3.5 Recordset Object Methods
3.5.1 AddNew
3.5.2 CancelUpdate
3.5.3 Clone
3.5.4 Close
3.5.5 Delete
3.5.6 GetRows
3.5.7 Move
3.5.8 MoveFirst, MoveLast, MoveNext, MovePrevious
3.5.9 Open
3.5.10 Supports
3.5.11 Update
3.6 Recordset Object Properties
3.6.1 AbsolutePage
3.6.2 AbsolutePosition
3.6.3 ActiveConnection
3.6.4 BOF, EOF
3.6.5 Bookmark
3.6.6 CacheSize
3.6.7 Count
3.6.8 CursorType
3.6.9 EditMode
3.6.10 LockType
3.6.11 PageCount
3.6.12 PageSize
3.6.13 RecordCount
3.6.14 Source
3.7 Field Object Properties
3.7.1 ActualSize
3.7.2 Attributes
3.7.3 DefinedSize
3.7.4 Name
3.7.5 Type
3.7.6 UnderlyingValue
3.7.7 Value
3.8 Recordset Object Collection
3.8.1 Fields
3.9 SQL and Database Reference
3.10 Error Messages
3.10.1 ActiveX Data Objects Errors
3.10.2 SQL Errors

4 Using the Packaging Wizard

4.1 Packaging Wizard Overview
4.2 Starting the Packaging Wizard
4.3 Platform Selection
4.4 Naming New Applications
4.4.1 Locating Platform Files
4.5 Listing Application Files
4.5.1 Sorting
4.5.2 Filters
4.6 Entering Database Information
4.7 Defining Snapshots For Replication
4.7.1 Creating New Snapshots
4.7.2 Importing Snapshots
4.7.3 Editing Snapshots
4.8 Completing the Application
4.8.1 The Application File
4.8.2 Creating JAR Files
4.8.3 Creating SQL Files
4.8.4 Restarting the Packaging Wizard
4.8.5 Publishing the Application
4.8.6 Editing Applications

A System Catalog Views

A.1 Oracle Lite Database Catalog Views
A.1.1 ALL_COL_COMMENTS
A.1.2 ALL_CONSTRAINTS
A.1.3 ALL_CONS_COLUMNS
A.1.4 ALL_INDEXES
A.1.5 ALL_IND_COLUMNS
A.1.6 ALL_OBJECTS
A.1.7 ALL_SEQUENCES
A.1.8 ALL_SYNONYMS
A.1.9 ALL_TABLES
A.1.10 ALL_TAB_COLUMNS
A.1.11 ALL_TAB_COMMENTS
A.1.12 ALL_USERS
A.1.13 ALL_VIEWS
A.1.14 CAT
A.1.15 COLUMN_PRIVILEGES
A.1.16 DATABASE_PARAMETERS
A.1.17 DUAL
A.1.18 SNAPSHOTS
A.1.19 TABLE_PRIVILEGES
A.1.20 USER_OBJECTS

B Oracle Lite Utilities

B.1 Running Command Line Utilities on a CE Device
B.1.1 Compaq iPaq
B.1.2 HP Jornada and Casio
B.2 CREATEDB
B.3 DECRYPDB
B.4 ENCRYPDB
B.5 Mobile SQL
B.5.1 Database Access
B.5.2 Starting Mobile SQL
B.6 ODBINFO
B.7 REMOVEDB

Glossary

Index


Next
Oracle Logo
Copyright © 2002 Oracle Corporation

All rights reserved
Go To Index
Index