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