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

Previous
Previous
 

Index

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

A

ALTER TABLE statement, 4.3.2.1, 4.3.2.5, 4.5.2.1
ALTER TRIGGER statement, 4.5.2.1
Application Development
Oracle Database Lite Support, 2.1
Application Development Overview
Develop the Application, 1.2.2
Package the Application, 1.2.3
Publish the Application, 1.2.4
Test the Application, 1.2.5
Application Development Steps Overview
Setup Enterprise Data Subset Definition, 1.2.1
Attaching a Java Class to a Table, 4.3.2.1

B

BLOB, 3.5.1, 3.5.1, 3.6
getting values, 3.5.2
setting values, 3.5.2

C

call specifications
creating, 4.3.1.2, A.1.5
sample, 4.3.1.2, 4.3.1.3, 4.3.1.3, 4.3.1.5
CallableStatement class, 3.4.2
Calling Attached Stored Procedures, 4.3.2.4
Calling Published Stored Procedures, 4.3.1.3
calling stored procedures, 4.3.3
CLOB, 3.5.1, 3.5.1, 3.6
getting values, 3.5.2
setting values, 3.5.2
close method, 3.5.2
Configuring the Development System, 1.3
Configure the Mobile Server, 1.3.4
Install and Configure the Oracle Database or Enterprise Server, 1.3.2
Install the Mobile Development Kit, 1.3.5
Install the Mobile Server, 1.3.3
Java Development Kit (JDK), 1.3.1
Connect to Oracle Database Lite
Type 2 Client/Server Driver Connection URL Syntax, 3.3
Type 2 Driver Connection URL Syntax, 3.3
Type 4 (Pure Java) Driver Connection URL Syntax, 3.3
Connection objects, passed as arguments, 4.4.1
Create a Trigger
Testing the Trigger, A.2.1
Verify the Email Address, A.2.2
CREATE FUNCTION statement, 4.3.1.2
CREATE JAVA statement, 4.3.1.1.2, 4.3.1.1.2, 4.3.1.5
CREATE PROCEDURE statement, 4.3.1.2
CREATE TRIGGER statement, 4.5.2
createStatement method, 3.4.1
Creating a Stored Procedure and Trigger
Create a Java Class, A.1.3
Create a Table, A.1.2
Load the Java Class File, A.1.4
Start MSQL, A.1.1
Creating Triggers
Enabling and Disabling Triggers, 4.5.2.1

D

Data Access Extensions
Reading from a BLOB Sample Program, 3.5.2.1
Writing to a CLOB Sample Program, 3.5.2.2
datatypes, 2.1.1
DETACH AND DELETE statement, 4.3.2.5
Developing and Testing the Application, 2.3
DROP FUNCTION statement, 4.3.1.4.2
DROP JAVA statement, 4.3.1.4.2
DROP PROCEDURE statement, 4.3.1.4.2
DROP TRIGGER statement, 4.5.3
dropjava, 2.1.2.1
arguments, 4.3.1.4.1
options, 4.3.1.4.1
specifying filenames to, 4.3.1.4.1
Dropping Attached Stored Procedures, 4.3.2.5
Dropping Published Stored Procedures, 4.3.1.4
Using dropjava, 4.3.1.4.1
Using SQL Commands, 4.3.1.4.2
dropping stored procedures, 2.1.2.1, 4.3.1.4.1

E

Environment Setup
Setting Variables for JDK 1.3.1, 2.1.3.1
executeQuery method, 3.4.1
Executing Java Stored Procedures from JDBC
Using a Callable Statement, 3.4.2
Using the executeQuery Method, 3.4.1

F

flush method, 3.5.2
force, loadjava option, 4.3.1.1.1

G

getAsciiOutputStream, 3.5.1
getAsciiStream, 3.5.1
getBinaryOutputStream, 3.5.1
getBinaryStream, 3.5.1
getBLOB, 3.5.2
getBytes, 3.5.1
getCharacterOutputStream, 3.5.1
getCharacterStream, 3.5.1
getChars, 3.5.1
getCLOB, 3.5.2
getConnection, 3.5.1, 3.5.1
getSubString, 3.5.1

I

Interface Connection
Methods, 3.7.1.1
Interface Database MetaData
Methods, 3.7.4.1
Methods that Return False, 3.7.4.2
Interface PreparedStatement
Methods, 3.7.6.1
Interface ResultMetaData
Methods, 3.7.5.1
Interface ResultSet
Fields, 3.7.3.1
Methods, 3.7.3.2
Methods that Return False, 3.7.3.3
isConvertibleTo, 3.5.1, 3.5.1
isolation level, transaction, 3.4.1

J

JAR files, loading, 4.3.1.1.1
Java
non-static methods, 4.3.2
static methods, 4.3.2
Java Datatypes
Declaring Parameters, 4.4.1
Example, 4.4.2.2
Using Stored Procedures to Return Multiple Rows, 4.4.2
Java Development Tools, 2.2
Java Interface SyncParam Settings
Example 1, 5.5
Example 2, 5.5
Java Interface TransportParam Parameters
Example, 5.6
Java Samples Overview
JDBC Sample, B.1.1
Java Stored Procedures and Triggers, 4.1, 4.2
Java Datatypes, 4.4
Using Stored Procedures, 4.3
Using Triggers, 4.5
Java Support on Windows CE
Java Interface SyncParam Settings, 5.5
Java Interface TransportParam Parameters, 5.6
Overview, 5.1
Sync Class, 5.2
SyncException Class, 5.3
SyncOption Class, 5.4
SyncProgress Listener Service, 5.7
Java Tools
loadjava, 2.1.2.1
Java Virtual Machine (JVM), 4.2, 4.3.2.5, 4.3.3, A.1.4
JDBC
description, 3
extensions, 3.5
JDBC Programming
Connect to Oracle Database Lite, 3.3
Executing Java Stored Procedures from JDBC, 3.4
JDBC Compliance, 3.1
JDBC Environment Setup, 3.2
Limitations, 3.6
New JDBC 2.0 Features, 3.7
Oracle Database Lite Extensions, 3.5
JDBC Sample
Java Stored Procedures Sample, B.1.3
PL/SQL Conversion to Java Samples, B.1.2
jvm.dll, 4.3.3

