Skip Headers
Oracle® Database Lite Developer's Guide
10g (10.0.0)
Part No. B13788-01
  Go To Table Of Contents
Contents

Previous
Previous
 

Index

A  B  C  D  E  F  H  I  J  L  M  N  O  P  Q  R  S  T  U  V  W 

A

administration, 11.4, 12.5
defining snapshot values, 12.5.5
granting user access, 12.5.4
setting properties, 12.5.3
ADO.NET, 2.2.5
ADO.NET Provider
Classes, 6.1
Limitations, 6.3
Thread Safety, 6.3.1
Running the Demo, 6.2
Advanced Functions for Customizing Consolidator, 3.7.4
AlterPublicationItem, 3.7.4
application
administration, 11.4, 12.5
Web-to-Go, 12.6
application development, 4
Application Model and Architecture
Data Source Name, 1.6
Java Support, 1.5
Message Generator and Processor (MGP), 1.2.4
Mobile Development Kit, 1.3
Mobile Server, 1.2.3
Mobile Server Repository, 1.2.5
Mobile Sync, 1.2.2
Oracle Database Lite RDBMS, 1.2.1
Supported Platforms, 1.4
applications
building Web applications, 12
packaging, 12.3
publishing, 12.4
uploading, 12.4.5

B

BC4J, 13.1.1
access by JSP, 13.2.5
ceating the database connection, 13.2.1
creating the BC4J component, 13.2.2
deploying, 13.7
deploying JSPs, 13.2.6
developing applications, 13.2
overview, 13.1
packaging JSPs, 13.3
publishing, 13.4
testing, 13.5
Web-to-Go, 13.6
BLOB, 2.9.2
building applications
using BC4J, 13.1.1
Win32, 10.1, 10.2, 10.2.1
Windows CE, 11.1, 11.1.1
building Mobile applications
before you start, 12.1.1
developing, 12.2
building Mobile Web applications, 12

C

Caching Publication Item Queries, 3.7.7
Callback Customization for DML Operations, 3.7.13
C/C++ Interface, 5.4.2
Classes
OracleBlob and Large Object Support, 6.1.5
OracleCommand, 6.1.3
OracleConnection, 6.1.1
OracleParameter and PreparedStatements, 6.1.4
OracleSync and Data Synchronization, 6.1.6
Transaction Management, 6.1.2
clients
subscribing to publications, 3.5.12
COM Interface, 5.4.1
Complete Refresh for Views, 3.7.5.4
conflicts, 3.8
Consolidator API, 3.4
Creating a Dependency Hint, 3.7.5.2.1

D

data source
creating name, 2.4.2
database
accessing, 2.2.1.3
backing up, 2.5.11
building demo tables, 2.5.9
connecting, 2.4.4
creating, 2.4.1, 2.4.3
encrypting and decrypting, 2.5.12
granting privileges, 2.5.6
granting roles, 2.5.5
populate, 2.5.10
revoking roles, 2.5.7
starter, 2.3
database connection
verification using msql, 2.2.1.3
database objects
creating, 11.2.1
datatypes
mapping, 3.9
Oracle Database Lite, 3.9.1
decryption
database, 2.5.12
Developing and Testing the Application, 4.2
developing applications
execution, 12.2.4
Developing Java Server Pages, 4.2.3
Developing Mobile Applications for PALM OS Devices
Building a SODA Application, 7.6
Building a SODA Forms Application, 7.7
Building an ODBC Application, 7.8
Customizing Oracle Database Lite Runtime, 7.10
Installing Oracle Database Lite Runtime on the Device, 7.1
Packaging your Application with Oracle Database Lite Runtime, 7.9
Palm Shared Library Manager (PSLM), 7.11
Running Oracle Database Lite on Palm OS Emulator, 7.3
Running Oracle Database Lite on Palm OS Simulator, 7.4
Uninstalling or Replacing Oracle Database Lite Runtime, 7.2
Using Oracle Database Lite Base Libraries, 7.5
Developing Mobile Web Applications, 4.1
development
compiling, 12.2.2
create database object, 12.2.1
registration, 12.2.3
Development and Testing
Building Web-to-Go Applications, 4.2.1
Customizing the Workplace Application, 4.2.9
Debugging Web-to-Go Applications, 4.2.8
Developing Applet JDBC Communication, 4.2.6
Developing Applet Servlet Communication, 4.2.7
Developing Java servlets for Web-to-Go, 4.2.4
Specifying Application Roles, 4.2.2
Using the Mobile Server Admin API, 4.2.10
Using Web-to-Go Applets, 4.2.5
Development Architecture, 4.2
development interfaces, 2.2.1
for object database development, 2.2.1
for relational database development, 2.2.1
JDBC, 2.2.1.1
ODBC, 2.2.1.4
SODA, 2.2.1.5
doCompose Method, 3.7.1.2.2
DSN
creating, 2.2.1.3

