Customer Reviews

Oracle8i SQLJ Programming

5 star:		(7)
4 star:		(1)
3 star:		(1)
2 star:		(2)
1 star:		(3)

 

 

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.

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.

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.

This book provides a good introduction to SQLJ programming in Oracle. If you are trying to leverage Oracle's built-in Java support, I highly recomment reading this book. The sections are focused and concise and you can easily use this book as a reference guide as well. This book is the best reference I have found to-date on SQLJ programming.

You will learn how to use SQLJ with this book. However, be prepared for a very poorly organized book, with rambling prose and numerous mentions in all chapters to see chapter x for an explanation. Too many "hyperlinks" for printed material reflect poorly on the author and the editor.

When something is good, I say it straightforward; when something is bad, i say it straightforward as well. First I have to say that the authors' willingness to share their new knowledge and experience of Oracle SQLJ with the reader. This is very commendable. Second, with due respect to the publisher and the authors, the source code both downloaded and shown in the book is really questionable and full of errors. Right in the beginning of the book, on the introduction part, the file, createposchema.sql, has two errors. Instead of exploring the new SQLJ technology, I spent a lot of time debugging the codes. What a pity! It is not only the money wasted, it is a rather the time that is wasted! Sorry I have to kiss goodbye to this book. I demand that both the authors and the publisher correct their source code and show more respect and responsibility to the reader. Until the source code is corrected, I may reconsider to purchase it because SQLJ technology is really important and there are very few books around introducing oracle's SQLJ in depth. That's why I said earlier it is a pity.

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.

The two sample code programs from chapter 2 (the first chapter with sample code) referenced columns in the table that did not match the creation script that came in the same bundle. I had to modify the code.

The next chapter? The program wouldn't even compile, and I am not skilled enough to debug it. That's why I bought this book!

Conclusion: It gets sent back.

How can sample code be put out that doesn't work? This is totally unacceptable.

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!

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.