How to install DB Prism-Cocoon under Sun JavaWebserver 2.0 (DB Prism 1.0.1-production Cocoon 1.7.4)
Resources:
  Sun Java Web Server: http://www.sun.com/software/jwebserver/index.html
  Cocoon: http://cocoon.apache.org/
  DBPrism: http://www.dbprism.com.ar/
 
1. Install Sun JavaWebServer 2.0 
   <server_root> stand for Sun Java WebServer main directory installation.
   <cocoon_root> stand for Apache Cocoon main directory installation.
   <prism_root>  stand for Prism main directory installation.                                                           
 
2. Unpack Cocoon libs under <server_root>/classes or add to CLASSPATH variable 
        # cd <server_root>/classes 
        # jar xvf <cocoon_root>/lib/ant.jar 
        # jar xvf <cocoon_root>/lib/fop_0_12_1.jar 
        # jar xvf <cocoon_root>/lib/stylebook-1.0-b2.jar 
        # jar xvf <cocoon_root>/lib/xalan_1_0_1.jar 
        # jar xvf <cocoon_root>/lib/xerces_1_0_3.jar 

2. Unpack JDBC classes under <server_root>/classes or add to CLASSPATH variable
        # cd <server_root>/classes 
        # jar xvf <oracle_home>/jdbc/lib/classes111.zip 
 
3. Unpack Cocoon Framework under <server_root>/servlets or add to CLASSPATH variable
        # cd <server_root>/servlets 
        # jar xvf <cocoon_root>/bin/cocoon.jar 
 
4. Unpack DB Prism Engine under <server_root>/servlets or add to CLASSPATH variable
        # cd <server_root>/servlets 
        # jar xvf <prism_root>/bin/Prism.jar 
 
5. Start JavaWebServer 
        # <server_root>/bin/httpd 
 
6. With your favorite browser start admin applet, load the URL: 
        http://server:9090/index.html 
        or use script 
        # <server_root>/bin/admin  
   If you have just installed, type admin for user and password. Then login. 

7. Select Java Web Server -> Web Service 8080 and choose Manage. 
 
8. Press Servlets Button (upper right corner). 
 
9. Select "Add" in tree view. 
For Cocoon: 
  - Fill the boxs with this values: 
        Servlet Name: Cocoon 
        Servlet Class: org.apache.cocoon.Cocoon
        Bean Servlet: No 
  - And Press button "Add" 
  Then with Configuration Pane: 
  - Fill the boxs with this values: 
        Description: Cocoon Framework 
        Servlet Class: org.apache.cocoon.Cocoon
        Load at Startup: Yes or No. 
        Loaded Now: No 
        Load Remotely: No 
  Select Properties Pane: 
  - Press button "Add" 
  - Fill the boxs with this values:
        name: properties 
        Value: <cocoon_root>/conf/cocoon.properties 
  - Press "Modify" and then "Save" 
For DB Prism: 
  - Fill the boxs with this values: 
        Servlet Name: Prism 
        Servlet Class: com.prism.ServletWrapper
        Bean Servlet: No 
  - And Press button "Add" 
  Then with Configuration Pane: 
  - Fill the boxs with this values: 
        Description: DB Prism Engine 
        Servlet Class: com.prism.ServletWrapper
        Load at Startup: Yes or No. 
        Loaded Now: No 
        Load Remotely: No 
  Select Properties Pane: 
  - Press button "Add" 
  - Fill the boxs with this values: 
        name: properties
        Value: <prism_root>/conf/prism.properties
  - Press "Modify" and then "Save" 
 
10. Return to Setup area (press button "Setup" in upper left corner) 
  Select File Aliases in the tree view, and press "Add". 
  - Fill the boxs with this values: 
  Alias Pathname                Full Pathname 
  /xsl                          <prism_root>/xsl 
  /samples                      <cocoon_root>/samples 
  and press "Save" 
   
  Select Servlet Aliases in the tree view, and press "Add". 
  - Fill the boxs with this values: 
  Alias                         Servlet Invoked 
  *.xml                         Cocoon
  /servlet/xml                  Cocoon
  /servlet/xmld                 Cocoon
  /servlet/plsql                Prism
   
11. Add to cocoon.properties this lines: 
########################################## 
# Prism DB Producer params
# properties.plsql must be point to corrected prism.properties file !!! 
########################################## 
producer.type.db = com.prism.CocoonWrapper
producer.properties.db = /usr/local/prism/prism.properties

########################################## 
# Header Processor, set this to work with cookies, redirect url and dymamic login 
########################################## 
processor.type.http = com.prism.HeaderProcessor
 
########################################## 
# Prism Excel Formatter, simple formatter to generate Excel output see PLSQL demo source for details of usage 
########################################## 
formatter.type.application/vnd.ms-excel = org.apache.cocoon.formatter.TextFormatter
formatter.application/vnd.ms-excel.MIME-type = application/vnd.ms-excel

12. Check <prism_root>/Readme.txt for prism.properties configuration tasks (JDBC drivers, DADs, and so on) 
 
13. Restart Sun Java Web Server 
 
14. Check if Cocoon work fine:
        http://server:8080/Cocoon.xml 
        Verify if there are entrys in Formatters (Excel Formatter) and Processor (HeaderProcessor)
        Samples at:
        http://server:8080/samples/index.xml 
15. Install PLSQL Packages in Oracle Data Base according to the instruction in <prism_root>/Readme.txt and 
<prism_root>/Demos.txt (XML Demos Part) 
 
16. Check if Prism work fine: 
        http://server:8080/servlet/plsql/demo.startup 
 
17. Enjoy Prism-Cocoon 
 
Marcelo F. Ochoa (mochoa@ieee.org)