Press Release: September 6, 2001
SQLJ: The Next Step in Database Access with Java
Sebastopol, CA--Until recently, Java programmers working in an Oracle environment have primarily used JDBC (Java Database Connectivity) to access data within an Oracle database. SQLJ is a technology that serves the same purpose, but goes even further than JDBC. As author Jason Price explains in his new book, Java Programming with Oracle SQLJ (O'Reilly, US $39.95), SQLJ operates at a higher level of abstraction than JDBC and has a simpler, more concise syntax than JDBC. This results in SQLJ programs containing fewer lines of source code than comparable JDBC programs. In addition, with SQLJ the compiler checks the embedded SQL statements during compilation, while JDBC checks them only when the program is actually run. This translates into more rapid, concise development with SQLJ, with fewer errors making their way into the production code.
"SQLJ represents the next step in the evolution of database access using Java. It is poised to become THE way to use the Oracle9i database with Java," says Price. "Once programmers try SQLJ, they'll never want to go back to JDBC." A longtime Oracle insider, Price outlines SQLJ programming techniques in his book, first showing readers how to connect to an Oracle database to issue SELECT queries and other SQL statements. He then moves on to more advanced topics, such as deploying SQLJ code within the Oracle database server, using streams, and working with large objects. Price's goal in writing the book was to provide all the information programmers would need to write high-quality SQLJ programs.
Java Programming with Oracle SQLJ also provides full descriptions of the various command-line tools, the requirements for using SQLJ, performance tuning tips, and an abundance of working code examples to illustrate the real-world use of SQLJ.
Price, who is both an Oracle certified database administrator and certified application developer, has written Java Programming with Oracle SQLJ for developers who need a comprehensive guide on writing SQLJ programs or who wish to migrate from JDBC to SQLJ. The book will also be useful to technical managers who need a thorough introduction to SQLJ.
"This book provides a clear exposition and a wealth of examples benefiting all Oracle SQL and Java programmers who want to improve their productivity through SQLJ--the standard for embedding SQL in Java," said Steven G. Harris, director of Java Products Group, Server Technologies, for Oracle Corporation. "I am particularly excited about the inclusion of the latest Oracle9i SQLJ features--such as support for dynamic SQL--that put SQLJ fully on par with JDBC."
An article by the author, "Using Static and Dynamic SQL in SQLJ" can be found online.
Chapter 8, "Contexts and Multithreading," is available free online.
More information about the book, including Table of Contents, index, author bio, and samples.
A cover graphic in jpeg format.
For almost 40 years, O’Reilly Media has provided technology and business training, knowledge, and insight to help companies succeed. Our unique network of experts and innovators share their knowledge and expertise through the company’s Safari training and learning platform and at O’Reilly conferences. As a SaaS learning platform, Safari delivers highly topical and comprehensive technology and business learning solutions to millions of users across enterprise, consumer, and university channels. For more information visit oreilly.com.
Return to: O'Reilly Press Room