1/26
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Send Us Your Comments
1
Overview
1.1
Introduction
1.2
Supported Technologies for Application Development
1.2.1
Native Applications
1.2.2
Standalone Java Applications
1.2.3
Web Applications
1.3
Oracle Database Lite Application Model and Architecture
1.3.1
Oracle Database Lite RDBMS
1.3.2
Mobile Sync
1.3.3
Mobile Server
1.3.4
Message Generator and Processor (MGP)
1.3.5
Mobile Server Repository
1.4
Execution Models for Oracle Lite Database
1.4.1
Embedded Application in Single Process
1.4.2
Multiple Processes Accessing the Same Database
1.4.3
Multiple Embedded Application Clients Accessing Remote Database
1.4.4
Embedded Mobile Client in Single Process
1.4.5
Multiple Clients Accessing Remote Database
1.5
Mobile Development Kit (MDK)
1.5.1
Mobile SQL (mSQL)
1.5.2
Using the Mobile Database Workbence
1.5.3
Using the Packaging Wizard
1.6
Java Support
1.7
Data Source Name
2
The Oracle Database Lite RDBMS
2.1
Oracle Lite Database Overview
2.2
Creating and Managing the Database for a Mobile Client
2.3
Creating and Managing the Database in an Embedded Application
2.3.1
Install Oracle Database Lite Runtime
2.3.2
Creating the Default Starter Oracle Lite Database for an Embedded Application
2.3.3
Creating a Unique Oracle Lite Database for an Embedded Application
2.3.3.1
Creating a Data Source Name with ODBC Administrator
2.3.3.2
Creating a New Oracle Lite Database for the Embedded Application
2.3.3.3
Connecting to Your New Oracle Lite Database
2.3.4
Creating Users for Your Embedded Oracle Lite Database
2.3.4.1
Pre-Defined Roles
2.3.4.2
Building and Populating Demo Tables
2.3.5
Packaging Your Embedded Application With the Oracle Database Lite Runtime
2.4
Data Access APIs
2.4.1
JDBC
2.4.2
ODBC
2.4.3
ADO.NET
2.4.4
SODA
2.5
Oracle Database Lite Multi-User Service
2.5.1
Accessing the Multi-User Oracle Database Lite Database Service
2.5.1.1
Administration for the Multi-User Service on the Windows Platform
2.5.1.2
Administration for the Multi-User Service on the Linux Platform
2.5.1.3
Debugging the Multi-User Service
2.5.1.4
Creating DSNs
2.5.1.5
Accessing the Database
2.5.1.6
Verifying the Connection Using mSQL
2.6
Move Your Client Data Between an Oracle Lite Database and an External File
2.6.1
Move Data Between an Oracle Lite Database and an External File Using Programmatic APIs
2.6.2
Oracle Database Lite Load Utility (OLLOAD)
2.7
Backing Up an Oracle Lite Database
2.8
Encrypting a Database
2.9
Discover Oracle Lite Database Version Number
2.10
Support for Linguistic Sort
2.10.1
Creating Linguistic Sort Enabled Databases
2.10.2
How Collation Works
2.10.3
Collation Element Examples
2.10.3.1
Sorting Normal Characters
2.10.3.2
Reverse Sorting of French Accents
2.10.3.3
Sorting Contracting Characters
2.10.3.4
Sorting Expanding Characters
2.10.3.5
Sorting Numeric Characters
2.11
Using Oracle Database Lite Samples
2.11.1
Executing the Visual Basic Sample Application
2.11.1.1
Open Visual Basic
2.11.1.2
View the Sample Application Tables and Data
2.11.1.3
Open the Sample Application
2.11.1.4
View and Manipulate the Data in the EMP Table
2.11.2
Executing the ODBC Examples
2.11.2.1
ODBCTBL
2.11.2.2
ODBCVIEW
2.11.2.3
ODBCFUNC
2.11.2.4
ODBCTYPE
2.11.2.5
LONG
2.12
Limitations of the Oracle Database Lite Engine
3
Synchronization
3.1
How Does Synchronization Work?
3.1.1
Synchronization Overview
3.1.2
Automatic or Manual Synchronization
3.1.3
How Updates Are Propagated to the Back-End Database
3.2
Automatic Synchronization Overview
3.2.1
Enable Automatic Synchronization at the Publication Item Level
3.2.2
Enable/Disable Automatic Synchronization
3.2.2.1
POLITE.INI Configuration to Enable/Disable Automatic Synchronization
3.2.2.2
Overview of the Start/Stop Methods from the Sync Control API.
3.2.2.3
C/C++ Sync Control APIs to Start/Stop Automatic Synchronization
3.2.2.4
C# Sync Control APIs to Start/Stop Automatic Synchronization
3.2.2.5
JAVA Sync Control APIs to Start/Stop Automatic Synchronization
3.2.3
Define the Rules Under Which the Automatic Synchronization Starts
3.2.3.1
Configure Publication-Level Automatic Synchronization Rules
3.2.3.2
Configure Platform-Level Automatic Synchronization Rules
3.2.4
Enable the Server to Notify the Client to Initiate a Synchronization to Download Data
3.2.5
Notify Application on Completion of Automatic Synchronization Cycle
3.2.6
Request Status for Automatic Synchronization Cycle
3.3
What is The Process for Setting Up a User For Synchronization?
3.3.1
Creating a Snapshot Definition Declaratively
3.3.1.1
Manage Snapshots
3.3.2
Creating the Snapshot Definition Programmatically
3.4
Creating Publications Using Oracle Database Lite APIs
3.4.1
Defining a Publication With Java Consolidator Manager APIs
3.4.1.1
Create the Mobile Server User
3.4.1.2
Create Publications
3.4.1.3
Create Publication Items
3.4.1.4
Define Publication-Level Automatic Synchronization Rules
3.4.1.5
Data Subsetting: Defining Client Subscription Parameters for Publications
3.4.1.6
Create Publication Item Indexes
3.4.1.7
Adding Publication Items to Publications
3.4.1.8
Creating Client-Side Sequences for the Downloaded Snapshot
3.4.1.9
Subscribing Users to a Publication
3.4.1.10
Instantiate the Subscription
3.4.1.11
Bringing the Data From the Subscription Down to the Client
3.4.1.12
Modifying a Publication Item
3.4.1.13
Callback Customization for DML Operations
3.4.1.14
Restricting Predicate
3.5
Client Device Database DDL Operations
3.6
Customize the Compose Phase Using MyCompose
3.6.1
Create a Class That Extends MyCompose to Perform the Compose
3.6.2
Implement the Extended MyCompose Methods in the User-Defined Class
3.6.2.1
Implement the needCompose Method
3.6.2.2
Implement the doCompose Method
3.6.2.3
Implement the init Method
3.6.2.4
Implement the destroy Method
3.6.3
Use Get Methods to Retrieve Information You Need in the User-Defined Compose Class
3.6.3.1
Retrieve the Publication Name With the getPublication Method
3.6.3.2
Retrieve the Publication Item Name With the getPublicationItem Method
3.6.3.3
Retrieve the DML Table Name With the getPubItemDMLTableName Method
3.6.3.4
Retrieve the Primary Key With the getPubItemPK Method
3.6.3.5
Retrieve All Base Tables With the getBaseTables Method
3.6.3.6
Retrieve the Primary Key With the getBaseTablePK Method
3.6.3.7
Discover If Base Table Has Changed With the baseTableDirty Method
3.6.3.8
Retrieve the Name for DML Log Table With the getBaseTableDMLLogName Method
3.6.3.9
Retrieve View of the Map Table With the getMapView Method
3.6.4
Register the User-Defined Class With the Publication Item
3.7
Customize What Occurs Before and After Synchronization Phases
3.7.1
Customize What Occurs Before and After Every Phase of Each Synchronization
3.7.1.1
NullSync
3.7.1.2
BeforeProcessApply
3.7.1.3
AfterProcessApply
3.7.1.4
BeforeProcessCompose
3.7.1.5
AfterProcessCompose
3.7.1.6
BeforeProcessLogs
3.7.1.7
AfterProcessLogs
3.7.1.8
BeforeClientCompose
3.7.1.9
AfterClientCompose
3.7.1.10
Example Using the Customize Package
3.7.1.11
Error Handling For CUSTOMIZE Package
3.7.2
Customize What Occurs Before and After Compose/Apply Phases for a Single Publication Item
3.8
Initiating Client Synchronization With Synchronization APIs
3.8.1
Starting Synchronization Upload and Download Phases With C or C++ Applications
3.8.2
Starting Synchronization Upload and Download Phases With Java Applications
3.8.3
Starting Synchronization Upload and Download Phases With the ADO.NET Provider
3.9
Understanding Your Refresh Options
3.9.1
Fast Refresh
3.9.2
Complete Refresh for Views
3.9.3
Queue-Based Refresh
3.9.4
Forced Refresh
3.10
Resuming an Interrupted Synchronization
3.10.1
Defining Temporary Storage Location for Client Data
3.10.2
Controlling Server Load
3.10.3
Client Configuration.
3.11
Synchronizing With Database Constraints
3.11.1
Synchronization And Database Constraints
3.11.2
Primary Key is Unique
3.11.3
Foreign Key Constraints
3.11.3.1
Set Update Order for Tables With Weights
3.11.3.2
Defer Constraint Checking Until After All Transactions Are Applied
3.11.4
Unique Key Constraint
3.11.5
Not Null Constraint
3.11.6
Generating Constraints on the Mobile Client
3.11.6.1
The assignWeights Method
3.12
Parent Tables Needed for Updateable Views
3.12.1
Creating a Parent Hint
3.12.2
INSTEAD OF Triggers
3.13
Resolving Conflict Resolution with Winning Rules
3.13.1
Resolving Errors and Conflicts Using the Error Queue
3.13.2
Customizing Synchronization Conflict Resolution Outcomes
3.14
Manipulating Application Tables
3.14.1
Creating Secondary Indexes on Client Device
3.14.2
Virtual Primary Key
3.15
Facilitating Schema Evolution
3.16
Set DBA or Operational Privileges for the Mobile Server
3.17
Create a Synonym for Remote Database Link Support For a Publication Item
3.17.1
Publishing Synonyms for the Remote Object Using CreatePublicationItem
3.17.2
Creating or Removing a Dependency Hint
3.18
Using the Sync Discovery API to Retrieve Statistics
3.18.1
getDownloadInfo Method
3.18.2
DownloadInfo Class Access Methods
3.18.3
PublicationSize Class
3.19
Customizing Replication With Your Own Queues
3.19.1
Customizing Apply/Compose Phase of Synchronization with a Queue-Based Publication Item
3.19.1.1
Queue Creation
3.19.1.2
Queue-Based PL/SQL Procedure for UPLOAD_COMPLETE and DOWNLOAD_INIT Callouts
3.19.1.3
Create a Publication Item as a Queue
3.19.1.4
Register the PL/SQL Package Outside the Repository
3.19.2
Creating Data Collection Queues for Uploading Client Collected Data
3.19.2.1
Creating a Data Collection Queue
3.19.3
Selecting How/When to Notify Clients of Composed Data
3.20
Deleting a Client Device
3.21
Synchronization Performance
3.22
Troubleshooting Synchronization Errors
3.22.1
Foreign Key Constraints in Updatable Publication Items
3.22.1.1
Foreign Key Constraint Violation Example
3.22.1.2
Avoiding Constraint Violations with Table Weights
3.22.1.3
Avoiding Constraint Violations with BeforeApply and After Apply
3.23
Datatype Conversion Between the Oracle Server and Client Oracle Lite Database
4
Invoking Synchronization APIs from Applications
4.1
Synchronization APIs For C or C++ Applications
4.1.1
Overview of 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.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
Manage What Tables Are Synchronized With Selective Sync
4.2.8
SyncProgress Listener Service
4.3
msync/OCAPIs/mSyncCom
5
Using Mobile Database Workbench to Create Publications
5.1
Use MDW to Create Publications
5.1.1
Set Access Privileges to SYSTEM Tables for Your Application Schema
5.1.2
Launch MDW
5.2
Create a Project
5.3
Use the Quick Wizard to Create Your Publication
5.4
Create a Publication Item
5.4.1
Create SQL Statement for Publication Item
5.4.2
Create a Dependency Hint
5.4.3
Specify Parent Table and Primary Key Hints
5.5
Define the Rules Under Which the Automatic Synchronization Starts
5.5.1
Configure Publication-Level Automatic Synchronization Rules
5.5.2
Configure Platform-Level Automatic Synchronization Rules
5.5.2.1
Define System Event Rules for the Platform
5.5.2.2
Define Automatic Synchronization Conditions for the Platform
5.6
Create a Sequence
5.7
Create and Load a Script Into The Project
5.7.1
Writing SQL Scripts
5.7.2
Test SQL Scripts
5.7.2.1
Connect to the Database
5.7.2.2
Load and Execute SQL Scripts
5.7.3
Load the Script Into the Project
5.8
Load a Resource Into the Project
5.9
Create a Publication
5.9.1
General Tab Configures Publication Name
5.9.2
Publication Item Tab Associates Publication Items With the Publication
5.9.2.1
Associating a Publication Item to this Publication
5.9.3
Sequence Tab Associates Existing Sequences With the Publication
5.9.4
Script Tab Associates Existing Scripts With the Publication
5.9.5
Resource Tab Associates Existing Resources With the Publication
5.9.6
Event Tab Configures Automatic Synchronization Rules for this Publication
5.10
Import Existing Publications and Objects from Repository
5.10.1
Import Existing Publication from Repository
5.10.2
Import Existing Publication Item From the Repository
5.10.3
Import Existing Sequence From the Repository
5.10.4
Import Existing Resource From the Repository
5.10.5
Import an Existing Script From the Repository
5.11
Create a Virtual Primary Key
5.12
Test a Publication by Performing a Synchronization
5.13
Deploy the Publications in the Project to the Repository
6
Developing Mobile Web-to-Go Applications
6.1
Choose the Type of Web-to-Go Mobile Client to Use
6.2
Developing and Testing the Application
6.2.1
Building Web-to-Go Applications
6.2.1.1
Static Components
6.2.1.2
Dynamic Components
6.2.1.3
Database Components
6.2.1.4
Database Connections
6.2.2
Application Roles
6.2.3
Developing JavaServer Pages
6.2.3.1
Mobile Server or Mobile Development Kit Web Server
6.2.3.2
Mobile Client for Web-to-Go
6.2.4
Developing Java Servlets for Web-to-Go
6.2.4.1
Limitations
6.2.4.2
Accessing Applications on the Mobile Development Kit for Web-to-Go
6.2.4.3
Creating a Servlet
6.2.4.4
Running a Servlet
6.2.4.5
Accessing the Schema Directly in Oracle Database Lite
6.2.5
Using Web-to-Go Applets
6.2.5.1
Creating the Web-to-Go Applet
6.2.5.2
Creating the HTML Page for the Applet
6.2.6
Developing Applet JDBC Communication
6.2.6.1
getConnection()
6.2.6.2
Design Issue
6.2.7
Developing Applet Servlet Communication
6.2.7.1
Creating the Web-to-Go Servlet
6.2.8
Debugging Web-to-Go Applications
6.2.8.1
Running Sample 1 Using Oracle9
i
JDeveloper
6.2.9
Customizing the Workspace Application
6.2.9.1
Web-to-Go Parameters
6.2.9.2
Sample Workspace
6.2.10
Using the Mobile Server Admin API
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
Native Application Development
8.1
Supported APIs for Oracle Database Lite
8.2
Data Source Name
9
Java Application Development
9.1
Java Support for Applications
9.1.1
JDBC Drivers
9.2
Oracle Database Lite Java Development Environment
9.2.1
Setting Variables for the JDK
9.3
Java Development Tools
10
JDBC Programming
10.1
JDBC Compliance
10.2
JDBC Environment Setup
10.3
JDBC Drivers to Use When Connecting to Oracle Database Lite
10.3.1
Type 2 Driver
10.3.2
Type4 (Pure Java) Driver Connection URL Syntax
10.4
DataSource Connection
10.5
Java Datatypes and JDBC Extensions
10.5.1
Mapping Datatypes Between Java and Oracle
10.5.2
Datatype Extensions
10.5.3
Data Access Extensions
10.5.3.1
Reading from a BLOB Sample Program
10.5.3.2
Writing to a CLOB Sample Program
10.6
Limitations
10.7
New JDBC 2.0 Features
10.7.1
Interface Connection
10.7.1.1
Methods
10.7.2
Interface Statement
10.7.3
Interface ResultSet
10.7.3.1
Fields
10.7.3.2
Methods
10.7.3.3
Methods that Return False
10.7.4
Interface Database MetaData
10.7.4.1
Methods
10.7.4.2
Methods that Return False
10.7.5
Interface ResultMetaData
10.7.5.1
Methods
10.7.6
Interface PreparedStatement
10.7.6.1
Methods
10.8
J2ME Support
10.8.1
JDBC Drivers for J2ME CDC and CLDC
10.8.1.1
JDBC Driver for J2ME CDC
10.8.1.2
JDBC Driver for J2ME CLDC
10.8.2
J2ME Support for Windows CE
10.8.2.1
Using IBM J9
10.8.2.2
Using Creme 4.1
11
Stored Procedures and Triggers
11.1
Java Stored Procedure Features in Oracle Database Lite
11.2
Overview of Java Stored Procedures and Triggers
11.2.1
Creating Java Stored Procedures
11.3
Creating Java Stored Procedures
11.3.1
Using the Load and Publish Stored Procedure Development Model
11.3.1.1
Loading Java Stored Procedure Classes Into the Oracle Lite Database
11.3.1.2
Publishing Stored Procedures to SQL
11.3.1.3
Calling Published Stored Procedures
11.3.1.4
Dropping Published Stored Procedures
11.3.1.5
Example Using the Load and Publish Model
11.3.2
Using the Attached Stored Procedure Development Model
11.3.2.1
Attaching a Java Class to a Table
11.3.2.2
Table-Level Stored Procedures
11.3.2.3
Row-Level Stored Procedures
11.3.2.4
Calling Attached Stored Procedures
11.3.2.5
Dropping Attached Stored Procedures
11.3.2.6
Example of An Attached Java Stored Procedure
11.3.3
Calling Java Stored Procedures From a Multithreaded C or C++ Application
11.4
Converting Datatypes Between Java and SQL For Stored Procedures
11.4.1
Declaring Parameters for Java Stored Procedures
11.4.2
Using Stored Procedures to Return Multiple Rows
11.4.2.1
Returning Multiple Rows in ODBC
11.4.2.2
Example
11.5
Using Triggers With Java Stored Procedures
11.5.1
Statement-Level vs. Row-Level Triggers
11.5.2
Creating Triggers
11.5.2.1
Enabling and Disabling Triggers
11.5.3
Dropping Triggers
11.5.4
Trigger Example
11.5.5
Trigger Arguments
11.5.6
Trigger Arguments Example
11.6
Creating a Java Stored Procedure That Is Invoked With a Trigger
11.6.1
Start mSQL
11.6.2
Create a Table
11.6.3
Create a Java Class
11.6.4
Load the Java Class File
11.6.5
Publish the Stored Procedure
11.6.6
Populate the Database
11.6.7
Execute the Procedure
11.6.8
Verify the Email Address
11.6.9
Create a Trigger
11.6.9.1
Testing the Trigger
11.6.9.2
Verify the Email Address
11.6.10
Commit or Roll Back
11.7
Executing Java Stored Procedures from JDBC
11.7.1
Using the executeQuery Method
11.7.2
Using a Callable Statement
11.8
Using C++ Stored Procedures
11.8.1
Creating C++ Stored Procedures
11.8.1.1
C++ Stored Procedure Include File and Procedure Definition
11.8.1.2
Access SODA Objects Within Your C++ Stored Procedure
11.8.2
Building Your C++ Stored Procedures
11.8.2.1
Linking in Appropriate Libraries
11.8.2.2
Automatically Build Your Stored Procedure
11.8.2.3
Manually Building Your Stored Procedure
11.8.3
Publish Your C++ Stored Procedure
11.8.4
C++ Stored Procedure Example
11.8.4.1
C++ Stored Procedure and Trigger Example One
11.8.4.2
C++ Stored Procedure and Trigger Example Two
11.8.4.3
JDBC Calling a C++ Stored Procedure Example
11.9
Using .Net Stored Procedures
11.9.1
Creating the .Net Source for Your Stored Procedure
11.9.1.1
Defining Methods, Imports and Namespace
11.9.1.2
Access and Modify Database Using .Net Extension Classes In Stored Procedures
11.9.1.3
Access and Modify Database Using OracleSPManager Inside Triggers
11.9.2
Building Your .Net Stored Procedures
11.9.3
Publish Your .Net Stored Procedure
11.9.3.1
Create the .Net Class Object in the Oracle Lite Database
11.9.3.2
Publish Methods With a Call Specification
11.9.4
Dropping .Net Stored Procedures
11.9.5
.Net Stored Procedure Example
11.9.5.1
.Net Stored Procedure and Trigger Example One
11.9.5.2
.Net Stored Procedure and Trigger Example Two
12
Using Simple Object Data Access (SODA) for PocketPC Platforms
12.1
Getting Started With SODA
12.1.1
Overview of the SODA Classes
12.1.2
Demonstrating Frequently-Used SODA Classes
12.2
Using SQL Queries in SODA Code for PocketPC Platforms
12.3
Virtual Columns and Object-Relational Mapping
12.4
Behavior of Reference-Counted and Copy-By-Assignment Objects
12.5
Another Library for Exceptions (ALE)
12.5.1
Decorating Classes With ALE
12.5.2
New Operator and ALE
12.5.3
Global Variables
12.5.4
Exceptions and Inheritance
12.5.5
Using ALE with PocketPC ARM Compilers
12.5.6
Troubleshooting ALE Runtime Errors
12.5.7
Compiling Your Program With ALE
12.5.8
ALE Code on Systems That Support Exceptions
12.6
Building a SODA Forms Application
12.6.1
Development Environment Requirements
12.6.2
Develop Your GUI Using the SODA Forms Library
12.6.2.1
Traditional Way to Develop Native Data Entry Applications
12.6.2.2
Trimming Your PocketPC UI Code With SODA Forms
12.6.3
Designing the UI for PocketPC
12.6.4
Customizing the Database Schema
12.6.5
Binding UI to Data in the PocketPC Environment
12.6.6
Setting List Choices for Status Contol on PocketPC
12.6.7
Customizing the Table in OrderForm
12.6.8
Monitoring the Logic
12.6.9
Compiling Your SODA Application
12.7
SODA Forms Edit Modes
12.7.1
Editing a Single Object
12.7.2
Editing a List of Objects
12.7.3
Creating a New Object
12.7.4
Popping Up A Dialog
12.7.5
Custom Queries for PocketPC Environment
12.8
Customizing Your SODA Forms Application
12.8.1
Customizing Help Messages
12.8.2
Menus
12.9
Displaying a List Of Objects in a Table
12.10
SODA Forms UI Controls
13
Oracle Database Lite ADO.NET Provider
13.1
Discussion of the Classes That Support the ADO.NET Provider
13.1.1
Establish Connections With the OracleConnection Class
13.1.2
Transaction Management
13.1.3
Create Commands With the OracleCommand Class
13.1.4
Maximize Performance Using Prepared Statements With the OracleParameter Class
13.1.4.1
SQL String Parameter Syntax
13.1.5
Large Object Support With the OracleBlob Class
13.1.5.1
Using BLOB Objects in Parameterized SQL Statements
13.1.5.2
Query Tables With BLOB Columns
13.1.5.3
Read and Write Data to BLOB Objects
13.1.6
Data Synchronization With the OracleSync Class
13.1.6.1
Using the OracleSync Class to Synchronize
13.1.6.2
Using the OracleEngine to Synchronize
13.1.7
Creating a Database for Testing
13.2
Limitations for the ADO.NET Provider
13.2.1
Partial Data Returned with GetSchemaTable
13.2.2
Creating Multiple DataReader Objects Can Invalidate Each Other
13.2.3
Calling DataReader.GetString Twice Results in a DbNull Object
13.2.4
Thread Safety
13.3
Developing an ADO.NET Application on WinCE
14
Using Symbian Devices
14.1
Support Symbian Devices in Oracle Database Lite
14.2
Invoke Synchronization from Applications on Symbian Devices
14.2.1
How To Write A Program Using Oracle Database Lite 10g
14.2.2
Prepare Your Application for Synchronization
14.2.3
How to Use the Synchronization API for Symbian Devices
14.3
Using a JDBC Driver for J2ME CLDC to Connect to the Database
14.4
Use the Utility Tools on Symbian Devices
15
Oracle Database Lite Transaction Support
15.1
Locking
15.2
What Are the Transaction Isolation Levels?
15.3
Configuring the Isolation Level
15.4
Supported Combinations of Isolation Levels and Cursor Types
16
Oracle Database Lite Security
16.1
Authenticating Users With Your Own User Management System
16.1.1
Implementing Your External Authenticator
16.1.1.1
The Initialization Method for the External Authenticator
16.1.1.2
The Destruction Method for the External Authenticator
16.1.1.3
The Authentication Method for the External Authenticator
16.1.1.4
The User Instantiation Method for the External Authenticator
16.1.1.5
Retrieve the User Name or the User Global Unique ID
16.1.1.6
Log Off User
16.1.1.7
Change User Password
16.1.2
Registering External Authenticator
16.1.3
User Initialization Scripts
16.2
Providing Your Own Encryption Module for the Client Oracle Lite Database
16.2.1
Encryption Module APIs
16.2.1.1
Initialize the Encryption Module
16.2.1.2
Delete Encryption Context
16.2.1.3
Create the Encryption Key
16.2.1.4
Encrypt Data
16.2.1.5
Decrypt Data
16.2.2
Plug-In Custom Encryption Module
17
Tutorial for Building Mobile Web-to-Go Applications
17.1
Develop the Application
17.1.1
Create Database Objects in the Oracle Server
17.1.1.1
Create the Table Owner Account
17.1.1.2
Create the Database Objects in the Oracle Database
17.1.2
Compile the Application
17.2
Create Publication for Application
17.2.1
Create a Project
17.2.2
Create Publication Items
17.2.2.1
Create Publication Item
17.2.2.2
Create Sequence
17.2.3
Create Publication
17.3
Package the Application Using the Packaging Wizard
17.4
Administer the Application
17.4.1
Start the Mobile Server and the Mobile Manager
17.4.2
Using the Mobile Manager to Create a New User
17.4.3
Setting Application Properties
17.4.4
Granting User Access to the Application
17.4.5
Defining Snapshot Template Values for the User
17.5
Execute the Application on the Mobile Client for Web-to-Go
17.5.1
Install the Mobile Client for Web-to-Go
17.5.2
Log into the Mobile Client for Web-to-Go
17.5.3
Manually Synchronize the Mobile Client for Web-to-Go
18
Tutorial for Building Mobile Web Applications Using ADF/BC4J
18.1
Overview
18.1.1
Before You Start
18.2
Creating a Database Connection
18.2.1
Creating a Database Connection to Oracle Database
18.2.2
Specify The Connection To The Oracle Lite Database
18.3
Develop the ADF/BC4J Application
18.3.1
Building the Data Model with ADF Business Components
18.3.1.1
Create a New Application and Projects
18.3.1.2
Create Business Components
18.3.2
Customize the Business Components Views
18.3.3
Creating a Master-Detail JavaServer Faces Page
18.3.4
Running the JSF Page
18.3.5
Configure the ADF/BC4J Application for the Oracle Database Lite Environment
18.3.6
Deploy the Application as WAR file
18.4
Package the ADF/BC4J Application
18.4.1
Include the ADF Runtime Libraries with the ADF/BC4J Application
18.4.2
Package the Application from the Packaging Wizard
18.5
Publish and Configure the ADF/BC4J Application from the Mobile Manager
18.6
Test the ADF/BC4J Application
18.7
Run the ADF/BC4J Application on the Mobile Client for Oracle Lite WEB OC4J
19
Tutorial for Building Mobile Applications for Win32
19.1
Plan the Mobile Application Demo for Win32
19.2
Description of Tasks for Win32 Demo
19.2.1
Create TASK Table on the Server Database
19.2.2
Create Publication for Application
19.2.2.1
Create a Project
19.2.2.2
Create Publication Item
19.2.2.3
Create Publication
19.2.3
Package the Application Using the Packaging Wizard
19.3
Administer the Application
19.3.1
Start the Mobile Server and the Mobile Manager
19.3.2
Using the Mobile Manager to Create New Users for the Task Application
19.3.3
Setting Application Properties
19.3.4
Granting User Access to the Application
19.3.5
Defining Snapshot Template Values for the User
19.4
Execute the Application on the Mobile Client for Web-to-Go
19.4.1
Install the Mobile Client on the Win32 Device
19.4.2
Browse the TASK Snapshot and Update a Row
19.4.3
Develop your Mobile Field Service Application Using Oracle Database Lite
19.4.4
Republish the Application with the Application Program
20
Tutorial for Building Mobile Applications for Windows CE
20.1
Overview of the WinCE Sample Application
20.1.1
Before You Start
20.1.1.1
Application Development Computer Requirements
20.1.1.2
Client Device Requirements
20.2
Develop the Application
20.2.1
Create Database Objects in the Oracle Server
20.2.1.1
The WinCE Transport Application Database Objects
20.2.2
Write the Application Code
20.2.2.1
Transport Module (Transport.vb)
20.2.2.2
Main Form (frmMain.vb)
20.2.2.3
View Packages (frmView.vb)
20.2.2.4
Create Package (frmNew.vb)
20.2.3
Compile the Application
20.2.3.1
Create CAB Files
20.2.3.2
Install the Application from the CAB File
20.3
Create Publication for Application
20.3.1
Create a Project
20.3.2
Create Publication Items
20.3.2.1
Create Packages Publication Item
20.3.2.2
Create Routes Publication Item
20.3.2.3
Create Trucks Publication Item
20.3.3
Create Publication
20.4
Package and Publish the Application
20.4.1
Define the Application Using the Packaging Wizard
20.4.1.1
Create a New Application
20.4.2
Publish the Application
20.5
Administer the Application
20.5.1
Start the Mobile Server
20.5.2
Launch the Mobile Manager
20.5.3
Create a New User
20.5.4
Set the Application Properties
20.5.5
Grant User Access to the Application
20.6
Run the Application on the Windows Mobile/Pocket PC Device
20.6.1
Install the Oracle Database Lite Mobile client for Pocket PC
20.6.2
Install and Synchronize the Transport Application and Data
A
Oracle Lite Database Utilities
A.1
The mSQL Tool
A.1.1
The mSQL Tool for Windows 32
A.1.1.1
Starting mSQL
A.1.1.2
Populating your Database Using mSQL
A.1.1.3
SET TERM {ON|OFF}
A.1.1.4
SET TIMING {ON|OFF}
A.1.1.5
SET VERIFY {ON|OFF}
A.1.2
The mSQL Tool for Windows CE
A.1.2.1
The mSQL GUI Tool
A.1.2.2
The Command-Line Version of the mSQL Tool for Windows CE
A.2
CREATEDB
A.3
REMOVEDB
A.4
ENCRYPDB
A.5
DECRYPDB
A.6
BACKUPDB
A.7
ODBC Administrator and the Oracle Database Lite ODBC Driver
A.7.1
Adding a DSN Using the ODBC Administrator
A.7.2
Adding a DSN which points to Read-Only Media (CD-ROM)
A.8
ODBINFO
A.9
VALIDATEDB
A.10
Transferring Data Between a Database and an External File
A.10.1
OLLOAD
A.10.1.1
Syntax
A.10.1.2
Keywords and Parameters
A.10.2
Oracle Database Lite Load Application Programming Interfaces (APIs)
A.10.2.1
Overview
A.10.2.2
Oracle Database Lite Load APIs
A.10.2.3
File Format
A.10.2.4
Limitations
Glossary
Index
Scripting on this page enhances content navigation, but does not change the content in any way.