10 - Introducing the SQLJ technology and oracle's implementation

Abstract

This chapter deals with introducing the SQLJ technology and Oracle's implementation. This chapter addresses what exactly SQLJ is and why one should consider using it. Embedded SQL in Java provides the ability to embed SQL statements in Java, similar to Pro*C and a more productive alternative to JDBC for both client-side and server-side Java. The purport of this chapter is “SQLJ,” which furnishes many extensions such as support for dynamic SQL, beyond the standard specification. SQL routines using Java specifies the ability to invoke static Java methods from SQL as procedures and functions. And SQL types using Java specifies the ability to use Java classes as wrappers for user-defined data types in SQL. The SQLJ translator takes SQLJ sources files, Java sources files, Java classes, and Java resources as input and performs the following operations: SQLJ-to-Java parsing, online type checking, customization of code generation, and compilation of Java sources.