back to Course Categories | back | print
Oracle9iAS: Deploying J2EE and PL/SQL          

Duration: 5 days

This course is a great class for application server administrators and Oracle developers. This class provides comprehensive coverage of deploying Java, PL/SQL in multi-tiered enterprise environments. Detailed coverage of messaging systems using Advanced Queueing and the Java Message Service is included. Attendees will learn how to deploy J2EE and PL/SQL applications to the Oracle9i Application Server. The class is taught using Oracle9i Application Server (Release 2) and Oracle9i JDeveloper. Attendees will learn how to configure the Oracle9i Application Server using Oracle Enterprise Manager. Deploying J2EE applications using JDeveloper will be covered. By the end of this class attendees will understand how to configure, deploy and tuning of J2EE and PL/SQL applications in the Oracle9i Application Server.


  • Understanding the Oracle9iAS architecture
  • Deploying Web Services
  • Deploying EJB modules
  • J2EE connectors
  • Deployment descriptors
  • Configuration files
  • Installing and Configuring Oracle9iAS
  • Managing Oracle9iAS and OC4J
  • Configuring DataSources
  • Installing and Configuring Oracle9iAS
  • Managing Oracle9iAS and OC4J
  • Configuring DataSources
  • Deploying Web Applications - Servlets / JSPs
  • J2EE Transactions
  • J2EE Connector Architecture
  • Enabling JAAS Security in J2EE Applications
  • Configuring Java Messaging Services
  • Configuring Advanced Queueing
  • Advanced Configurations - Component Clustering
  • Deploying Web Applications - Servlets / JSPs
  • Deploying EJBs
  • J2EE Transactions
  • Deploying Web Services
  • J2EE Connector Architecture
  • Enabling JAAS Security in J2EE Applications
  • Configuring Java Messaging Services
  • Advanced Configurations - Component Clustering
  • JAAS security
  • Performance tuning
  • Component level clustering
  • Load-balancing
  • Developing dynamic web applications using Oracle9iAS
  • PL/SQL Web applications
  • The PL/SQL Gateway
  • The flow of HTTP requests
  • Creating Web Pages using HTML
  • Retrieving the home Web page
  • PL/SQL Server Pages
  • Using the PL/SQL Web Toolkit
  • Web page basics
  • Required tags
  • Formatting
  • Creating document links
  • Adding images
  • Creating Dynamic Web Pages with PL/SQL
  • Calling PL/SQL from a URL
  • Passing parameters to a PL/SQL Web Toolkit procedure
  • Building PL/SQL Server Pages
  • Creating HTML with the HTP and HTF packages
  • Building a PL/SQL package with reusable page components
  • Creating a document link & Including dynamic data in an HTML page
  • Developing Dynamic HTML Tables
  • Developing a table using HTML tags
  • Developing a table using the HTP and HTF packages
  • Populating a table dynamically using a SQL cursor
  • Printing tables using the owa_util package
  • DevelopingDynamic Forms
  • Defining an HTML form
  • Creating HTML form elements with the HTP and HTF packages
  • Submitting an HTML form
  • Passing parameters to the PL/SQL procedure
  • Submitting a form using an image
  • Adding Functionality using Toolkit Utilities
  • Viewing source of a stored procedure
  • Retrieving and viewing CGI environment variables
  • Printing a calendar
  • Generating a dynamic selection list
  • Sending a status code to the client
  • Entering dates in forms
  • Pattern matching
  • Calling additional Web applications
  • Enhancing Client Interaction
  • Understanding cookies?
  • Defining cookies with the owa_cookie package
  • Retaining application state with cookies
  • Redirecting a URL
  • Uploading and downloading files
  • Validating Data and Executing Transactions
  • Data validation
  • DML in Web applications
  • Managing concurrency
  • Frame concepts
  • Creating a frame-based document with HTML
  • Creating a frame-based document using the PL/SQL Web Toolkit
  • Populating a frame
  • Using PL/SQL Server Pages
  • Why use PL/SQL Server Pages?
  • Displaying a PL/SQL Server Page
  • Creating a PL/SQL Server Page
  • Developing a PL/SQL Server Page
  • Loading a PL/SQL Server Page
  • Running a PL/SQL Server Page
  • Security
  • Authenticating users through PL/SQL Gateway
  • PL/SQL Gateway authentication modes
  • Basic authentication
  • Custom authentication
  • SSO authentication


  • Attendees must have experience with J2EE applications, PL/SQL and Oracle development environments.


Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes


all content property © 2006, 2007Trubix Inc.| site design by Art Z design