This primer describes the Oracle SQLJ 8.1.6 release. Applications that you created with the Oracle SQLJ 8.1.5 translator will continue to run with the 8.1.6 runtime, or you can recompile them to take advantage of new features, such as statement caching (see Section "5.8 Give Me Speed … or More Speed"). Although you would typically use the 8.1.6 version of SQLJ with Oracle's 8.1.6 JDBC driver, you can also use it together with the 8.0.6 or 7.3.4 JDBC versions.

The following features are new in version 8.1.6: the -checksource flag (see Section "1.1 I Need To Tell You"), the method Oracle. close() (see Section "1.4 Getting Connected"), support for JDBC 2.0 types and interfaces (java.sql.Struct/Ref/Array/Blob/ Clob and SqlData - see Sections "3.3 She Is An Oracle Type" and "5.5 Let's Get Objective"), the -jdblinemap and -P-CshowThreads options (see Section "4.2 Where Is The Bug"), the offline SQL parser (see Section "5.7 Isn't It — Portable"), performance enhancements (see Section "5.8 Give Me Speed … or More Speed"), and support for iterator subclassing (see Section "5.9 Classy Kinds of Iterators").