Overview of GuestBook PSP Sample
--------------------------------------
This Sample describes how to create a simple Guestbook application
using PSPs.
The PSP application provides an interface to submit the comments and
a page that
will display all the existing comments.
The inputs submitted through the intial signing page to another page
which will insert
the values into the database table. After inserting the values successfully,
it will call
the page which displays all the comments stored. If any error happens
during the
operation, that will be returned by the Error page.
In the View_Guestbook page where all the existing comments are displayed,
the
details are displayed in the order of the latest comments first. Also,
the comments
entered on the system date is displayed in RED and others in BLACK.
Steps in the Sample :
---------------------
1) Invoke the application by opening the Guest_Book page. This
will display the
interface to sign the GuestBook.
2) Submit the comments in through the above page. On successful
submission the
application will display all the comments
in View_Guestbook page with the latest
message at the top.
Description of Sample Files :
-----------------------------
The sample is provided as a zip file. This zip file contains all the
files required for
the sample. It contains the following files:
1) Install.html
- The steps to install the GuestBook PSPs in the Oracle Database
2) Readme.html
- This file
3) Guest_Book.psp
- Displays the Form to enter the comments.
4) Submit_Comments.psp - Stores
the comments submitted from the form into the database.
5) View_GuestBook.psp -
Displays the all the comments stored in the database.
6) Gb_Error_Page.psp
- Error page of the sample.
The steps in running the sample in iAS environment is explained below :
Running the sample using Oracle iAS:
--------------------------------------
Step 1. Install the PSPs onto the Oracle database
using the instructions
in the Install.html.
Step 2. On the Application Server machine where
iAS is installed, create
a Database Access Descriptor(DAD) to connect to the schema where
the PSP is installed in Step 1.
Note: For details on creating DADs, refer to the document "Using mod_plsql"
on the Documentation Library CD-ROM of iAS software.
Step 3. After creating the DAD, access the
page by using a URL like:
http://<ipaddress>:<Port>/<virtual_path>/<dadname>/<PL/SQL
procedure name>
where,
<ipaddress> -> is the ip-address of the
machine on which iAS is setup
<Port>
-> is the port on which iAS http listener is setup to run
(refer to file $IAS_HOME/Apache/Apache/conf/httpds.conf)
<virtual_path> -> is the prefix defined for the PL/SQL module
(refer to file $IAS_HOME/Apache/modplsql/cfg/plsql.conf)
<dadname> -> is the name of the
DAD created in Step 2.
Example:
http://152.69.168.104:7890/pls/sample/guest_book