Skip Headers
Oracle® Database Lite Developer's Guide
Release 10.3

Part Number E12090-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

Index

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

A

addMobileDMLProcedure API, 2.4.1.13
addPublicationItem method, 2.13.2.1
addSyncRule method, 2.4.1.4
ADF/BC4J
tutorial, 12
administration, 11.4, 13.3, 14.5
defining snapshot values, 11.4.5, 13.3.5
granting user access, 11.4.4, 13.3.4
setting properties, 11.4.3, 13.3.3
ADO.NET, 1.1, 2.8.3, 5.1.4
creating database for test, 5.1.4.2
synchronization, 5.1.4
testing application, 5.1.4.2
AfterSyncMapCleanup callback, 2.7.1.10
alterPublicationItem method, 2.4.1.7
API
admin API, 5.5.2.11
Mobile Sync, 4
usage, 1.5.2
applet
development, 5.5.2.6, 5.5.2.7
application
administration, 11.4, 13.3, 14.5
API, 1.5.2
building Web applications, 11
clean synchronization environment, 4.1.9
deployment, 1.1, 1.5.3
design, 1.5
steps, 1.5.1
development, 1.1, 1.1, 5.5, 5.5.2
applet, 5.5.2.7, 5.5.2.8
DSN, 5.1.1
Java, 5.3.1
Java servlets for Web-to-Go, 5.5.2.5
packaging wizard, 7.1
roles, 5.5.2.3
Web-to-Go, 5.5.1, 5.5.2.6, 11.1
workspace, 5.5.2.10
initiate synchronization, 4.1.8
installation steps, 1.2.3
managing snapshots, 2.3.1.1
model, 1.2
models, 1.3
packaging, 13.2.3
programmatic synchronization, 4.1
publish, 1.2.3, 1.5.3
create database account, 11.1.1.1
publishing, 1.1
register database, 3.2
scheduling to execute, 8
selective synchronization, 4.1.6, 4.2.8, 4.3.4, 4.4.5
supported interfaces, 1.1
supported Java functions, 5.3.1
testing, 5.5.2
using BC4J, 12.1.1
Web-to-Go, 5.5.2.1, 11.5, 13.4
debug, 5.5.2.9
Win32, 13
Windows CE, 14.1, 14.1.1
Application Development Framework, see ADF
apply phase
callback, 6.4
development, 2.13.1
apprepwizard script, 3.2.1
architecture, 1.2, 5.5.2
MGP, 1.2.4
Mobile Development Kit, 1.4
Mobile Server, 1.2.3
msync, 1.2.2
Oracle Lite database, 1.2.1.2
repository, 1.2.5
supported platforms, 9.1.1
authentication
external, 10.1
AUTO_COMMIT_COUNT parameter, 2.1.6
automatic synchronization
C APIs, 2.2.2.3.1
C# APIs, 2.2.2.3.2
C++ APIs, 2.2.2.3.1
client conflict resolution, 2.11.2
data event rules, 6.9.6
disable, 2.2.2, 2.2.2.2
enabling, 2.2
C APIS, 2.2.2.3.1
C# APIs, 2.2.2.3.2
C++ APIs, 2.2.2.3.1
Java APIs, 2.2.2.3.3
MDW, 6.4
event notification, 2.2.6
high priority, 2.2.4
Java APIs, 2.2.2.3.3
objects not synchronized, 2.1.3
publication item level, 2.2.1
publication rules, 6.9.6
retrieving status, 2.2.7, 2.2.7, 2.2.7
rules, 2.2.3
scheduling, 2.2.5
start, 2.2.2, 2.2.2.1
status, 2.2.7
stop, 2.2.2, 2.2.2.1

B

bandwidth
designing application, 1.5.1
BC4J, 12.1.1
overview, 12.1
tutorial, 12
BeforeSyncMapCleanup callback, 2.7.1.10
BGSyncControl class, 2.2.2.3.3
BGSyncMsg class, 2.2.6, 2.2.6
BLOB
synchronizing, 2.1.8

C

