Book description
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.
Table of contents
- Copyright
- Preface
- Introduction
- Relational Databases, SQL, and PL/SQL
- Fundamental SQLJ Programming
- Database Objects
- Collections
- Deploying SQLJ in the JServer
- Large Objects
- Contexts and Multithreading
- Advanced Transaction Control
- Performance Tuning
- Combining JDBC, SQLJ, and Dynamic SQL
- Java and Oracle Type Mappings
- Oracle Java Utilities Reference
- SQLJ in Applets, Servlets, and JavaServer Pages
- Colophon
- Index
Product information
- Title: Java Programming with Oracle SQLJ
- Author(s):
- Release date: August 2001
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9780596000875
You might also like
book
Java Programming with Oracle JDBC
JDBC is the key Java technology for relational database access. Oracle is arguably the most widely …
book
Oracle Database Programming using Java and Web Services
The traditional division of labor between the database (which only stores and manages SQL and XML …
book
Expert Oracle JDBC Programming
JDBC is the most commonly used API in Java to access and manipulate data in a …
book
Jakarta Commons Cookbook
As a Java developer, you're always looking for tools to help in your web and application …