Oracle8

Assumptions and Requirements

Assumptions About Your Environment

Requirements for Using Oracle SQLJ

Checking the Installation and Configuration

Check for Installed Directories and Files

Set the PATH and CLASSPATH

Check the sqljutl Package

Testing the Setup

Set Up the Runtime Connection

Create a Table to Verify the Database is Working

Verify the JDBC Driver Is Working

Test the SQLJ Translator and Runtime

Test SQLJ Translator Connection to the Database

Windows 95/NT Considerations

What to Expect from the SQLJ Translator

SQLJ Translator Input

SQLJ Translator Output

Output File Locations

Overview of SQLJ Components

SQLJ Translator and SQLJ Runtime

SQLJ Profiles

Comment on Oracle Extensions to the SQLJ Standard

Basic Steps in Translating a SQLJ Application

Overview of SQLJ Constructs

Declarations

Executable Statements

Overview of SQLJ Command Line and Properties Files

SQLJ Options, Flags, and Prefixes

Command-Line Syntax and Operations

Properties Files for Option Settings

Order of Precedence of Option Settings

SQLJ Executable Statement Functionality

PL/SQL Blocks in SQLJ

Java Variables in SQL Operations--Host Variables and Expressions

Query Results--SQLJ Iterators

Assignment Statements (SET)

SELECT INTO Statements

SQLJ Streams

Stored Procedure and Function Calls

Key Considerations in Developing and Running a SQLJ Application

Naming Requirements and Restrictions

Selection and Registration of the JDBC Driver

Connection Considerations

Null-Handling

Exception-Handling Basics

Transaction Control

NLS Essentials

Summary: First Steps in SQLJ Code

Import Required Classes

Register JDBC Drivers and Set Default Connection

Set Up Exception Handling

Set Up Host Variables, Execute SQLJ Clause, Process Results

Complete Example of Single-Row Query using SELECT INTO

Set Up Named Iterator

Complete Example of Multiple-Row Query Using Named Iterator

Basic SQLJ Options

Options for Command Line Only

Options for Output Files and Directories

Connection Options (Basic Features)

Reporting and Line-Mapping Options

Overview of SQLJ Internal Operations and Runtime

Internal Translation Operations

Overview of Oracle SQLJ Runtime

Overview of SQLJ Errors, Messages, and Exit Codes

SQLJ Translator Messages: Error, Warning, and Information

SQLJ Status Messages

SQLJ Runtime Errors

SQLJ Exit Codes

SQLJ Applets

Advanced SQLJ Options

Prefixes that Pass Option Settings to Other Executables

Flags for Special Processing

Connection Options (Advanced Features)

Semantics-Checking Options

Java, Compiler, and Customizer Options

Advanced SQLJ Functionality

Connection Contexts

Execution Contexts

Multithreading in SQLJ

Iterator Class Implementation and Advanced Functionality

SQLJ Support for Oracle Type Extensions

The oracle.jdbc.driver Package

Support for BLOB, CLOB, and BFILE

Support for Oracle ROWID

Support for Oracle REF CURSOR Types

Extended Support for BigDecimal

Advanced and Extended Support for Streams in SQLJ

Interoperability Between SQLJ and JDBC

Interoperability Between SQLJ Connection Contexts and JDBC Connections

Interoperability Between SQLJ Iterators and JDBC Result Sets

Connection Properties File

SQLJ Properties File

Basic Samples

Named Iterator--IterDemo1.sqlj

Positional Iterator--IterDemo2.sqlj

Host Expressions--ExprDemo1.sqlj

Advanced Samples

Multithreading--MultiThreadDemo.sqlj

Interoperability with JDBC--JDBCInterop.sqlj

Multiple Connection Schemas--MultiSchema.sqlj

Data Manipulation and Multiple Connection Contexts--SqljDemo.sqlj

Translation Time Messages

Runtime Error Messages

Contents

Title and Copyright Information

Preface

1 Getting Started

2 Basic Features

3 Advanced Features

4 Sample Applications

A SQLJ Error Messages