C API, 4.1
develop applications, 1.1
file-based synchronization, 4.1.11
get publication name, 4.1.4
setting HTTP parameters, 4.1.3.2
synchronization, 2.8.1
initialize environment, 4.1.2
C# API
file-based synchronization, 4.4.6
synchronization, 4.4
C++ API, 4.1
develop applications, 1.1
file-based synchronization, 4.1.11
get publication name, 4.1.4
programmatic synchronization, 4.1
setting HTTP parameters, 4.1.3.2
synchronization, 2.8.1
intialize environment, 4.1.2
callback
customization, 2.4.1.13
client
conflict resolution, 2.11.2
constraint, 2.10.6
device
delete, 3.1
executingDDL, 2.5
notification, 2.13.3
processing downloaded data, 2.1.6
subscribing to publications, 2.4.1.9
column
set default column options, 2.4.1.3
command
send, 1.2.3
commit
automatic commit count, 2.1.6
complete refresh, 2.1.4.2, 2.9.2
defined in MDW, 6.4
compose phase
callback, 6.4
development, 2.13.1
extend MyCompose, 2.6.1
notify clients, 2.13.3
condition rule, 2.2.3
conflict resolution
client, 2.11.2
overview, 1.3.1
synchronization rules, 6.9.2.1
conflict rules
defining, 2.4.1.7.1
Consolidator Manager, 2.13.2.1
API, 1.5.2
modifying publication item, 2.4.1.12
overview, 1.2.3
Consolidator Manager APIs, 2.4
ConsolidatorManager class, 8.1, 8.3
job creation API, 8.1
consperf utility
performance, 1.1
constraint
foreign key
client, 2.10.6
Mobile client, 2.10.6
CreateDatabase method, 5.1.4.2
createDataCollectionQueue method, 2.13.2.1
createPublication method, 2.13.2.1
createSyncRule method, 2.4.1.4

D

data
processing download on client, 2.1.6
requirements, 1.2
synchronization, 2.1.7
update, 2.1.7
Data Collection Queues, 2.13.2
data source
name creation, 5.1.1
database
client
creation, 2.1.1
objects
creating, 11.1.1, 14.2.1
register for application, 3.2
types, 1.2.1
datatypes
mapping, 3.8
DDL
adding to client, 2.5
definition, 7.1.9
dependencies, 6.7
debug
Web-to-Go, 5.5.2.9
dependency hint, 3.4.1
creating for publication item, 6.4
creating in MDW, 6.4.2
deployment
application, 1.1, 1.5.3
design
architecture, 1.1
overview, 1.5
development
architecture, 5.5.2
compiling, 11.1.2
interfaces
for object database development, 5.1
for relational database development, 5.1
JDBC, 5.1.2
ODBC, 5.1.3
SODA, 5.1
RDBMS, 5.1
registration, 11.3
device
delete, 3.1
management, 1.2.3
send command, 1.2.3
Device Manager
overview, 1.2.6
DML
callback, 6.9.2.1
callback customization, 2.4.1.13
PL/SQL procedure, 2.4.1.13, 2.11.3
doCompose method, 2.6.2.2
download_complete method
signature, 2.13.1.2
download_init method, 2.13.1
example, 2.13.1.2.2
signature, 2.13.1.2
DownloadInfo class method, 2.12.2
dropSyncRule method, 2.4.1.4.4

E

enqueue notification APIs, 2.2.5
error message
synchronization, 4.1.10
Error queue
synchronization, 2.1
event handler
C# API, 4.4.4
event rule, 2.2.3
execution model, 1.1

F

fast refresh, 2.1.4.1, 2.9.1
defined in MDW, 6.4
requirements, 6.4
virtual primary key, 6.11
file-based synchronization, 2.1.5
C API, 4.1.11
C# API, 4.4.6
C++ API, 4.1.11
Java API, 4.2.9
firewall
configure proxy information, 4.1.7
forced refresh, 2.1.4.4
foreign key
behavior, 1.3.2
constraint, 2.10.3.2, 2.15.1.3
client, 2.10.6
constraints, 2.15.1
violations, 2.15.1.1

G

generateMobileDMLProcedure API, 2.4.1.13, 2.11.3
getDownloadInfo method, 2.12.1
GetMessage method, 2.2.6
getMessage method, 2.2.6
getPublicationNames method, 2.4.1.4.1
getQueuPkg method, 2.13.1.4
GetStatus method, 2.2.7
getSyncRule method, 2.4.1.4.2
group
create, 1.2.3

