With support for embedded SQL calls within Java, the SQLJ standard greatly simplifies JDBC database programming. Oracle8I SQLJ Programming serves as a complete reference and guide to working with SQLJ. Impressively thorough and loaded with detailed examples, this book is a must for any serious Oracle developer or analyst.
This text serves as both a tutorial to SQLJ in general (a standard supported by Sun) and its implementation in Oracle. It excels at showing off the possibilities for designing SQLJ applications that will run on both clients and servers, meaning that you can write thin-client solutions successfully. Separate sections look at deploying SQLJ in Java applications and in applets inside Web browsers.
This title provides a very good tutorial on the specific syntax of SQLJ. (Normally, SQLJ statements are embedded in your Java code, which are then converted into regular JDBC statements as part of the build process. The authors provide all the necessary details.) There's material here on retrieving values and recordsets into Java variables, as well as how to call stored procedures in SQLJ. (This title also shows how to use "traditional" Oracle PL/SQL.) Later sections explain using large objects (LOBs), fields, and database streams, as well as the role SQLJ can play in distributed component architectures (including Enterprise JavaBeans and CORBA). If anything, this title suggests that SQLJ (and Java) will play an increasingly vital role in the evolution of Oracle products.
With numerous code excerpts (all thoroughly annotated and explained), this title will satisfy the most practically minded developer. For the analyst or manager, Oracle8I SQLJ Programming can deliver a valuable perspective on the role of SQLJ and Java on today's distributed architectures, particularly on the Oracle platform. --Richard Dragan
Topics covered: Overview of Oracle 8i SQLJ, thin and thick clients, server-side SQLJ, SQLJ with and without returned results, named iterators, the SQLJ translation process, transactions, using PL/SQL with SQLJ, host expressions, JDBC and SQLJ, stored programs and triggers, deployment options for applications and applets, database connections, SQLJ streams, large objects (LOBs), interoperability between SQLJ and JDBC, object-relational processing, object and user-defined types, SQLJ and distributed components, RMI, Enterprise JavaBeans (EJBs), CORBA, performance tuning, and Oracle tools overview (including JDeveloper).
Product Description
Learn how to implement SQLJ--the new standard for embedding static SQL directly into Java programs.
See all Editorial Reviews