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.
Chapter 1 Introduction
Comparing SQLJ and JDBC
SQLJ Components
Requirements for Using SQLJ
Configuring Your Environment
A “Hello World” Program for SQLJ
The sqlj Command-Line Utility
Oracle JDeveloper
Chapter 2 Relational Databases, SQL, and PL/SQL
Relational Databases
Structured Query Language (SQL)
PL/SQL
Chapter 3 Fundamental SQLJ Programming
SQLJ Programs
Database Connections
Simple SQLJ Statements
Transactions
Queries That Return Multiple Rows
Nested Cursors
PL/SQL in SQLJ
Chapter 4 Database Objects
Defining Object Types
Object Columns and Object Tables
Creating Custom Classes
Accessing Database Objects Using SQLJ
Object Identifiers and REF Columns
Chapter 5 Collections
VARRAYs
Nested Tables
Storing an Object Type in a Collection
Collection Custom Classes
Accessing Collections Using SQLJ
Chapter 6 Deploying SQLJ in the JServer
Understanding the Oracle JServer
Designing Server-Based SQLJ Programs
Translating SQLJ Programs
Loading SQLJ Programs into the Database
Publishing Class Methods
Using Database Triggers
Using JDeveloper to Translate and Load SQLJ Programs
Using Enterprise JavaBeans
Chapter 7 Large Objects
The Example Files and Directories
Large Objects (LOBs)
LONG and LONG RAW Columns
Chapter 8 Contexts and Multithreading
Connection Contexts
Execution Contexts
Multithreaded SQLJ Programs
Chapter 9 Advanced Transaction Control
Transaction Processing Problems
Transaction Isolation Levels
The SET TRANSACTION Statement
A Transaction Isolation Level Example
Chapter 10 Performance Tuning
Row Prefetching
Batch Processing
Tuning SQL Statements
The Oracle Optimizer
Chapter 11 Combining JDBC, SQLJ, and Dynamic SQL
Static and Dynamic SQL
Sharing Database Connections
SQLJ Iterators and JDBC Result Sets
Appendix Java and Oracle Type Mappings
JDBC 1.x Type Mappings
Additional JDBC 2.0 Type Mappings
Java Wrapper Class Mappings
SQLJ Stream Class Mappings
Oracle Extension Class Mappings
Appendix Oracle Java Utilities Reference
Oracle SQLJ Translator
JPublisher
loadjava
dropjava
deployejb
Appendix SQLJ in Applets, Servlets, and JavaServer Pages
Jason Price is currently employed as a product manager with Oracle Corporation. He has contributed to many products at Oracle, including the database server, the application server, and several CRM applications. Prior to working at Oracle, he was employed as a consultant at Logica PLC in London, a systems integration and technical consulting firm. He is a certified Oracle DBA and Application Developer, and has over ten years of experience in the software industry.
Comments about O'Reilly Media Java Programming with Oracle SQLJ:
Nice book. Well written and comprehensive.
11/13/2001
5.0
Java Programming with Oracle SQLJ Review
By Mark Prince
from Undisclosed
Comments about O'Reilly Media Java Programming with Oracle SQLJ:
The only book worth reading on SQLJ. It has everything.
9/17/2001
5.0
Java Programming with Oracle SQLJ Review
By Darren Hill
from Undisclosed
Comments about O'Reilly Media Java Programming with Oracle SQLJ:
Great book. I liked the easy going style, and the coverage of both the basic and advanced features of SQLJ. Even the latest Oracle9i SQLJ features are included. Keep up the good work!
9/5/2001
(1 of 1 customers found this review helpful)
5.0
Java Programming with Oracle SQLJ Review
By Ed Ho
from Undisclosed
Comments about O'Reilly Media Java Programming with Oracle SQLJ:
I really liked this book. I've been using SQLJ for quite some time now, and am really happy there's finally a good book out. Thanks!