H

high priority
automatic synchronization, 2.2.4
HTTP
setting parameters, 4.1.3.2

I

inconsistent datatype
SQL exception, 2.4.1.12
index
creating, 7.1.7.2
definition
import, 7.1.9.1
using, 1.5.1
In-Queue
synchronization, 2.1
installation
considerations, 1.1
INSTEAD OF Triggers, 3.4.2
interfaces
supported, 1.1
isSyncRuleModified method, 2.4.1.4.3

J

Java
API
file-based synchronization, 4.2.9
OSEException class, 4.3.5
OSESession class, 4.3.2
overview, 4.2.1, 4.3.1
Sync class, 4.2.2
SyncException class, 4.2.3
SyncOption class, 4.2.4
application
development, 5.3.1
development
environment, 5.3.2, 5.3.2
tools, 5.3.3
native application usage, 5.3.1
OSEProgressListener service, 4.3.3
support, 5.3.2
Windows CE
SyncParam settings, 4.2.5
SyncProgress listener service, 4.2.7
TransportParam parameters, 4.2.6
Java Server Pages, see JSPs
JDBC, 1.1
driver, 5.1.2
description, 5.1
used within applets, 5.5.2.7
JDeveloper
ADF/BC4J tutorial, 12
JDK
setting variables, 5.3.2.1
job
create using API, 8.1
create using APIs, 8.3
manage using APIs, 8.1
scheduling, 8
Job engine
Standalone, 8.2
start from API, 8.2
Job Scheduler, 8
separate thread from Mobile Server, 8.2
JobEngine class, 8.2
JSP
developing, 5.5.2.4

M

map
cleanup, 2.7.1.10
MAX_U_COUNT parameter, 2.7.1.10
MDK
Packaging Wizard, 1.4.2, 1.4.3
MDW
automatic synchronization, 6.4
create project, 6.2, 6.2
create publication, 2.4
create publication item, 6.4, 6.4
dependency hint, 6.4, 6.4.2
deploy publication, 6.13
overview, 1.4.2, 6.1
parent table hint, 6.4, 6.4.3
primary key hint, 6.4, 6.4.3
project, 1.4.2, 6.1
definition, 6.2
publication
creation, 6.9
publication item
creating SQL statement, 6.4.1
define refresh mode, 6.4
resource
loading into project, 6.8
script, 6.7
loading into project, 6.7.3
sequence, 6.6
test
publication, 6.12, 6.12
wizard, 6.3
member
batch initialization, 2.4.1.1.2
initialization, 2.4.1.1.2
member user
create, 2.4.1.1.2
memory
desiging application, 1.5.1
Message Generator and Processor, see MGP
metadata cache
reset, 2.4.1.7
MGP
apply phase, 1.2.4
callback, 6.4
applying changes to the database, 1.2.4
compose phase, 1.2.4
callback, 6.4
notify client, 2.13.3
composing transaction, 2.1
execution process, 2.1
overview, 1.2, 1.2.4
Mobile client
architecture, 1.1
constraint, 2.10.6
database, 1.2.1
execution model, 1.1
Oracle Lite database, 1.2.1.2
processing downloaded data, 2.1.6
synchronization, 11.5.3
C# API, 4.4
Mobile Database Workbench, see MDW
Mobile Development Kit, 1.4
mSQL, 1.4.1
Mobile Manager
application properties, 11.4.3, 13.3.3
overview, 1.1
start, 11.4.1
Mobile Server
configuration, 1.2.3
overview, 1.2.3
start, 11.4.1, 13.3.1
Mobile Sync API, 4
model
architecture, 1.1
execution, 1.1
msync
architecture, 1.2.2
synchronization, 1.2
MyCompose, 2.6
doCompose method, 2.6.2.2
extend, 2.6.1
needCompose method, 2.6.2.1
MyCompose class, 6.9.2.1
myProgressProc callback function, 4.1.8.1

N

native application
data source name, 5.1.1
development, 4, 5.2
saving user settings, 4.1.5
needCompose method, 2.6.2.1
not null fields
behavior, 1.3.2
notification
client, 2.13.3

O

