Oracle8i SQLJ Programming [Paperback]

Nirva Morisseau-Leroy (Author), Edward Griffin (Author), Thomas Kurian (Author)

Book Description

Publication Date: November 5, 1999 | Series: Oracle Press

SQLJ allows application developers to embed SQL statements within Java, facilitating the creation of object-oriented programs. This text details how using SQLJ can increase productivity while easing the steep learning curve of Java development. Web site support is available via SQJL scripts.

Editorial Reviews

Amazon.com Review

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).

From the Back Cover

Create powerful portable applications with SQLJ.

Enable Java to go where it's never gone before! Oracle8i SQLJ Programming explains in detail how to implement SQLJ--the new standard for embedding static SQL directly into Java programs. With SQLJ, you'll use less code and get enhanced portability, compile-time checking, and so much more. This authoritative guide shows you how to create cross-platform, distributed, and Web-enabled applications designed specifically for Oracle8i--the revolutionary new database complete with seamless Java integration. Every chapter includes case studies of actual Java applications developed with SQLJ.

Inside, learn:

Embed SQL statements within Java easily for concise, convenient code

Develop object-oriented applications that can access SQL databases on any variables directly in SQL statements

Develop SQLJ stored subprograms and triggers

Catch error in your SQL statements before runtime

Customize your SQLJ code for Oracle8i

Customize your SQLJ code for Oracle8i

Deploy SQLJ on thin, OCI-based, and KPRB JDBC server-side drivers

Take advantage of SLQj's interoperability with JDBC and PL/SQL

Use Java RMI and create COBRA objects and Enterprise JavaBeans components for distributed computing

Product Details

• Paperback: 557 pages
• Publisher: Osborne Publishing (November 5, 1999)
• Language: English
• ISBN-10: 0072121602
• ISBN-13: 978-0072121605
• Product Dimensions: 9.1 x 7.3 x 1.6 inches
• Shipping Weight: 2.7 pounds
• Average Customer Review: 3.5 out of 5 stars  See all reviews (14 customer reviews)
• Amazon Best Sellers Rank: #7,271,464 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

23 of 25 people found the following review helpful:

5.0 out of 5 stars A very helpful book, January 27, 2000

By 

Alicia Smith (Chicago) - See all my reviews

This review is from: Oracle8i SQLJ Programming (Paperback)

I got this book when I attended the Oracle OpenWorld 99 conference. I have been programming in Java for about a year and I was accustomed only to JDBC. This book is an eye opener on what you can do with SQLJ as well as JDBC. Unlike other Java books that are just reference books, this book gears towards application developers who wish to develop database applications. I highly recommend it to Java and Oracle programmers.

13 of 14 people found the following review helpful:

5.0 out of 5 stars An excellent SQLJ book, September 9, 2000

By 

Gail Lange - See all my reviews
(REAL NAME)   

This review is from: Oracle8i SQLJ Programming (Paperback)

I found this book delightful reading. The clear exposition, program examples with detailed explanations, clear definitions, and well stated principals makes this a must have book for those wishing to use Java with Oracle8i. The detailed style is reminiscent of the well-known text books by authors Harvey and Paul Deitel.

This book is suitable for both database application programmers and undergraduate students. My undergraduate students, who have had a strong course in Java, would love this text. I am using it as a supplement in this fall's Database Systems course.

Java has really come into its own and Oracle8i strongly supports it. The Oracle8i database server supports both PL/SQL and Java. Oracle's Jserver, which includes a JVM (Java Virtual Machine). The authors provide a clear overview of how Java and now SQLJ fit into the database world.

This book presents very clear explanations for people new to database programming. They discuss JDBC and SQLJ and compare the approaches for accessing a relational database server. The authors give a detailed explanation of how a SQLJ program gets translated into Java source code. Nothing is skipped in explaining what the SQLJ translator does. For example, there is a fine discussion of the SQLJ iterator (which is essentially a Java class; the SQLJ translator actually replaces the SQLJ iterator declaration with a Java declaration for a class.) There is a detailed explanation about how the Java class contains a next() method and has accessor methods for columns in a particular table. The discussion of SQLJ stored programs is clear. Pros and cons of loading/compiling on the client versus the server side are given. There are fine examples of both ways of doing things. They give a very good explanation of how a SQLJ program connects to a database using an instance of a connection class, which is really a Java class that is defined in a SQLJ connection context. In conclusion, this is a very refreshing book that gives theory and detailed programs with great explanations. Java is an exciting language and SQLJ makes database work very interesting. These authors are doing a super job in promoting this new and relatively easy way of developing for Oracle databases. I have not found any other book to come close to what they have done for the database community.

9 of 11 people found the following review helpful:

5.0 out of 5 stars Excellent Book, January 26, 2000

By 

Russell St. Fleur (Florida) - See all my reviews

This review is from: Oracle8i SQLJ Programming (Paperback)

I am a college student and I wish to learn how to develop database applications using Java and SQLJ. I got the Oracle8i SQLJ Programming book and I have been using it for about a month. I enjoy working with this book. I specifically like the authors' step by step approach. After the first 3 chapters, I was able to rapidly develop a SQLJ application that accesses an Oracle8i database. If you are really serious about learning the SQLJ language, this is the book that you need.