SMWP - Uninstall
 

Index

Introduction
Differences
Installation I
Installation II
Installation III
Uninstall

Working with SMWP

Parameter
Fragement Class
Page Class
XML Document (Page)



3.4 Uninstall

3.4.1 Remove SMWP database objects

Before removing SMWP database objects all page classes, fragment classes and parameters have to be removed manually (see 4.10 Delete Fragment Class, 4.14 Delete Page Class, 4.6 Delete Parameter). The deletion of database objects is supported by this script in c:\smwp\sqlscripts\dropall.sql. Executing this script works by login onto the database with SQLPlus and entering @scriptname on the SQL-Prompt. This script deletes the created database types (Tcolumn and TcolumnTable), as well as all PL/SQL packages and metadata relations. Created relations such as fragment class relations are not removed by the script.

3.4.2 Remove SMWP-Java Stored Procedures

The Java Packages loaded into the database are located in directory c:\smwp\applet\lib. Remove these packages from database by using following commands from the command console:

dropjava -force -user dbUsername/dbPassword@dbSchema smwp.jar
dropjava -force -user dbUsername/dbPassword@dbSchema apache\xalan2.2.D6.jar
dropjava -force -user dbUsername/dbPassword@dbSchema oracle9i\xmlparserv2.jar
dropjava -force -user dbUsername/dbPassword@dbSchema oracle9i\classes12.jar

3.4.3 Remove SMWP-Servlets

Removing the SMWP servlets takes several steps:

  1. Start the Tomcat web server
  2. Start an Internet Browser and follow the hyperlink http://hostname:8080
  3. Follow the hyperlink "Tomcat Manager" on the top left of the console
  4. Follow the hyperlink "remove" for the application /DB_Wrapper
  5. Delete the directory c:\programme\tomcat\DB_Wrapper and the file c:\programme\tomcat\DB_Wrapper.war
  6. Delete the directory c:\programme\tomcat\cocoon\smwp
  7. Open the file c:\programme\tomcat\webapps\cocoon\sitemap.xmap and delete followingmarked lines:
    <map:pipelines>
    <map:pipeline>
    <map:match pattern="smwp/**">
    <map:mount
    check-reload="yes"
    src="smwp/sitemap.xmap"
    uri-prefix="smwp"/>
    </map:match>

    <map:match ...
    <map:pipeline>
    <map:pipelines>
  8. Restart the Apache Tomcat web server