Shows how to write web applications that access an Oracle database built using Oracle tools. The guide walks through the installation of the necessary Oracle software, then develops the same four small applications with Java servlets, handwritten PL/SQL, Oracle designer, Oracle portal, and Oracle forms and reports. Annotation c. Book News, Inc., Portland, OR (booknews.com)
Oracle Web Applications 101
by Sten E. Vesterli, Brad BrownView All Available Formats & Editions
Your Oracle career starts here! Ideal for those new to Oracle technology,this officially authorized guide explains how to build Web applications using Oracle's built-in tools. The book covers the 5 basic tools you can use to create applications: PL/SQL & PL/SQL Server Pages,Oracle Portal,Oracle Designer,Forms and Reports,and Java Servlets and Java Server Pages. … See more details below
Overview
Your Oracle career starts here! Ideal for those new to Oracle technology,this officially authorized guide explains how to build Web applications using Oracle's built-in tools. The book covers the 5 basic tools you can use to create applications: PL/SQL & PL/SQL Server Pages,Oracle Portal,Oracle Designer,Forms and Reports,and Java Servlets and Java Server Pages. You'll also get details on Oracle Internet Application Server (iAS).
Learn to build Web-based applications using Oracle development tools Get step-by-step details on creating and deploying Web applications on Oracle servers.
Oracle Web Applications 101 discusses the Oracle9i Application Server architecture and explains how to build Web applications in five different ways—with Java servlets and JavaServer Pages,PL/SQL and PL/SQL Server Pages,Oracle Designer,Oracle Portal,and Oracle Forms and Reports. You'll learn how and when to use an HTML-based application,a Java applet-based application,or a code generation tool to build powerful Web applications.
- Understand how the components of the Oracle9i Application Server work together
- Install all the Oracle software you need to get started building Web applications
- Design HTML-based Web applications using Java servlets or JavaServer Pages
- Build HTML applications with PL/SQL stored procedures or PL/SQL Server Pages
- Create PL/SQL Web applications quickly and easily with Oracle Designer
- Use Oracle Portal to build application components,such as dynamic Web pages
- Web-enable existing client/server applications built with Oracle Forms and Reports
Officially authorized by Oracle Corporation,this hands-onresource shows you everything you need to know to get started building Oracle Web applications right away.
Editorial Reviews
Product Details
- ISBN-13:
- 9780072132212
- Publisher:
- McGraw-Hill Professional
- Publication date:
- 04/01/2001
- Series:
- Oracle Press Series
- Pages:
- 448
- Product dimensions:
- 7.34(w) x 9.03(h) x 1.23(d)
Read an Excerpt
Chapter 2: How to Build a Web Application
When you need to get from one place to another in New York City, you have a number of options: you can take a taxi, drive yourself, or take the subway. If you decide to take a taxi, you tell the driver where you want to go, and he takes care of the details. He knows the city and the current traffic and will get you to your destination as quickly as possible. If you are in doubt about the driver's competence, you can try to give him detailed instructions about the route; but this will normally not get you there any faster, and he might misunderstand you and get you both lost.If you drive yourself, you do all the work. You consider the traffic conditions and decide on the exact route. You might get to the destination more quickly or you might not; but either way, you have full control all the way. If you go by subway, you must accept that it might get you close but probably not exactly to where you want to be. However, it is cheap and can often be faster than taking a taxi or driving yourself.
You have a similar choice of three approaches when you are going to build a Web application: you can develop an HTML-based application or a Java applet-based application, or use a code-generating tool.
The HTML-based application is like taking the taxi: you give an instruction (an HTML-formatted file) to the driver (a Web browser). The browser then decides how to present that, given your current window size and browser settings. With the latest clever HTML formatting tricks, you can try to give detailed instructions; but if the browser does not understand them, your page might end up garbled.
Java applet-based applications are like driving yourself: you must do all the work and carry the responsibility. You have full control over every pixel on the screen, but you also have the responsibility of deciding in detail what happens when the user presses a button.
Taking the subway is like using a code-generating tool. It will quickly and efficiently take you to a number of standard destinations, but you will have to accept that only the functionality envisioned by the builders of the tool can be realized.
In this chapter, you will see if and where to use Java and how to choose the right tool for your audience and application. You will get a brief overview of HTML-based applications, Java applet-based applications, and code-generated applications, as well as some advice on producing hardcopy output.
Does It Have to Be Java?
For many people, Web applications are synonymous with object-oriented programming in Java. However, this is not really true: a Web application can be written in Java, but does not have to be. Remember that there are two main types of Web applications:- HTML-based
- Applet-based
In applet-based applications, Java applets get downloaded to the client and run there. An applet controls each pixel of the user interface and can react with pixel precision to mouse events and other user interaction.
You can also write full applications in Java. These are similar to applets but are installed on the client and run in a Java virtual machine. This is comparable to writing client applications in C++ or Visual Basic and is outside the scope of this book.
Choose Your Weapon
To decide what development and deployment approach is right for you, you need to consider the needs of your users:- Who will be using your application? Intranet, extranet, Internet users?
- How complex is the user interface you need?
You will also need to consider whether you need a rich, full-featured user interface like you find in traditional client/server applications developed with Oracle Forms, or whether an HTML interface will do. If you select an HTML interface, you must also determine if your users can live with a simple standard interface, or you need to use sophisticated HTML programming to realize the application your users need.
The decisions you need to make are documented in the flowchart in Figure 2-1.
Where Are Your Users?
In an ideal world, you would be able to deploy every application to every Web browser and not worry where your users are. Unfortunately, real-world concerns like limited bandwidth and imperfect support for the various Web standards make it necessary that you give some thought to where your users are.- Intranet
- Extranet
- Internet
On the Intranet
If your application is intended purely for internal use on your organization's intranet, generally all the options will be open to you: you probably have good network connections to every client, and you only have to contend with one browser (or at most, a few different versions). But if some users will be using ultra-light clients like PDAs (personal digital assistants) or smart phones to access your application, you have the limitations of an Internet application.
On an Extranet
If your application is also intended for partners on an extranet, you must carefully consider whether Java is still an option. You have three main points to consider.What Browser Will My Users Have? Like most other Internet technologies, the Java language has developed rapidly. Early browsers supported only Java 1.0; later generation browsers have not kept up with the development of the Java language (now in version 1.4) but have concentrated on supporting Java 1.1 adequately (see Table 2-1)....
Customer Reviews
Average Review: