Index

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

A

addPublicationItem method, 3.19.2.1

addSyncRule method, 3.4.1.4

ADF/BC4J

tutorial, 18

administration, 17.4, 19.3, 20.5

defining snapshot values, 17.4.5, 19.3.5

granting user access, 17.4.4, 19.3.4

setting properties, 17.4.3, 19.3.3

ADO.NET, 2.4.3

creating database for test, 13.1.7

testing application, 13.1.7

ADO.NET provider, 3.8.3, 13.1.4

classes, 13.1

creating commands, 13.1.3

DataReader.GetString method, 13.2.3

DbNull object, 13.2.3

establishing connections, 13.1.1

GetSchemaTable method, 13.2.1

large object support, 13.1.5

limitations, 13.2

OracleBlob class, 13.1.5

OracleCommand, 13.1.3

OracleConnection class, 13.1.1

performance, 13.1.4

synchronization, 13.1.6

thread safety, 13.2.4

transactions, 13.1.2

Advanced Encryption Standard, see AES

AES, see encryption

ALTER TABLE statement, 11.3.2.1, 11.3.2.5, 11.5.2.1

ALTER TRIGGER statement, 11.5.2.1

alterPublicationItem method, 3.4.1.7

application

administration, 17.4, 19.3, 20.5

Web-to-Go, 17.5, 19.4

application development, 6

Application Development Framework, see ADF

applications

building Web applications, 17

packaging, 19.2.3

apply callback, 5.4

apply phase

development, 3.19.1

architecture

Data Source name, 1.7

Java support, 1.6

MGP, 1.3.4

Mobile Development Kit, 1.5

Mobile Server, 1.3.3

msync, 1.3.2

Oracle Database Lite RDBMS, 1.3.1

repository, 1.3.5

automatic synchronization

data event rules, 5.9.6

disable, 3.2.2

enable

MDW, 5.4

event notification, 3.2.5

publication rules, 5.9.6

rules, 3.2.3

start, 3.2.2

status, 3.2.6

stop, 3.2.2

B

BC4J, 18.1.1

overview, 18.1

tutorial, 18

BGSyncMsg class, 3.2.5, 3.2.5

BLOB, 10.5.2, 10.5.2, 10.6

ADO.NET provider, 13.1.5

getting values, 10.5.3

query tables, 13.1.5.1

read and write data, 13.1.5.1

setting values, 10.5.3

using in parameterized SQL statements, 13.1.5.1

building applications

using BC4J, 18.1.1

Win32, 19

Windows CE, 20.1, 20.1.1

building Mobile applications

developing, 17.1

building Mobile Web applications, 17

C

C application

get publication name, 4.1.4

initiate synchronization, 4.1.8

programmatic synchronization, 4.1

selective synchronization, 4.1.6, 4.2.7

setting HTTP parameters, 4.1.3.2

synchronization

initialize environment, 4.1.2

C++ application

get publication name, 4.1.4

initiate synchronization, 4.1.8

programmatic synchronization, 4.1

example, 4.1

selective synchronization, 4.1.6, 4.2.7

setting HTTP parameters, 4.1.3.2

synchronization

intialize environment, 4.1.2

C++ stored procedure

access database, 11.8.1.2

JDBC, 11.8.4.3

C++ stored procedures, 11.8

building, 11.8.2

exceptions, 11.8.1.2

publish, 11.8.3

using ODBC, 11.8.1.2

using triggers, 11.8.4.1

call specifications

creating, 11.3.1.2, 11.6.5, 11.8.3, 11.9.3.2

sample, 11.3.1.2, 11.3.1.3, 11.3.1.3, 11.3.1.5, 11.8.3, 11.9.3.2

callable statement, 11.7.2

CallableStatement class, 11.7.2

Callback Customization for DML Operations, 3.4.1.13

Calling Published Stored Procedures, 11.3.1.3

C/C++ Interface, 3.8.1, 4.1

CDC

JDBC driver, 10.8.1

classes

loading with CREATE JAVA, 11.3.1.1.2

loading with loadjava, 11.3.1.1.1

CLDC

JDBC driver, 10.8.1

client

constraint, 3.11.6

device

delete, 3.20

notification, 3.19.3

clients

subscribing to publications, 3.4.1.9

CLOB, 10.5.2, 10.5.2, 10.6

getting values, 10.5.3

setting values, 10.5.3

close method, 10.5.3

complete refresh

defined in MDW, 5.4

Complete Refresh for Views, 3.9.2

compose

notify clients, 3.19.3

compose callback, 5.4

compose phase

development, 3.19.1

condition rule, 3.2.3

conflict resolution

synchronization rules, 5.9.2.1

Connect to Oracle Database Lite

Type 2 Driver Connection URL Syntax, 10.3.1

Type 4 (Pure Java) Driver Connection URL Syntax, 10.3.2

Connection objects, passed as arguments, 11.4.1

connections

ADO.NET provider, 13.1.1

Consolidator Manager

modifying publication item, 3.4.1.12

ConsolidatorManager, 3.19.2.1

constraint

foreign key

client, 3.11.6

Mobile client, 3.11.6

CREATE FUNCTION statement, 11.3.1.2, 11.8.3, 11.9.3.2

CREATE JAVA statement, 11.3.1.1.2, 11.3.1.1.2, 11.3.1.5

CREATE PROCEDURE statement, 11.3.1.2, 11.8.3, 11.9.3.2

CREATE TRIGGER statement, 11.5.2

CreateDatabase method, 13.1.7

createDataCollectionQueue method, 3.19.2.1

CREATEDB, A.2

syntax, A.2

createPublication method, 3.19.2.1

createStatement method, 11.7.1

createSyncRule method, 3.4.1.4

Creating a Dependency Hint, 3.12.1

Creme

DriverManager class, 10.8.2.2

J2ME, 10.8.2.2

cursors

restrictions with isolation levels, 15.4

D

Data Access Extensions

Reading from a BLOB Sample Program, 10.5.3.1

Writing to a CLOB Sample Program, 10.5.3.2

Data Collection Queues, 3.19.2

data source

creating name, 2.3.3.1

name creation, 8.2

database

accessing, 2.5.1.5

backing up, 2.7

building demo tables, 2.3.4.2

connecting, 2.3.3.3

creating, 2.3.3.2

encrypting and decrypting, 2.8

row-level locking, 15.1

starter, 2.3.2

database connection

verification using mSQL, 2.5.1.6

database objects

creating, 17.1.1, 20.2.1

DataReader object

limitations, 13.2.3

DataSource object, 10.4

datatypes, 10.5.1

Java, 11.4

mapping, 3.23

DBData, 11.8.1.1

DBException, 11.8.1.2

DBSession object, 11.8.1.2

DDL

dependencies, 5.7

DECRYPDB, A.5

decryption

database, 2.8

Defining Application DDLs

Importing Views and Index Definitions, 7.1.9.1

Defining Snapshots for Replication

Creating Indexes for Snapshots, 7.1.7.2

Creating New Snapshots, 7.1.7.1

Editing Snapshots, 7.1.7.4

Importing Sequences, 7.1.8.1

Importing Snapshots, 7.1.7.3

dependency hint

creating for publication item, 5.4

creating in MDW, 5.4.2

DETACH AND DELETE statement, 11.3.2.5

Developing and Testing the Application, 6.2

Developing Java Server Pages, 6.2.3

Developing Mobile Web Applications, 6.1

development

compiling, 17.1.2

registration, 17.3

Development and Testing

Building Web-to-Go Applications, 6.2.1

Customizing the Workplace Application, 6.2.9

Debugging Web-to-Go Applications, 6.2.8

Developing Applet JDBC Communication, 6.2.6

Developing Applet Servlet Communication, 6.2.7

Developing Java servlets for Web-to-Go, 6.2.4

Specifying Application Roles, 6.2.2

Using the Mobile Server Admin API, 6.2.10

Using Web-to-Go Applets, 6.2.5

Development Architecture, 6.2

development interfaces

for object database development, 2.4

for relational database development, 2.4

JDBC, 2.4.1

ODBC, 2.4.2

SODA, 2.4.4

device

delete, 3.20

DML

callback, 5.9.2.1

doCompose Method, 3.6.2.2

download_complete method

signature, 3.19.1.2

download_init method, 3.19.1

example, 3.19.1.2.2

signature, 3.19.1.2

DROP FUNCTION statement, 11.3.1.4.2

DROP JAVA statement, 11.3.1.4.2

DROP PROCEDURE statement, 11.3.1.4.2

DROP TRIGGER statement, 11.5.3

dropjava

arguments, 11.3.1.4.1

options, 11.3.1.4.1

specifying filenames to, 11.3.1.4.1

dropSyncRule method, 3.4.1.4.4

DSN

adding, A.7.1, A.7.2

creating, 2.5.1.4

E

Embedded Visual Tools, 20

encCreateCtxt method, 16.2.1.1

encCreateKey method, 16.2.1.3

encDecryptData method, 16.2.1.5

encDeleteCtxt method, 16.2.1.2

encEncryptData method, 16.2.1.4

ENCRYPDB, A.4, A.6

encryption

APIs, 16.2.1

create key, 16.2.1.3

database, 2.8

decrypt data, 16.2.1.5

delete encryption context, 16.2.1.2

encrypt data, 16.2.1.4

initializing custom module, 16.2.1.1

plug-in custom module, 16.2.2

provide custom module, 16.2

error message

synchronization, 4.1.10

Error queue

synchronization, 3.1.1

event rule, 3.2.3

executeQuery method, 11.7.1, 11.7.1

EXTERNAL_ENCRYPTION_DLL parameter, 16.2.2

F

fast refresh

defined in MDW, 5.4

requirements, 5.4

virtual primary key, 5.11

fast refresh and update, 3.9

Fast Refresh for Views, 3.9.1

firewall

configure proxy information, 4.1.7

flush method, 10.5.3

foreign key

constraint

client, 3.11.6

foreign key constraint, 3.11.3.2, 3.22.1.3

foreign key constraints, 3.22.1

violations, 3.22.1.1

G

getAsciiOutputStream, 10.5.2

getAsciiStream, 10.5.2

getBinaryOutputStream, 10.5.2

getBinaryStream, 10.5.2

getBLOB, 10.5.3

getBytes, 10.5.2

getCharacterOutputStream, 10.5.2

getCharacterStream, 10.5.2

getChars, 10.5.2

getCLOB, 10.5.3

getConnection, 10.5.2, 10.5.2

GetMessage method, 3.2.5

getMessage method, 3.2.5

getPublicationNames method, 3.4.1.4.1

getQueuPkg method, 3.19.1.4

GetSchemaTable method

returns partial data, 13.2.1

getSubString, 10.5.2

getSyncRule method, 3.4.1.4.2

H

HTTP

setting parameters, 4.1.3.2

I

IBM J9, 10.8.2.1

DataSource class, 10.8.2.1

inconsistent datatype

SQL exception, 3.4.1.12

In-Queue

synchronization, 3.1.1

INSTEAD OF Triggers, 3.12.2

Interface Connection

Methods, 10.7.1.1

Interface Database MetaData

Methods, 10.7.4.1

Methods that Return False, 10.7.4.2

Interface PreparedStatement

Methods, 10.7.6.1

Interface ResultMetaData

Methods, 10.7.5.1

Interface ResultSet

Fields, 10.7.3.1

Methods, 10.7.3.2

Methods that Return False, 10.7.3.3

isConvertibleTo, 10.5.2, 10.5.2

isolation level

configuration, 15.3

restrictions with cursors, 15.4

isolation level, transaction, 11.7.1

isolation levels, 15.2

isSyncRuleModified method, 3.4.1.4.3

J

J2ME

CDC

JDBC driver, 10.8.1

CLDC

JDBC driver, 10.8.1

Creme, 10.8.2.2

IBM J9, 10.8.2.1

support, 10.8

WinCE, 10.8.2

JAR files, loading, 11.3.1.1.1

Java

datatypes

declaring parameters, 11.4.1

example, 11.4.2.2

return multiple rows, 11.4.2

development environment, 9.2

native application usage, 9.1

non-static methods, 11.3.2

static methods, 11.3.2

Java Development Tools, 9.3

Java Interface SyncParam Settings

Example 1, 4.2.5

Example 2, 4.2.5

Java Interface TransportParam Parameters

Example, 4.2.6

Java Stored Procedure

publish, 11.6.5

Java stored procedure

create trigger, 11.6.9

start mSQL, 11.6.1

Java stored procedures, 11.3.3

calling, 11.3.2.4, 11.3.2.4

create Java Class, 11.6.3

create table, 11.6.2

development model, 11.3.2

dropping, 11.3.1.4, 11.3.2.5

example, 11.3.1.5

Java datatypes, 11.4

JDBC, 11.7, 11.7.1, 11.7.2

load Java class, 11.6.4

ODBC, 11.3.3

publishing to SQL, 11.6.5

return multiple rows, 11.4.2.1

