Oracle 8i and Java

ELIO BONAZZI has been working with mission-critical database applications since 1986. Currently, he is a systems architect working for Quest Software in Melbourne, Australia, developing performance monitoring tools for Java application servers and databases. GLENN STOKOL has more than 14 years of experience, dealing mostly with network and relational technologies. He is a Java Evangelist and Trainer for Oracle Australia, working with diverse Oracle users all over the country to develop Internet and Java-based solutions.

Preface.


1. Introduction to Oracle Object-Relational Database Design and Architecture.


Relational Model and Design for the Bookstore. Importance of the Database Model and Design. Transforming an ERD into a Table Design. Transforming Supertype and Subtype Entities. Generic Subtype Design. Table or System Design. Object Model and Design for the Bookstore. Mapping the Class Model to an Oracle Database. Object to Relational Mapping Rules. Summary.



2. Data Definition Language (DDL) Statements.


Overview of SQL Statements. A Brief Introduction to Oracle SQL*Plus. Generic DDL Syntax. Oracle Naming Rules for Database Structures. Oracle8 Built-in Data Types. Relational Tables. Alternative CREATE TABLE Syntax. Relational Views. Oracle Sequences. Oracle Synonyms. Oracle Object Types. Oracle Object Tables. Oracle Object Views. Security: Access-Control Statements. Summary.



3. Query Processing.


SELECT Statements. Single Row Functions. WHERE CLAUSE to Restrict Rows Retrieved. Table Join Operations. ORDER BY. Aggregate Functions. GROUP BY Clauses. HAVING Clauses. Subqueries. Querying Object Structures. Summary.



4. Data Manipulation Language (DML) Statements and Transactions.


DML on Relational Tables. DML on Object Tables. DML on Collection Objects. Getting More Performance with DML. Transactions in Oracle SQL. Summary.



5. Oracle Architecture and Performance Considerations.


Architectural Elements. Performance Tuning. Summary.



6. Internet Security and Oracle security.


Network Firewalls. Oracle Security. The Demilitarized Zone. Using Oracle Security and Synonyms to Implement a Development Environment. New Oracle Security Features. Summary.



7. Introduction to PL/SQL.


Anonymous Blocks. PL/SQL Variables and Data Types. Conditional and Sequential Controls. Using SQL Statements in PL/SQL. Cursors. PL/SQL Tables and Varying Arrays. User-Defined/Object Types in PL/SQL. Summary.



8. PL/SQL Procedures, Functions, Packages, and Exceptions.


Stored Procedures and Functions. PL/SQL Packages. PL/SQL and Object Types. Exception Handling in PL/SQL. Transactions in PL/SQL. Java and PL/SQL: A Comparison. Performance Considerations. Summary.



9. Data Access with JDBC-Java Database Connectivity.


Introducing the JDBC Architecture. The Driver Manager and JDBC Drivers. Overview of JDBC Interfaces and Classes. Using JDBC Objects. Summary.



10. Enhanced Database Access with JDBC.


Extensions to Oracle JDBC Drivers. Support for the JDBC 2.0 Optional Package. Summary.



11. Data Access with SQLJ-Embedding SQL in Java.


An Overview of SQLJ. Connecting to a Database in SQLJ. Executing SQL Statements Using SQLJ. Processing Oracle SQL Object Types. Processing SQL Collections. Managing Large Data Types. Executing Stored Procedures and Functions. Summary.



12. Java Stored Procedures In Oracle.


Java Code Running in the Oracle Kernel. Three Steps to Develop and Deploy Stored Procedures. Making Java and PL/SQL Interact. PL/SQL versus Java: Choosing the Right Tool for Your Task. Summary.



13. Business Components for Java and XML.


The Business Component for Java Framework. Introduction to XML Basics. Creating a Business Component Application Module. Testing Components and the Application Module. Creating BC4J Client Applications. Customizing the Components. Deploying a Business Component. Summary.



14. Data Access Using Java Servlets and Connection Pooling.


Multiple Threads, Session State, and Security. Connection Pooling. A Servlet Example. BookServlet: Pros and Cons. Running BookServlet. Summary.



15. Java Server Pages and Active Server Pages.


JSP: An Overview. ASP: An Overview. JSP and ASP Compared. Reworking BookServlet Using JSP. Summary.



16. Using Java in Oracle Application Server.


Evolution of Oracle Application Server. Oracle Application Server Architecture. Configuring PL/SQL Applications. Configuring Java Applications. Introducing Oracle9i Application Server. Summary.



17. Web-Enabling Legacy Applications Using Network Sockets.


The Mediator Design Pattern. Java Sockets. Summary.



18. Web-Enabling Legacy Applications Using JNI.


Oracle Pre-Compilers. Java Native Methods. Setting Up Your Environment to Run the Example. Debugging JNI Functions. Summary.



19. Accessing Oracle Advanced Queuing Through Java.


Application Queues. Oracle Advanced Queuing. Examples of Advanced Queuing. Summary.



20. Using Oracle Replication to Build Distributed Systems.


Data Replication. Basic Replication in Oracle. An Example of Data Replication. Summary.



21. The Enterprise JavaBean: An Introduction.


EJB Environment and Structure. Creating an Enterprise JavaBean. Creating EJB Client Application. Creating an EJB and Client with JDeveloper. Running the Enterprise JavaBean. Summary.



22. Deploying and Using an Enterprise JavaBean.


Preparing to Run Oracle8i EJB Services. Deploying an EJB with Command-Line Utilities. Running the Client Application after Deployment. Transaction-Enabling an Enterprise JavaBean. Restrictions and Limitations with Oracle8i EJBs. EJB Security in Oracle8i. Removing an EJB from Oracle8i Server. Deploying an Enterprise JavaBean to Oracle Application Server. Summary.



23. CORBA and Its Implementation in Oracle8i: An Overview.


Distributed Computing: Historical Background. The Common Object Broker Architecture. Putting It All Together: The First CORBA Program. The Java Transaction Service (JTS). Summary.



24. Advanced CORBA Topics.


More on Interface Definition Language. Managing the Oracle Name Space. Using the CORBA Tie Mechanism. Further References. Summary.