Oracle8i SQLJ Programming

by Martin K. Solomon, Gerald P. Momplaisir, Nirva Morisseau-Leroy

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... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0072121602
• ISBN13: 9780072121605
• Release Date: November 1999
• Publisher: McGraw-Hill Companies
• Length: 557 Pages
• Weight: 2.58 lbs.
• Dimensions: 1.5" x 7.4" x 9.2"

Customer Reviews

THE ONLY BOOK WORTH READING ON SQLJ

If you are serious about learning SQLJ, I strongly recommend that you get this book. Both a tutorial and a reference manual, this book takes the guts of SQLJ and spelled it out in layman terms. Full of well-designed and well explained code based on real-world applications, this book is a MUST for any Java developer.

An excellent SQLJ book

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.

Excellent Book

This is an excellent book about SQLJ programming. I've reccomended it to several of my friends. The code works fine in Dr. Solomon's portion of the book. Perhaps I have a later edition.

A very helpful book

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.

The next step

I personally feel this book is the next step in the integration between Java and Oracle8i. As a user of the Web and as a web master, Oracle8i with SQLJ is an excellent combination for the Web. This book takes you from point A to point Z, at your pace. I recommend it to all!