row-level, 11.3.2.3

SELECT statement, 11.3.2.4

table-level, 11.3.2.2

tutorial, 11.6

using dropjava, 11.3.1.4.1

using SQL Commands, 11.3.1.4.2

using triggers, 11.5

Java Stored Procedures (JSPs), see JSP

Java Stored Procedures and Triggers, 11.1, 11.2

Java Support on Windows CE

Java Interface SyncParam Settings, 4.2.5

Java Interface TransportParam Parameters, 4.2.6

Overview, 4.2.1

Sync Class, 4.2.2

SyncException Class, 4.2.3

SyncOption Class, 4.2.4

SyncProgress Listener Service, 4.2.8

Java Virtual Machine (JVM), 11.2.1, 11.3.2.5, 11.3.3, 11.6.4

JDBC

calling C++ stored procedure, 11.8.4.3

description, 10

extensions, 10.5

J2ME, 10.8.1

Java stored procedures, 11.7

using DataSource, 10.4

JDBC driver, 2.4.1

description, 2.4.1

JDBC Programming

Connect to Oracle Database Lite, 10.3

JDBC Compliance, 10.1

JDBC Environment Setup, 10.2

Limitations, 10.6

New JDBC 2.0 Features, 10.7

Oracle Database Lite Extensions, 10.5

JDeveloper

ADF/BC4J tutorial, 18

JDK

setting variables, 9.2.1

JSP

load, 11.3.1

loading classes, 11.3.1.1

publish, 11.3.1

publishing, 11.3.1.2

triggers, 11.3

using, 11.3

jvm.dll, 11.3.3

L

length method, 10.5.2, 10.5.2

linguistic sort, 2.10

Load APIs, 2.6, A.10.2.1

Load utility

overview, A.10.1

Load Utility (OLLOAD), 2.6.2

JAR files, 11.3.1.1.1

ZIP files, 11.3.1.1.1

loadjava, 11.3.1.1.1, 11.3.1.1.1

options, 11.3.1.1.1

specifying filenames to, 11.3.1.1.1

syntax, 11.3.1.1.1

locking

row-level, 15.1

M

makeJdbcArray, 10.5.2, 10.5.2

mark method, 10.5.3

markSupported method, 10.5.3

MDK

Packaging Wizard, 1.5.2, 1.5.3

MDW

automatic synchronization, 5.4

create project, 5.2

create publication item, 5.4

dependency hint, 5.4, 5.4.2

deploy publication, 5.13

overview, 1.5.2, 5.1

parent table hint, 5.4, 5.4.3

primary key hint, 5.4, 5.4.3

project, 1.5.2, 5.1

definition, 5.2

Project Wizard, 5.2

publication

creation, 5.9

publication item

creating SQL statement, 5.4.1

define refresh mode, 5.4

Publication Item Wizard, 5.4

Quick Wizard, 5.3

resource

loading into project, 5.8

script, 5.7

loading into project, 5.7.3

sequence, 5.6

test publication, 5.12

test publication synchronization, 5.12

Message Generator and Processor (MGP), 1.3.4

metadata cache

reset, 3.4.1.7

MGP

apply callback, 5.4

apply phase, 1.3.4

applying changes to the database, 1.3.4

compose

notify client, 3.19.3

compose callback, 5.4

compose phase, 1.3.4

composing transaction, 3.1.1

execution process, 3.1.1

Mobile client

constraint, 3.11.6

synchronizing, 17.5.3

Mobile Database Workbench, see MDW

Mobile Development Kit, 1.5

mSQL, 1.5.1

Mobile Manager

application properties, 17.4.3, 19.3.3

Mobile Server

overview, 1.3.3

mSQL, A.1, A.1

SET TERM {ON|OFF}, A.1.1.3

SET TIMING {ON|OFF}, A.1.1.4

SET VERIFY {ON|OFF}, A.1.1.5

starting, A.1.1.1, A.1.2.2.1

verifying database connection, 2.5.1.6

Windows 32, A.1.1

Windows CE, A.1.2.2

populating database, A.1.1.2

msync

architecture, 1.3.2

MSync/OCAPIs/mSyncCom, 4.3

multithreaded programs

Java stored procedures, 11.3.3

MyCompose, 3.6

doCompose, 3.6.2.2

needCompse Method, 3.6.2.1

MyCompose class, 5.9.2.1

myProgressProc callback function, 4.1.8.1

N