E

Embedded Visual Tools, 11
encryption
database, 2.5.12
errors, 3.8

F

fast refresh and update, 3.7.5
Fast Refresh for Views, 3.7.5.3
foreign key constraint, 3.7.11.2
foreign key constraints, 3.7.11
violations, 3.7.11.1

H

hints, 3.7.5.2

I

INSTEAD OF Triggers, 3.7.5.2.2
INSTEAD OF triggers, 3.7.5.2
interfaces, 2.2.1
isolation level
changing, 2.6.3.3

J

JDBC driver, 2.2.1.1
description, 2.2.1.1
JSP
access BC4J component, 13.2.5
deploying, 13.2.6

L

linguistic sort, 2.7
Load APIs, 2.2.3, B.1
Load Utility (OLLOAD), 2.2.4

M

Message Generator and Processor (MGP)
Applying Changes to the Server Database, 1.2.4
starting, 11.4.6
The Apply Phase, 1.2.4
The Compose Phase, 1.2.4
Mobile client
synchronizing, 12.6.3
Mobile Development Kit
Mobile SQL (MSQL), 1.3.1
Using the Packaging Wizard, 1.3.2
Mobile Manager
application properties, 12.5.3
starting, 12.5.1
Mobile Server
logon, 12.4.4
overview, 1.2.3
msql
verifying database connection, 2.2.1.3
MyCompose, 3.7.1, 3.7.1
doCompose, 3.7.1.2.2
needCompse Method, 3.7.1.2.1

N

Native Application Development
Data Source Name, 5.3
Java Support, 5.2
Supported Platforms, 5.1
Using the Packaging Wizard, 5.5
needCompose Method, 3.7.1.2.1
Null Sync Callout, 3.7.10

O

OCBC Administrator, 2.4.2
ODBC
development interfaces, 2.2.1.4
ODBC driver, 2.2.1.4
description, 2.2.1.4
ODBC support
Palm, D.1
openConnection, 3.5.3
Optimizing SQL Queries
Optimizing Single-Table Queries, A.1
Oracle Database Lite
Application Model and Architecture, 1.2
Introduction, 1.1
Oracle Database Lite Datatypes, 3.9.1

P

packaging applications, 12.3, 12.3.6
application connection, 12.3.2
defining, 12.3.1
sequences, 12.3.4
snapshot, 12.3.3
SQL files, 12.3.5
Packaging Wizard, 11.3.1
packaging wizard, 12.3.1.1
Palm Shared Library Manager (PSLM)
Building a Shared Library Project, 8.4
Building an Application Using PSLM, 8.6
Calling a PSLM Library from Your Application, 8.5
Cloaked Shared Libraries, 8.8
Exceptions Across Modules, 8.7
Overview, 8.1
Patching the CodeWarrior Runtime, 8.9
Trying out PSLM, 8.2
Writing a PSLM Library, 8.3
parent tables
hints, 3.7.5.2
INSTEAD OF triggers, 3.7.5.2
updatable, 3.7.5.1, 3.7.5.1
password, 2.5.12
PL/SQL, 3.7.8
Pocket PC
installing, 11.5.1
synchronizing, 11.5.2
primary key index, 3.6.1
Programming interfaces
C / C++, 5.4.2
COM, 5.4.1
properties
setting, 12.5.3
publication, 3.4
publication item, 3.4
publication items
adding to publications, 3.5.9
publications
subscribing clients to, 3.5.12
publish applications, 12.4
create database account, 12.4.1
publishing application
create database objects, 12.4.2
publishing applications
logon to the Mobile Server, 12.4.4
start the Mobile Server, 12.4.3
uploading, 12.4.5
publish/subscribe model, 3.4
purging transactions, 3.8.3.2

Q

query optimizer, A.2.2
Queue Interface, 3.7.9

R

RDBMS
changing passwords, 2.5.4
creating multiple users, 2.5
development interfaces, 2.2, 2.2.1
dropping users, 2.5.3
introduction, 2.1
linguistic sort, 2.7
Refresh
complete, 3.7.5.4
fast, 3.7.5.3
Restricting Predicate, 3.7.14

S