OC4J, 1.2.3
ocDoSynchronize function
determine progress, 4.1.8.1
ocDoSynchronize method, 4.1.8
ocEnv class, 4.1.2
ocEnv structure, 4.1.3.1
ocGetLastError function, 4.1.10
ocGetPublication function, 4.1.4
ocGetPublication method, 4.1.4
ocSaveUserInfo function, 4.1.7
ocSaveUserInfor method, 4.1.5
ocSessionInit function, 4.1.2
ocSessionTerm method, 4.1.9
ocSetSyncOption function, 4.1.7
ocTransportEnv structure, 4.1.3.2
ODBC, 1.1
2.0 driver, 5.1.3
3.5 driver, 5.1.3
install, 5.1.3
development interfaces, 5.1.3
driver, 5.1.3
OID, 1.2.3
olGetSyncMsg method, 2.2.6
olGetSyncOptions method, 2.2.2.3.1
olGetSyncStatus method, 2.2.7
olSyncMsg class, 2.2.6
Oracle Application Development Framework, see ADF
Oracle Database Lite
application model and architecture, 1.2, 1.3
introduction, 1.1
Oracle Lite database, 1.2.1
architecture, 1.2.1.2
client, 1.2.1.2
OracleAS, 1.2.3
OracleEngine class
CreateDatabase method, 5.1.4.2
OracleSync class, 4.4, 4.4.6, 5.1.4
OSEException class, 4.3.5
OSEProgressListener interface, 4.3.3
OSESession class, 4.3.2
Out-Queue
synchronization, 2.1

P

packaging, 13.2.3
Packaging Wizard, 1.4.2, 1.4.3, 11.3, 13.2.3, 14.4.1
adding servlets, 7.1.4
database information, 7.1.5
defining application DDLs, 7.1.9
defining roles, 7.1.6
defining sequences, 7.1.8
defining snapshot, 7.1.7
editing application definition, 7.1.10
listing applications, 7.1.3
new application, 7.1.2
package application, 2.4
publish application, 2.4
starting, 7.1.11
parent table hint, 3.4.1
creating in MDW, 6.4.3
password
modify, 2.4.1.1.1
performance
considerations, 1.1
consperf utility, 1.1
scripts, 6.7
PL/SQL procedure
DML operations, 2.4.1.13, 2.11.3
primary key
behavior, 1.3.2
composite
query rule, 2.4.1.12
creating virtual, 6.11
hint
creating in MDW, 6.4.3
index, 2.4.1.6, 3.5.1
virtual, 3.5.2
privileges
setting, 3.7
project
MDW, create, 6.2
properties
setting, 11.4.3, 13.3.3
proxy
setting proxy information for synchronization, 4.1.7
publication
add publication item, 2.4.1.7
adding servlets, 7.1.4
altering, 2.4.1.7
associate
publication item, 6.9.2
resource, 6.9.5
script, 6.9.4
sequence, 6.9.3
automatic synchronization, 6.9.6
rule, 2.4.1.4
create, 2.4.1.2
APIs, 2.4
MDW, 2.4
create using MDW, 1.4.2, 6.1
creation, 1.5.3, 6.9
deploy, 6.13
import existing from repository, 6.10
overview, 1.2, 1.3
setting order execution for publication items, 6.9.2.1
specifying conflict resolution rules, 6.9.2.1
subscribing clients to, 2.4.1.9
test synchronization, 6.12
test using MDW, 6.12
use Quick Wizard, 6.3
publication item
add to publication, 2.4.1.7
altering, 2.4.1.7
associate with publication, 6.9.2
attach PL/SQL procedure, 2.4.1.13
automatic synchronization, 2.2.1
conflict resolution, 1.3.1
create, 2.4.1.3
APIs, 2.4
create using MDW, 6.4
creating SQL query, 6.4
creating SQL statement, 6.4.1
dependency hint, 6.4
DML procedure, 2.4.1.13
execution order, 6.9.2.1
import from repository, 6.10
modifying, 2.4.1.12
overview, 1.2, 1.3
queue-based, 2.13.1, 2.13.1.1, 2.13.1.3, 2.13.1.4, 6.4
create, 2.13.1.3
register package, 2.13.1.4
setting priority, 6.9.2.1
use Quick Wizard, 6.3
weight, 1.3.1
publishing
application, 1.1
create database objects, 11.1.1.2