naming stored procedures, 11.2.1

native application

data source name, 8.2

development, 4, 8

saving user settings, 4.1.5

supported Java functions, 9.1

Native Application Development

Data Source Name, 8.2

Java Support, 9.1

Using the Packaging Wizard, 7.1

native applications

clean synchronization environment, 4.1.9

selective synchronization, 4.1.6, 4.2.7

needCompose Method, 3.6.2.1

.Net stored procedures, 11.9

New JDBC 2.0 Features

Interface Connection, 10.7.1

Interface Database MetaData, 10.7.4

Interface PreparedStatement, 10.7.6

Interface ResultMetaData, 10.7.5

Interface ResultSet, 10.7.3

Interface Statement, 10.7.2

notification

client, 3.19.3

O

OCBC Administrator, 2.3.3.1

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

adding DSN, A.7.1, A.7.2

administration, A.7

development interfaces, 2.4.2

Java stored procedures, 11.3.3

ODBC driver, 2.4.2

description, 2.4.2

odbc.ini

location, 2.3.3.1.1

ODBINFO, A.8

olcSPGetObject method, 11.8.1.2

olCSPGetSession method, 11.8.1.2

OLDEV039|JDBC, 2.4.1

olGetSyncMsg method, 3.2.5

olSyncMsg class, 3.2.5

Oracle Application Development Framework, see ADF

Oracle Database Lite

application model and architecture, 1.3

introduction, 1.1

Oracle Database Lite Extensions

Data Access Extensions, 10.5.3

Datatype Extensions, 10.5.2

Oracle Database Lite Java Support

Oracle Database Lite Java Development Environment, 9.2

Oracle Database Lite Support

Java Datatypes, 10.5.1

OracleBlob class, 13.1.5

OracleCommand class, 13.1.3

OracleConnection class, 13.1.1

OracleData, 11.9.1, 11.9.1.2.1

OracleDataRow, 11.9.1, 11.9.1.2.2

OracleEngine class

CreateDatabase method, 13.1.7

OracleParameter class

ADO.NET provider

PreparedStatement class, 13.1.4

OracleResultSet class, 10.5.3

OracleSPManager, 11.9.1, 11.9.1.3

OracleSync class, 13.1.6

Out-Queue

synchronization, 3.1.1

P

packaging, 19.2.3

Packaging Wizard, 1.5.2, 1.5.3, 17.3, 19.2.3, 20.4.1

parameters, stored procedures, 11.7.2

parent table hint

creating in MDW, 5.4.3

performance

ADO.NET provider, 13.1.4

scripts, 5.7

POLClobReader class, 10.5.3

POLClobWriter class, 10.5.3

POLJDBCDataSource object., 10.4

POLLobInputStream class, 10.5.3

POLLobOutputStream class, 10.5.3

PreparedStatement class, 11.7.1, 13.1.4

primary key

composite

query rule, 3.4.1.12

creating virtual, 5.11

primary key hint

creating in MDW, 5.4.3

primary key index, 3.4.1.6, 3.14.1

privileges

setting, 3.16

Programming interfaces

C /C++, 3.8.1, 4.1

project

MDW, create, 5.2

properties

setting, 17.4.3, 19.3.3

Provisioning Mobile Applications

Managing Snapshots, 3.3.1.1

proxy

setting proxy information for synchronization, 4.1.7

publication

add publication item, 3.4.1.7

altering, 3.4.1.7

associate publication item, 5.9.2

associate resource, 5.9.5

associate script, 5.9.4

associate sequence, 5.9.3

automatic synchronization, 5.9.6

rule, 3.4.1.4

create using MDW, 1.5.2, 5.1

creation, 5.9

deploy, 5.13

import existing from repository, 5.10

setting order execution for publication items, 5.9.2.1

specifying conflict resolution rules, 5.9.2.1

test synchronization, 5.12

test using MDW, 5.12

use Quick Wizard, 5.3

publication item

add to publication, 3.4.1.7

altering, 3.4.1.7

associate with publication, 5.9.2

create using MDW, 5.4

creating SQL query, 5.4

creating SQL statement, 5.4.1

dependency hint, 5.4

execution order, 5.9.2.1

import from repository, 5.10

modifying, 3.4.1.12

queue-based, 3.19.1

create, 3.19.1.3

setting priority, 5.9.2.1

use Quick Wizard, 5.3

publications

subscribing clients to, 3.4.1.9

publish applications

