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



Title and Copyright Information

Send Us Your Comments


Intended Audience
Documentation Accessibility

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 loadjava
2.1.3 Oracle Database Lite Java Development Environment 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 Reading from a BLOB Sample Program Writing to a CLOB Sample Program
3.6 Limitations
3.7 New JDBC 2.0 Features
3.7.1 Interface Connection Methods
3.7.2 Interface Statement
3.7.3 Interface ResultSet Fields Methods Methods that Return False
3.7.4 Interface Database MetaData Methods Methods that Return False
3.7.5 Interface ResultMetaData Methods
3.7.6 Interface PreparedStatement 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 Loading Classes Publishing Stored Procedures to SQL Calling Published Stored Procedures Dropping Published Stored Procedures Example
4.3.2 Model 2: Using the Attached Stored Procedure Development Model Attaching a Java Class to a Table Table-Level Stored Procedures Row-Level Stored Procedures Calling Attached Stored Procedures Dropping Attached Stored Procedures 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 Returning Multiple Rows in ODBC Example
4.5 Using Triggers
4.5.1 Statement-Level vs. Row-Level Triggers
4.5.2 Creating Triggers 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