Java Programming with Oracle SQLJ

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. When Jason is not working or writing, he enjoys walking, running, and working out. Jason holds a Bachelor of Science degree (with honors) in Physics from the University of Bristol, England. Jason currently resides in California.

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. 2. Relational Databases, SQL, and PL/SQL Relational Databases Structured Query Language (SQL) PL/SQL. 3. Fundamental SQL J Programming SQL J Programs Database Connections Simple SQL J Statements Transactions Queries That Return Multiple Rows Nested Cursors PL/SQL in SQL J. 4. Database Objects Defining Object Types Object Columns and Object Tables Creating Custom Classes Accessing Database Objects Using SQL J Object Identifiers and REF Columns. 5. Collections VARRAYs Nested Tables Storing an Object Type in a Collection Collection Custom Classes Accessing Collections Using SQL J. 6. Deploying SQL J in the JServer 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. 7. Large Objects The Example Files and Directories Large Objects (LOBs) LONG and LONG RAW Columns. 8. Contexts and Multithreading Connection Contexts Execution Contexts Multithreaded SQL J Programs. 9. Advanced Transaction Control Transaction Processing Problems Transaction Isolation Levels The SET TRANSACTION Statement A Transaction Isolation Level Example. 10. Performance Tuning Row Prefetching Batch Processing Tuning SQL Statements The Oracle Optimizer. 11. Combining JDBC, SQL J, and Dynamic SQL Static and Dynamic SQL Sharing Database Connections SQL J Iterators and JDBC Result Sets. A. Java and Oracle Type Mappings. B. Oracle Java Utilities Reference. C. SQL J in Applets, Servlets, and JavaServer Pages. Index