create database account, 17.1.1.1

publishing application

create database objects, 17.1.1.2

publishing applications

start the Mobile Server, 17.4.1, 19.3.1

publishing stored procedures, 11.6.5

putBytes, 10.5.2

putChars, 10.5.2

putString, 10.5.2

Q

query

rule

composite primary key, 3.4.1.12

querying

in JDBC, 11.7.1

Queue Interface, 3.19

queue-based

notify clients, 3.19.3

queue-based publication item, 3.19.1

create queues, 3.19.1.1

creation, 3.19.1.3

queue-based refresh

defined in MDW, 5.4

queues

data collection, 3.19.2

involved in synchronization, 3.1.1

R

RDBMS

creating multiple users, 2.3.4

development interfaces, 2.4

linguistic sort, 2.10

Read-Only Snapshots, 3.3.1.1.1

ready method, 10.5.3

Refresh

complete, 3.9.2

fast, 3.9.1

refresh mode

defined in MDW, 5.4

Refreshing a Snapshot, 3.3.1.1.3

registerQueuePkg method, 3.19.1.4

REMOVEDB, A.3

removeSyncRule method, 3.4.1.4.4

repository

architecture, 1.3.5

reset method, 10.5.3

resetCache method, 3.4.1.7

resource

associate with publication, 5.9.5

import from repository, 5.10

loading into MDW project, 5.8

Restricting Predicate, 3.4.1.14

restricting predicate, 3.4.1.14

resume

client configuration, 3.10.3

synchronization, 3.10

RESUME_BLOCKSIZE parameter, 3.10.1

RESUME_CLIENT_MAXSEND parameter, 3.10.3

RESUME_CLIENT_TIMEOUT parameter, 3.10.3

RESUME_FILE parameter, 3.10.1

RESUME_FILE_SIZE parameter, 3.10.1

RESUME_MAXACTIVE parameter, 3.10.2

RESUME_MAXCHUNK parameter, 3.10.2

RESUME_TIMEOUT parameter, 3.10.2

row-level triggers, 11.2

rule

automatic synchronization

publication, 3.4.1.4

RuleInfo class, 3.4.1.4

rules

automatic synchronization, 3.2.3

publication, 5.9.6

Rules class, 3.4.1.4

S

schema

evolution, 3.15

schema object names, 11.3.1.1.1

script

adding to publication in MDW, 5.7

associate with publication, 5.9.4

DDL dependencies, 5.7

import from repository, 5.10

testing, 5.7.2

SELECT statement

Java stored procedures, 11.3.2.4

sequence

associate with publication, 5.9.3

creating in MDW, 5.6

definition, 5.6

import from repository, 5.10

sequences

synchronization, 3.4.1.8

server

controlling load, 3.10.2

set max connections, 3.10.2

servlets

registering, 17.3

setSyncRuleParams method, 3.4.1.4

shared maps

grouping function to force sharing, 5.9.2.1

skip method, 10.5.3

snapshot

read-only, 5.9.2.1

updatable, 5.9.2.1

snapshot definitions

declarative, 3.3.1

programmatic, 3.3.2

Snapshot Template Variables, 3.3.1.1.4

SODA

access database, 11.8.1.2

C++ stored procedures, 11.8.1

SQL

parsing in ADO.NET provider, 13.1.4

using mSQL, A.1

SQL exception

inconsistent datatypes, 3.4.1.12

SQLDescribeCol, 11.4.2.1, 11.4.2.2

SQLNumResultCols, 11.4.2.1, 11.4.2.2

statement-level triggers, 11.2

stored procedures

C++, 11.8

calling, 11.7.2

description, 11.2

naming, 11.2.1

.Net, 11.9

sychronization

conflicts, 3.13

Symbian

application development, 14.1

J2ME, 10.8.1

ODBC, 14.2.1

support, 14

synchronization, 14.2

utility tools, 14.4

Sync Class

Constructors, 4.2.2

Public Methods, 4.2.2

Sync Client

downloading data, 3.1.1, 3.1.1

Sync Server

execution process, 3.1.1

uploading data, 3.1.1

SyncException Class

Constructors, 4.2.3

Public Methods, 4.2.3

synchonization

retrieve error message, 4.1.10

Synchronization

Change Password, 3.4.1.1.1

Client Device Database DDL Operations, 3.5, 3.14.1

Defining Conflict Rules, 3.4.1.7.1

