Résumé
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
Contents
Preface
1. Introduction
- Comparing SQL J and JDBC
- SQL J Components
- Requirements for Using SQL J
- Configuring Your Environment
- A "Hello World" Program for SQL J
- The sqlj Command-Line Utility
- Oracle JDeveloper
- Relational Databases
- Structured Query Language (SQL)
- PL/SQL
- SQL J Programs
- Database Connections
- Simple SQL J Statements
- Transactions
- Queries That Return Multiple Rows
- Nested Cursors
- PL/SQL in SQL J
- Defining Object Types
- Object Columns and Object Tables
- Creating Custom Classes
- Accessing Database Objects Using SQL J
- Object Identifiers and REF Columns
- VARRAYs
- Nested Tables
- Storing an Object Type in a Collection
- Collection Custom Classes
- Accessing Collections Using SQL J
- Understanding the Oracle JServer
- Designing Server-Based SQL J Programs
- Translating SQLJ Programs
- Loading SQLJ Programs into the Database
- Publishing Class Methods
- Using Database Triggers
- Using JDeveloper to Translate and Load SQL J Programs
- Using Enterprise JavaBeans
- The Example Files and Directories
- Large Objects (LOBs)
- LONG and LONG RAW Columns
- Connection Contexts
- Execution Contexts
- Multithreaded SQL J Programs
- Transaction Processing Problems
- Transaction Isolation Levels
- The SET TRANSACTION Statement
- A Transaction Isolation Level Example
- Row Prefetching
- Batch Processing
- Tuning SQL Statements
- The Oracle Optimizer
- Static and Dynamic SQL
- Sharing Database Connections
- SQL J Iterators and JDBC Result Sets
B. Oracle Java Utilities Reference
C. SQL J in Applets, Servlets, and JavaServer Pages
Index
L'auteur - Jason Price
Jason Price is an independent consultant and writer, and is both a Microsoft Certified Professional and an Oracle Certified Professional. Jason has more than 10 years of experience in the software industry, and he has extensive experience with C#, .NET, and Java. He is the author of Mastering Visual C# .NET, Oracle9i JDBC Programming, and Java Programming with Oracle SQLJ.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | O'Reilly |
| Auteur(s) | Jason Price |
| Parution | 01/08/2001 |
| Nb. de pages | 400 |
| Format | 17,8 x 23,4 |
| Couverture | Broché |
| Poids | 657g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780596000875 |
Avantages Eyrolles.com
Livraison à partir de 0,01 € en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
