Contents

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

About This Document

Notational Conventions

1 Oracle Lite Java Support

1.1 Java Datatypes

1.2 Java Tools

1.2.1 loadjava

1.3 Oracle Lite Java Development Environment

1.3.1 Environment Setup

1.3.1.1 Setting Variables for JDK 1.2

2 Java Stored Procedures and Triggers

2.1 New Features in Oracle Lite

2.2 Stored Procedures and Triggers Overview

2.3 Using Stored Procedures

2.3.1 Model 1: Using the Load and Publish Stored Procedure Development Model

2.3.1.1 Loading Classes

2.3.1.2 Publishing Stored Procedures to SQL

2.3.1.3 Calling Published Stored Procedures

2.3.1.4 Dropping Published Stored Procedures

2.3.1.5 Example

2.3.2 Model 2: Using the Attached Stored Procedure Development Model

2.3.2.1 Table-Level Stored Procedures

2.3.2.2 Row-Level Stored Procedures

2.3.2.3 Attaching a Java Class to a Table

2.3.2.4 Calling Attached Stored Procedures

2.3.2.5 Dropping Attached Stored Procedures

2.3.2.6 Example

2.3.3 Calling Java Stored Procedures from ODBC

2.4 Java Datatypes

2.4.1 Declaring Parameters

2.4.2 Using Stored Procedures to Return Multiple Rows

2.4.2.1 Returning Multiple Rows in ODBC

2.4.2.2 Example

2.5 Using Triggers

2.5.1 Statement-Level vs. Row-Level Triggers

2.5.2 Creating Triggers

2.5.2.1 Enabling and Disabling Triggers

2.5.3 Dropping Triggers

2.5.4 Trigger Example

2.5.5 Trigger Arguments

2.5.6 Trigger Arguments Example

3 Java Database Connectivity (JDBC)

3.1 New Features in Oracle Lite

3.2 What is JDBC?

3.3 JDBC Environment Setup

3.3.1 Loading the Oracle Lite JDBC Driver

3.3.2 Connecting to an Oracle Lite Database

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 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

A Stored Procedure Tutorial

A.1 Creating a Stored Procedure and Trigger

A.1.1 Start SQL*Plus

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 JDBC Application Tutorial

B.1 Check the Environment

B.2 Load the JDBC Driver into Your Application

B.3 Connect to an Oracle Lite Database

B.4 Issue Queries and Browse Results

B.5 Commit a Transaction

B.6 Complete Example

B.7 Compile and Run the Example

C New JDBC 2.0 Features

C.1 Interface Connection

C.1.1 Methods

C.2 Interface Statement

C.3 Interface ResultSet

C.3.1 Fields

C.3.2 Methods

C.3.2.1 Methods that False

C.4 Interface DatabaseMetaData

C.4.1 Methods

C.4.1.1 Methods that Return False

C.5 Interface ResultSetMetaData

C.5.1 Methods:

C.6 Interface PreparedStatement

C.6.1 Methods

D Sample Programs

D.1 Java Samples Overview

D.1.1 JDBC Sample

D.1.2 PL/SQL Conversion to Java Samples

D.1.3 Java Stored Procedures Sample

D.2 Running the Samples

D.2.1 Running the JDBC Sample

D.2.2 Running the PL/SQL Conversion Samples

D.2.3 Running the Java Stored Procedures Sample

Index