Description
The author, an Oracle certified database administrator and certified application developer, explains the use of SQLJ, a technology that he believes improves on the more often-used JDBC by operating at a higher level of abstraction and using a simpler, more concise syntax. Includes full descriptions of the various command-line tools, the requirements for using SQLJ, performance tuning tips, and numerous working code examples to illustrate the use of SQLJ. Annotation c. Book News, Inc., Portland, OR (booknews.com)
Read More
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 programsDeploy SQLJ code not only on client machines, but also to JServer--Oracle's Java engine built into the databaseUse advanced techniques for working with collections, streams, large objects, and database objects, all without leaving the comfort of the SQLJ environmentTune SQLJ programs for maximum performanceThroughout 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.
Read Less