Overview
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.