e-Commerce Applications Using Oracle8i and Java from Scratch

Interacting with the Database Using SQLJ

SQLJ provides a standard way in which SQL statements can be embedded in Java programs. When writing a SQLJ program, a user writes a Java program and embeds SQL statements in it. The SQL statements are embedded following certain standard syntactic rules that govern how SQL statements can be embedded in Java programs. A SQLJ translator is then used to convert the SQLJ program to a standard Java program by replacing the embedded SQL statements with calls to the SQLJ runtime. Then, any Java compiler can be used to compile the generated Java program and run it against the database.

The SQLJ runtime environment consists of a thin SQLJ runtime library that calls a JDBC driver targeting the appropriate database. ...