Oracle Database Programming using Java and Web Services

Chapter 11. The SQLJ Language and Oracle Extensions

A SQLJ program contains Java/JDBC code, SQLJ declaration statements, and SQLJ executable statements, as illustrated by Figure 11.1.

Table 11.1. Elements of a SQLJ program

Java & JDBC code + SQLJ Declaration Statements + SQLJ Executable Statements

This chapter covers SQLJ declarations, SQLJ executable statements, interoperability between SQLJ and JDBC, and, finally, Expressions in SQLJ.

Declaration Statements

This category contains import statements, connection contexts declaration, execution contexts declarations, and iterators declarations.

Import Statements

import java.sql.SQLException;
import sqlj.runtime.ref.DefaultContext;
import oracle.sqlj.runtime.*;
...

Connection Contexts

A connection context ...