Oracle and Java Development

Bulusu Lakshman is the author of the book Oracle Developer Forms Techniques from Sams Publishing. He holds an Oracle Masters credential from Oracle Corporation and is OCP-Certified. He also holds Master level BrainBench certifications. He has more than nine years of experience in using Oracle and its associated tools in the development of mission-critical applications. Most recently, he has used Oracle 8i and its related technologies for developing applications for a Fortune 400 client. He has lectured at different national and international conferences and authored technical articles for lead publications in the United States and United Kingdom. Currently he works for Compunnel Software Group Inc., a leading technical consulting firm in New Jersey and can be reached at balakshman@hotmail.com or blakshman@compunnel.com. He lives in Edison, New Jersey, with his wife Anuradha and writes poetry during his free time.

Introduction.
I. INTRODUCTION.

1. Introduction to Oracle Java Technologies.


Database Access in Java. Building Reusable Java Components. Employing Java in a Web Environment.

II. DATABASE ACCESS IN JAVA.

2. Java Stored Procedures.


Overview of Java Stored Procedures-PL/SQL Calling Java. Advantages of Java Stored Procedures. Comparison of PL/SQL Stored Procedures and Java Stored Procedures. Developing Java Stored Procedures-An Overview and Case Study. Writing the Java Method. Loading the Java Method into the Oracle 8i Database. Creating the Java Stored Procedure and Publishing It. Granting Access Privileges. Calling the Java Stored Procedure.

3. Basic JDBC Programming.


Overview of JDBC-Java Calling SQL and PL/SQL. Fundamental Steps in JDBC. INSERT, UPDATE, and DELETE Operations Using JDBC. Oracle JDBC Extensions. Calling Stored Procedures in JDBC Programs. Handling Resultsets in JDBC.

4. Advanced JDBC Programming.


Overview. Handling Object Types in JDBC. Handling Object REFS in JDBC. Handling Collections in JDBC. Handling Large Objects in JDBC. JDBC Performance Extensions. JDBC in the Server.

5. Basic SQLJ Programming.


Overview of SQLJ-Java Calling SQL and PL/SQL. Connecting to a Database. SQLJ Query Processing. Exception Handling in SQLJ. INSERT, UPDATE, DELETE, and COMMIT Operations in SQLJ. Handling Types and Large Objects in SQLJ.

6. Advanced SQLJ Programming.


Overview. Handling Large Objects. Handling Objects and Collections in SQLJ. SQLJ Performance Extensions. SQLJ in the Server.

III. BUILDING REUSABLE JAVA COMPONENTS.

7. Using JavaBeans.


Overview of JavaBeans. JavaBean Naming Conventions. Adding Properties to the JavaBean. Adding Events to the JavaBean. Steps to Create a JavaBean. The BeanInfo Class.

8. Using Enterprise JavaBeans.


Overview of EJBs. Types of EJBs. EJB Architecture and Concepts.

9. Developing and Deploying Enterprise JavaBeans.


Overview. Developing EJBs. Implementing an EJB. Parameter Passing. Using JDBC and SQLJ in an EJB Component. Handling Transactions. EJB Tools.

10. Using Business Components for Java (BC4J)-Introduction and Development.


Overview of BC4J. BC4J and XML. Developing a BC4J Application. Creating Entity Objects. Creating View Objects. Creating Application Modules.

11. Using Business Components for Java (BC4J)-Deployment and Customization.


Deploying BC4J. Developing a Client for BC4J Application. Handling of Events and Errors. Miscellaneous Topics.

IV. EMPLOYING JAVA IN A WEB ENVIRONMENT.

12. Java Servlet Programming.


Overview of Servlets. Servlets Basics. Developing a Servlet. Exception Handling. Managing Sessions in Servlets. Servlets Deployment. Create a Service.

13. Using Java Server Pages.


Overview of JSP. JSP Basics. JSP Architecture. Creating and Designing a JSP. Creating, Initializing, and Using JSP for Calling JavaBeans. Deploying a JSP.

Index.