Servlets
registering, 12.2.3
setPassword, 3.6.2.1
snapshot, 3.4
snapshot definitions
creating, 2.8
creating publications, 2.8.2
declarative, 2.8.1
programmatic, 2.8.2
snapshots
defining, 11.3.3
SQLAllocConnect, D.1.1, D.1.1, D.1.1, D.1.1
SQLAllocEnv, D.1.2
SQLAllocHandle, D.1.3, D.1.3
SQLAllocStmt, D.1.4
SQLBindCol, D.1.16
SQLBindParameter, D.1.11
SQLConnect, D.1.9
SQLDescribeCol, D.1.17
SQLDisconnect, D.1.10
SQLError, D.1.18
SQLExecDirect, D.1.13
SQLExecute, D.1.14
SQLFetch, D.1.15
SQLFreeConnect, D.1.5
SQLFreeEnv, D.1.6
SQLFreeHandle, D.1.7
SQLFreeStmt, D.1.8
SQLGetData, D.1.19
SQLNumResultCols, D.1.20
SQLPrepare, D.1.12
SQLRowCount, D.1.21
SQLTransact, D.1.22
subscription, 3.4
subscription parameters, 3.4
defining, 3.5.7
Synchronization
Add Map Table Partitions, 3.7.3.2
Adding Publication Items to the Publication, 3.5.9
Advanced Features for Customizing Consolidator, 3.7
Change Password, 3.6.2
Client Device Database DDL Operations, 3.6.1
Complete Refresh Synchronization, 3.2.2
Compose Phase Customization, 3.7.1
Create a Map Table Partition, 3.7.3.1
CreateSubscription, 3.5.12.1
Creating Publication Item Indexes, 3.5.8
Creating Publication Items, 3.5.5
Creating Users, 3.5.10
Defining Client Subscription Parameters, 3.5.7
Defining Conflict Rules, 3.5.9.2
Defining Publication Items, 3.5.5.2
DownloadInfo Class Access Methods, 3.7.2.2
Drop a Map Table Partition, 3.7.3.3
Drop all Map Table Partitions, 3.7.3.4
Drop User, 3.5.11
Extending MyCompose, 3.7.1.3
Extending MyCompose as a User Defined Sub-Class, 3.7.1.1, 3.7.1.2, 3.7.1.4
Fast Refresh Synchronization, 3.2.1
getDownloadInfo Method, 3.7.2.1
InstantiateSubscription, 3.5.13.1
Instantiating the Subscription, 3.5.13
Map Table Partition APIs, 3.7.3
Merge Map Table Partitions, 3.7.3.5
Mobile Sync APIs, 3.3
Overview, 3.1
Process, 3.2
PublicationSize Class, 3.7.2.3
Publish and Subscribe Model, 3.4, 3.4.1
Publishing Synonyms, 3.6.3.1
Remote Database Link Support, 3.6.3, 3.6.3.3
Sequence Support, 3.5.6
SetSubscription Parameters, 3.5.7.1
Subscribing Users, 3.5.12
Sync Discovery API, 3.7.2
Synchronizing an Encrypted Database, 3.2.3
synchronization
conflicts, 3.8
errors, 3.8
synchronizing
Mobile client, 12.6.3
Pocket PC, 11.5.2

T

tables
building, 2.5.9
tracing, 2.11
transactions, 2.6
changing the default isolation level, 2.6.3.3
executing, 3.8.3.1
locking, 2.6.3.2
purging, 3.8.3.2
tuning, 2.6.4

U

user
granting access, 12.5.4
users
defining snapshot values, 12.5.5
Using Mobile Sync for Palm
Configuring mSync, 9.1
Using HotSync to Synchronize Data with the Mobile Server, 9.2
Configuring HotSync for a PalmOS Device, 9.2.1
Configuring PalmOS Emulator for HotSync, 9.2.3
HotSync Timeout Errors, 9.2.2
Using Network Sync, 9.3
Network Sync With PalmOS Emulator, 9.3.2
Synchronizing Using a Cradle and Windows Desktop, 9.3.1

V

versioning, 3.8.1
views
fast refresh and update, 3.7.5
Virtual Primary Key, 3.7.6

W

Web-to-Go
install the client, 12.6.1
introduction, C.1
sample applications, C.1.1
Web-to-go
client installation, 12.6.1
Win32
command sequence, 10.2.1
Windows CE
compilation, 11.2.3
creating database object, 11.2.1
developing applications, 11.2
packaging, 11.3
publishing, 11.3
using the Packaging Wizard, 11.3.1
writing application code, 11.2.2
winning rules, 3.8.2