Q

query
rule
composite primary key, 2.4.1.12
queue-based, 2.13.1.4
notify clients, 2.13.3
publication item, 2.13.1
create queues, 2.13.1.1
creation, 2.13.1.3
refresh, 2.1.4.3
defined in MDW, 6.4
replication, 2.13
queues
data collection, 2.13.2
involved in synchronization, 2.1

R

RDBMS
development interfaces, 5.1
read-only
snapshots, 2.3.1.1.1
refresh
complete, 2.1.4.2, 2.9.2
defined in MDW, 6.4
fast, 2.1.4.1, 2.9, 2.9.1
forced, 2.1.4.4
queue-based, 2.1.4.3
snapshot, 2.3.1.1.3
synchronization, 2.1.4
registerQueuePkg method, 2.13.1.4
removeSyncRule method, 2.4.1.4.4
repository
architecture, 1.2.5
resetCache method, 2.4.1.7
resource
associate with publication, 6.9.5
import from repository, 6.10
limitations, 1.5.1
loading into MDW project, 6.8
Resource Manager
API, 1.5.2
description, 1.2.3
Resource Manager APIs, 2.4
restricting predicate, 2.4.1.14, 2.4.1.14
role, 5.5.2.3
definition, 7.1.6
RuleInfo class, 2.4.1.4
rules
automatic synchronization, 2.2.3
publication, 2.4.1.4, 6.9.6
conflict, 2.4.1.7.1
Rules class, 2.4.1.4

S

scalability
designing application, 1.5.1
measures, 1.1
schema
change
primary key, 3.6.1
evolution, 3.6
script
adding to publication in MDW, 6.7
associate with publication, 6.9.4
DDL dependencies, 6.7
import from repository, 6.10
testing, 6.7.2
security
designing application, 1.5.1
measures, 1.1
sequence
associate with publication, 6.9.3
create, 2.4.1.8
creating in MDW, 6.6
defining, 7.1.8
definition, 6.6
import from repository, 6.10
import snapshot, 7.1.8.1
synchronization, 2.4.1.8
servlets
adding to publication, 7.1.4
development, 5.5.2.5
registering, 11.3
setDfltColOptions flag, 2.4.1.3
SetEventHandler method, 4.4.4
setSyncRuleParams method, 2.4.1.4
shared maps
grouping function to force sharing, 6.9.2.1
snapshot
defining, 7.1.7
definition, 1.3, 7.1.7.1
edit, 7.1.7.4
import, 7.1.7.3
import sequence, 7.1.8.1
index definition, 7.1.7.2
manage, 2.3.1.1
overview, 1.2, 1.3
read-only, 2.3.1.1.1, 6.9.2.1
refresh, 2.3.1.1.3
template, 11.4.5
template variables, 2.3.1.1.4
updatable, 2.3.1.1.2, 6.9.2.1
snapshot definitions
declarative, 2.3.1
programmatic, 2.3.2
SODA, 1.1
SQL exception
inconsistent datatypes, 2.4.1.12
SQLite
set default column options, 2.4.1.3
SQLite database, 1.2.1
overview, 1.2.1.1
SQLite Mobile client
overview, 1.2.1.1
Standalone Job engine, 8.2
stored procedures
description, 5.4
subscription
create, 1.2.3
instantiate, 2.4.1.10
overview, 1.2, 1.3
Symbian
application
development, 9.2
ODBC, 9.3.2
support, 1.1, 9
synchronization, 9.4
utility tools, 9.5.1
Sync class, 4.2.2
constructors, 4.2.2, 4.3.2, 4.4.1
public methods, 4.2.2, 4.3.2, 4.4.4
Sync Client
downloading data, 2.1, 2.1
Sync Server
execution process, 2.1
uploading data, 2.1
SyncEventArgs class, 4.4.4
SyncEventHandler class, 4.4.4
SyncException class, 4.2.3
constructors, 4.2.3, 4.3.5
public methods, 4.2.3, 4.3.5
synchronization
ADO.NET, 5.1.4
application
initiate, 4.1.8
automatic
C APIs, 2.2.2.3.1
C# APIs, 2.2.2.3.2
C++ APIs, 2.2.2.3.1
disable, 2.2.2.2
enabling, 2.2, 2.2.1
Java APIs, 2.2.2.3.3
overview, 2.1.3
start, 2.2.2.1
stop, 2.2.2.1
BLOB, 2.1.8
C API, 2.8.1
C++ API, 2.8.1
change password, 2.4.1.1.1
clean environment, 4.1.9
complete refresh
overview, 2.1.4.2
compose phase customization, 2.6
composing transaction, 2.1
conflicts, 2.11
DDL Operations, 3.5.1
defining
conflict rules, 2.4.1.7.1
publication items, 2.4.1.3.1
determine progress, 4.1.8.1
downloaded data processed, 2.1.6
DownloadInfo class, 2.12.2
downloading data, 2.1, 2.1
errors, 2.11, 6.9.2.1
execution steps, 2.1
extending MyCompose, 2.6.1, 2.6.2, 2.6.3, 2.6.4
fast refresh
overview, 2.1.4.1
file-based, 2.1.5, 4.1.11, 4.1.11, 4.2.9, 4.4.6
first, 1.2
forced refresh
overview, 2.1.4.4
getDownloadInfo method, 2.12.1
initiation, 1.2
Java API, 4.2.2
management, 1.2.3
manual
overview, 2.1.3
Mobile client, 11.5.3
no network, 2.1.5
overview, 2.1, 2.1
programmatic, 4.1
propagation, 2.1.7
PublicationSize class, 2.12.3
publish and subscribe model, 2.4
publishing synonyms, 3.3.1
queue-based refresh
overview, 2.1.4.3
queues, 2.1
refresh option, 2.1.4
remote database link support, 3.3, 3.3.2
retrieve error message, 4.1.10
selective, 4.2.8, 4.3.4, 4.4.5
separate databases, 3.2
sequences, 2.4.1.8
SQLite Java API, 4.3.2
subscribing users, 2.4.1.9
Sync Discovery API, 2.12
uploading data, 2.1
using APIs, 1.5.2, 2.8, 4.4
Windows CE, 14.6.2
SyncOption class, 4.2.4
constructors, 4.2.4
public methods, 4.2.4
SyncParam
settings, 4.2.5
SyncProgress
listener service, 4.2.7, 4.2.7, 4.2.7, 4.3.3, 4.3.3
synonym
publish, 3.3.1

