Java Programming with Oracle SQLJ
If you're a Java programmer working in an Oracle environment, you're probably familiar with JDBC as a means of accessing data within an Oracle database. SQLJ takes you further, allowing you to access a database using embedded SQL statements. Java Programming with Oracle SQLJ shows you how to get the most out of SQLJ.
Layered on top of JDBC, SQLJ greatly simplifies database programming. Rather than make several calls to the JDBC API just to execute a simple SQL statement, SQLJ executes that statement simply by embedding it within the Java code.
In this book, Jason Price explains SQLJ programming from a task-oriented point of view. You'll learn how to:
* Embed queries and other SQL statements within Java programs
* Deploy SQLJ code not only on client machines, but also to JServer--Oracle's Java engine built into the database
* Use advanced techniques for working with collections, streams, large objects, and database objects, all without leaving the comfort of the SQLJ environment
* Tune SQLJ programs for maximum performance
Throughout the book, the exposition of SQLJ and SQLJ programming techniques reflects the author's many years of professional experience as a programmer and consultant. Examples are first-rate, enabling you to learn SQLJ in no time. If you're writing Java code to access an Oracle database, you can't afford not to know about SQLJ.
Moves from the basics of getting connected and issuing SQL statements to advanced topics such as streams and multi-threading. Softcover.
Reviewer: J.D.Withington "jdwithington" (San Jose, USA)
My knowledge of Oracle and Java is beginner/intermediate level and I like this book a lot.
The book explains how SQLJ relates to SQL, PL/SQL, Java, JDBC and it provides a good introduction to the JDeveloper IDE (Integrated Development Environment).
The book is written very clearly and the appearance and organization of the text is well up to the O'Reilly standard.
I can't comment on the worked examples yet as I have not yet tried them out.