Schemation 'Console' Installation steps.
The Schemation Console is a web-application (war file) that runs in a apache/tomcat installation.

   1) The 'Server' (which does all the work),
   2) The 'Console/WebApp ' (a browser-based interface that Schemation users use to administer their database environments, and
   3) The 'API' (the programatic) interface that provides developers full control over their environment.

This page dscribes the steps installing the 'Server' component.

Console Install
Prerequisites
i Apache/Tomcat Install You will need an Apache/Tomcat installation (5.5 or higher). It is not with the scope of this document to describe how to install this and would therefore recommend you to visit the Apache/Tomcat website if you do not currently have this installed.

ii DEM Server installed The Schemation DEM Console needs to communicate with the DEM Server. If you do not currently have this installed please follow the instructions here before proceeding.

iii Downloaded Install file release_1_0-web.tar.gz
Overview
iii Five minute install tbd

Steps
1 Install Oracle Drivers. If you have not already done so as part of the Apache/Tomcat install, copy the Oracle jdbc (ojdbc14.jar) library from the Oracle client installation directory ($ORACLE_HOME/jdbc/lib) into the <TOMCAT_HOME>/common/libs directory so that the Schemation application can connect to the Oracle database.

cp $ORACLE_HOME/jdbc/lib/ojdbc14.jar < TOMCAT_HOME>/common/libs/


2 Deploy the Schemation application Copy the schemation.war file to the <TOMCAT_HOME>/webapps directory. If tomcat is running, the package should be automatically unpacked and deployed.

cp <destination dir>/release_x_y_z/web/release_x_y_z.war <TOMCAT_HOME>/webapps/


Edit <TOMCAT_HOME>/conf/Catalina/localhost/test_release_1_0.xml


    <Context reloadable="true" debug="1">
      <Resource name="jdbc/schemation"
        auth="Container"
        type="javax.sql.DataSource"
        factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
        driverClassName="oracle.jdbc.driver.OracleDriver"
        removeAbandoned="true"
        removeAbandonedTimeout="30"
        maxActive="50"
        maxIdle="3"
        maxWait="10000"
        username="@schemation_www@"
        password="@schemation_www_passwd@"
        url="@jdbc_connectstring@"
        accessToUnderlyingConnectionAllowed="true"/>
    </Context>
       


Changing the @txt@ field to match your username/password and connect strings for your Schemation installation, for example

        username="SCHEMATION_WWW"
        password="SCHEMATION_WWW"
        url="<url="jdbc:oracle:thin:@127.0.0.1:1521:schm"">
3 Starting the application (DEM Console) Go to ...
cd <TOMCAT_HOME>/bin directory.

./startup.sh
For testing the application see 'Testing the Install' section. Stopping the application
4 Testing the DEM Console To test the applications go to:
http://localhost:8080/schemation/ or http://localhost:8080/release_x_y_z/
Login using username/password: schadmin/schadmin
Please change your admin password upon logon
5 Stopping the application (DEM Console) Go to ...
cd <TOMCAT_HOME>/bin directory.

./shutdown.sh