T

tables
users sharing, 6.9.2.1
testing
applets, 5.5.2.8
roles, 5.5.2.3
Web-to-Go applets, 5.5.2.6
workplace, 5.5.2.10
TransportParam
parameters, 4.2.6
triggers
description, 5.4
troubleshooting
sequences, 2.4.1.8
synchronization conflicts, 2.11

U

unRegisterQueuePkg method, 2.13.1.4
upload_complete method, 2.13.1
example, 2.13.1.2.1
signature, 2.13.1.2
user
create, 1.2.3
APIs, 2.4.1.1
defining snapshot values, 11.4.5, 13.3.5
granting access, 1.1, 11.4.4, 13.3.4
management, 1.2.3
member
create, 2.4.1.1.2
operations, 1.2
provisioning, 1.5.3
subscribing, 2.4.1.9

V

view
fast refresh, 2.9
importing, 7.1.9.1
parent table hint, 6.4, 6.4.3
primary key hint, 6.4, 6.4.3
virtual primary key, 3.5.2
Visual Studio
versions for development, 1.6
Windows CE, 1.6

W

Web-to-Go
client installation, 11.5.1, 13.4.1
debug, 5.5.2.9
development, 5.5.1, 5.5.2.1, 11.1
get publication name, 4.1.4
install the client, 11.5.1, 13.4.1
servlet development, 5.5.2.5
using the Packaging Wizard, 11.3
weight
publication item
overview, 1.3.1
Win32
using the Packaging Wizard, 13.2.3
Visual Studio
version, 1.6
Windows CE
compilation, 14.2.3
creating database object, 11.1.1, 14.2.1
developing applications, 14.2
installing, 14.6.1
packaging, 11.3, 13.2.3, 14.4
publishing, 11.3, 13.2.3, 14.4
synchronizing, 14.6.2
using the Packaging Wizard, 14.4.1
Visual Studio
version, 1.6
writing application code, 14.2.2
Workspace
application, 5.5.2.10