Defining Publication Items, 3.4.1.3.1

DownloadInfo Class Access Methods, 3.18.2

Extending MyCompose, 3.6.3

Extending MyCompose as a User Defined Sub-Class, 3.6.1, 3.6.2, 3.6.4

getDownloadInfo Method, 3.18.1

PublicationSize Class, 3.18.3

Publish and Subscribe Model, 3.4

Publishing Synonyms, 3.17.1

Remote Database Link Support, 3.17, 3.17.2

Sync Discovery API, 3.18

synchronization

ADO.NET provider, 13.1.6

C applications, 4.1

C++ applications, 4.1

clean environment, 4.1.9

compose phase customization, 3.6

composing transaction, 3.1.1

controlling server load, 3.10.2

downloading data, 3.1.1, 3.1.1

errors, 3.13, 5.9.2.1

execution steps, 3.1.1

native applications

initiate, 4.1.8

queues, 3.1.1

resuming interrupted, 3.10

selective, 4.1.6, 4.2.7

sequences, 3.4.1.8

subscribing users, 3.4.1.9

temporary data storage, 3.10.1

uploading data, 3.1.1

using APIs, 3.8

synchronize

determine progress, 4.1.8.1

synchronizing

Mobile client, 17.5.3

WinCE, 20.6.2

SyncOption Class

Constructors, 4.2.4

Example, 4.2.4

Public Methods, 4.2.4

SyncProgress Listener Service

Example, 4.2.8

Method, 4.2.8

T

table

attaching a Java class, 11.3.2.1

tables

building, 2.3.4.2

users sharing, 5.9.2.1

thread safety

ADO.NET provider, 13.2.4

threads

invoking Java stored procedures, 11.3.3

toJdbc method, 10.5.2, 10.5.2

transactions, 15

ADO.NET provider, 13.1.2

configuring isolation level, 15.3

isolation levels, 11.7.1, 15.2

locking, 15.1, 15.1

trigger

testing, 11.6.9.1

triggers

arguments, 11.5.5

example, 11.5.6

creating, 11.5.2, 11.6.9

description, 11.2

dropping, 11.5.3

enabling and disabling, 11.5.2.1

example, 11.5.4

row-level, 11.2

statement-level, 11.2

statement-level vs. row-level, 11.5.1

using C++ stored procedures, 11.8.4.1

troubleshooting

sequences, 3.4.1.8

synchronization conflicts, 3.13

truncate command, A.10.2.2.3

U

unRegisterQueuePkg method, 3.19.1.4

Updatable Snapshots, 3.3.1.1.2

upload_complete method, 3.19.1

example, 3.19.1.2.1

signature, 3.19.1.2

user

granting access, 17.4.4, 19.3.4

subscribing, 3.4.1.9

users

defining snapshot values, 17.4.5, 19.3.5

Using the Packaging Wizard for Web Applications

Adding Servlets, 7.1.4

Defining Application DDLs, 7.1.9

Defining Application Roles, 7.1.6

Defining Sequences for Replication, 7.1.8

Defining Snapshots for Replication, 7.1.7

Editing Applications, 7.1.10

Entering Database Information, 7.1.5

Listing Application Files, 7.1.3

Naming New Applications, 7.1.2

Starting the Packaging Wizard, 7.1.11

V

VALIDATEDB, A.9

view

parent table hint, 5.4.3

primary key hint, 5.4.3

specifying parent table hint, 5.4

specifying primary key hint, 5.4

views

fast refresh and update, 3.9

Virtual Primary Key, 3.14.2

Visual Studio

versions for development, 1.2

WinCE, 1.2

W

Web-to-Go

get publication name, 4.1.4

install the client, 17.5.1, 19.4.1

using the Packaging Wizard, 17.3

Web-to-go

client installation, 17.5.1, 19.4.1

Win32

using the Packaging Wizard, 19.2.3

Visual Studio

version, 1.2

WinCE

installing, 20.6.1

J2ME, 10.8.2

synchronizing, 20.6.2

Visual Studio

version, 1.2

Windows CE

compilation, 20.2.3

creating database object, 17.1.1, 20.2.1

developing applications, 20.2

packaging, 17.3, 19.2.3, 20.4

publishing, 17.3, 19.2.3, 20.4

using the Packaging Wizard, 20.4.1

writing application code, 20.2.2

write method, 10.5.3, 10.5.3

Z

ZIP files, loading, 11.3.1.1.1