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

Next
Next
 

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience
Documentation Accessibility
Structure

1 Overview

1.1 Concepts
1.2 Application Development Steps Overview
1.2.1 Setup Enterprise Data Subset Definition
1.2.2 Develop the Application
1.2.3 Package the Application
1.2.4 Publish the Application
1.2.5 Test the Application
1.3 Configuring the Development System
1.3.1 Java Development Kit (JDK)
1.3.2 Install and Configure the Oracle Database or Enterprise Database
1.3.3 Install the Mobile Server
1.3.4 Configure the Mobile Server
1.3.5 Install the Mobile Development Kit

2 Application Development

2.1 Oracle Database Lite Java Support
2.1.1 Java Datatypes
2.1.2 Java Tools
2.1.2.1 loadjava
2.1.3 Oracle Database Lite Java Development Environment
2.1.3.1 Environment Setup
2.2 Java Development Tools
2.3 Developing and Testing the Application
2.4 Packaging the Application
2.5 Testing
2.6 MSync/OCAPIs/mSyncCom

3 JDBC Programming

3.1 JDBC Compliance
3.2 JDBC Environment Setup
3.3 Connect to Oracle Database Lite
3.4 Executing Java Stored Procedures from JDBC
3.4.1 Using the executeQuery Method
3.4.2 Using a Callable Statement
3.5 Oracle Database Lite Extensions
3.5.1 Datatype Extensions
3.5.2 Data Access Extensions
3.5.2.1 Reading from a BLOB Sample Program
3.5.2.2 Writing to a CLOB Sample Program
3.6 Limitations
3.7 New JDBC 2.0 Features
3.7.1 Interface Connection
3.7.1.1 Methods
3.7.2 Interface Statement
3.7.3 Interface ResultSet
3.7.3.1 Fields
3.7.3.2 Methods
3.7.3.3 Methods that Return False
3.7.4 Interface Database MetaData
3.7.4.1 Methods
3.7.4.2 Methods that Return False
3.7.5 Interface ResultMetaData
3.7.5.1 Methods
3.7.6 Interface PreparedStatement
3.7.6.1 Methods

4 Java Stored Procedures and Triggers

4.1 New Features in Oracle Database Lite
4.2 Stored Procedures and Triggers Overview
4.3 Using Stored Procedures
4.3.1 Model 1: Using the Load and Publish Stored Procedure Development Model
4.3.1.1 Loading Classes
4.3.1.2 Publishing Stored Procedures to SQL
4.3.1.3 Calling Published Stored Procedures
4.3.1.4 Dropping Published Stored Procedures
4.3.1.5 Example
4.3.2 Model 2: Using the Attached Stored Procedure Development Model
4.3.2.1 Attaching a Java Class to a Table
4.3.2.2 Table-Level Stored Procedures
4.3.2.3 Row-Level Stored Procedures
4.3.2.4 Calling Attached Stored Procedures
4.3.2.5 Dropping Attached Stored Procedures
4.3.2.6 Example
4.3.3 Calling Java Stored Procedures from ODBC
4.4 Java Datatypes
4.4.1 Declaring Parameters
4.4.2 Using Stored Procedures to Return Multiple Rows
4.4.2.1 Returning Multiple Rows in ODBC
4.4.2.2 Example
4.5 Using Triggers
4.5.1 Statement-Level vs. Row-Level Triggers
4.5.2 Creating Triggers
4.5.2.1 Enabling and Disabling Triggers
4.5.3 Dropping Triggers
4.5.4 Trigger Example
4.5.5 Trigger Arguments
4.5.6 Trigger Arguments Example

5 Java Support on Windows CE

5.1 Overview
5.2 Sync Class
5.3 SyncException Class
5.4 SyncOption Class
5.5 Java Interface SyncParam Settings
5.6 Java Interface TransportParam Parameters
5.7 SyncProgress Listener Service

A Stored Procedure Tutorial

A.1 Creating a Stored Procedure and Trigger
A.1.1 Start MSQL
A.1.2 Create a Table
A.1.3 Create a Java Class
A.1.4 Load the Java Class File
A.1.5 Publish the Stored Procedure
A.1.6 Populate the Database
A.1.7 Execute the Procedure
A.1.8 Verify the Email Address
A.2 Create a Trigger
A.2.1 Testing the Trigger
A.2.2 Verify the Email Address
A.3 Commit or Roll Back

B Sample Programs

B.1 Java Samples Overview
B.1.1 JDBC Sample
B.1.2 PL/SQL Conversion to Java Samples
B.1.3 Java Stored Procedures Sample
B.2 Running the Samples
B.2.1 Running the JDBC Sample
B.2.2 Running the PL/SQL Conversion Samples
B.2.3 Running the Java Stored Procedures Sample

Index