L

length method, 3.5.1, 3.5.1
Load the Java Class File
Execute the Procedure, A.1.7
Populate the Database, A.1.6
Publish the Stored Procedure, A.1.5
Verify the Email Address, A.1.8
loading
classes, 2.1.2.1, 4.3.1.1
JAR files, 4.3.1.1.1
ZIP files, 4.3.1.1.1
Loading Classes, 4.3.1.1
loadjava, 4.3.1.1.1
Using CREATE JAVA, 4.3.1.1.2
loadjava, 2.1.2.1, 4.3.1.1.1
options, 4.3.1.1.1, 4.3.1.1.1
specifying filenames to, 4.3.1.1.1
Syntax, 4.3.1.1.1

M

makeJdbcArray, 3.5.1, 3.5.1
mark method, 3.5.2
markSupported method, 3.5.2
MSync/OCAPIs/mSyncCom, 2.6
multithreaded programs, calling stored procedures from, 4.3.3

N

naming stored procedures, 4.2
New JDBC 2.0 Features
Interface Connection, 3.7.1
Interface Database MetaData, 3.7.4
Interface PreparedStatement, 3.7.6
Interface ResultMetaData, 3.7.5
Interface ResultSet, 3.7.3
Interface Statement, 3.7.2

O

Oracle Database Lite
Sample Programs, B.1
Oracle Database Lite Extensions
Data Access Extensions, 3.5.2
Datatype Extensions, 3.5.1
Oracle Database Lite Java Development Environment
Environment Setup, 2.1.3.1
Oracle Database Lite Java Support
Oracle Database Lite Java Development Environment, 2.1.3
Oracle Database Lite Support
Java Datatypes, 2.1.1
Java Tools, 2.1.2
OracleResultSet class, 3.5.2
Overview
Application Development Steps Overview, 1.2
Concepts, 1.1

P

Packaging the Application, 2.4
parameters, stored procedures, 3.4.2
POLClobReader class, 3.5.2
POLClobWriter class, 3.5.2
POLLobInputStream class, 3.5.2
POLLobOutputStream class, 3.5.2
PreparedStatement class, 3.4.1
Publishing Stored Procedures, 4.3.1.2
publishing stored procedures, A.1.5
putBytes, 3.5.1
putChars, 3.5.1
putString, 3.5.1

Q

querying
in JDBC, 3.4.1

R

ready method, 3.5.2
reset method, 3.5.2
Row-Level Stored Procedures, 4.3.2.3
row-level triggers, 4.2
Running the Samples
Running the Java Stored Procedures Sample, B.2.3
Running the JDBC Sample, B.2.1
Running the PL/SQL Conversion Samples, B.2.2

S

Sample Programs
Java Samples Overview, B.1
Running the Samples, B.2
schema object names, 4.3.1.1.1
SELECT statement, calling stored procedures, 4.3.2.4
Setup Enterprise Data Subset Definition
Creating Application Subscriptions, 1.2.1
Generating Database Schema, 1.2.1
Packaging Applications, 1.2.1
Provisioning Applications to Users, 1.2.1
skip method, 3.5.2
SQLDescribeCol, 4.4.2.1, 4.4.2.2
SQLNumResultCols, 4.4.2.1, 4.4.2.2
statement-level triggers, 4.2
Stored Procedure Tutorial
Commit or Roll Back, A.3
Create a Trigger, A.2
Creating a Stored Procedure and Trigger, A.1
stored procedures
calling, 3.4.2, 4.3.2.4
description, 4.2
dropping, 2.1.2.1, 4.3.2.5
example, Preface, 4.3.1.5, A
naming, 4.2
publishing to SQL, A.1.5
Sync Class
Constructors, 5.2
Example, 5.2
Public Methods, 5.2
SyncException Class
Constructors, 5.3
Public Methods, 5.3
SyncOption Class
Constructors, 5.4
Example, 5.4
Public Methods, 5.4
SyncProgress Listener Service
Example, 5.7
Method, 5.7

T

Table-Level Stored Procedures, 4.3.2.2
Testing, 2.5
threads, calling stored procedures from multiple, 4.3.3
toJdbc method, 3.5.1, 3.5.1
tools
development, 2.1.3
transactions
isolation levels, 3.4.1
triggers
creating, A.2
description, 4.2
example, Preface, A
row-level, 4.2
statement-level, 4.2

U

Using Stored Procedures, 4.3.2
Calling Java Stored Procedures from ODBC, 4.3.3
Load and Publish, 4.3.1
Using Stored Procedures to Return Multiple Rows, 4.4.2.1
Using Triggers
Creating Triggers, 4.5.2
Dropping Triggers, 4.5.3
Statement-Level vs. Row-Level Triggers, 4.5.1
Trigger Arguments, 4.5.5
Trigger Arguments Example, 4.5.6
Trigger Example, 4.5.4

V

verbose, loadjava option, 4.3.1.1.1

W

write method, 3.5.2, 3.5.2

Z

ZIP files, loading, 4.3.1.1.1