Frontier server installation details

The Apache Tomcat and Frontier servlet requires a JAVA distribution. For this installation Java 1.5 was used and its environment variable points to

JAVA_HOME=/usr/java/jdk1.5.0_07

The files xml-apis.jar and xercesImpl.jar are also required by Tomcat and where installed as shown:

[cgamboa@gridui01 xerces-2_8_0]$ pwd
/data/frontier/src/apache-tomcat-5.5.17/common/endorsed/xerces-2_8_0

[cgamboa@gridui01 xerces-2_8_0]$ ls

data     LICENSE.DOM-documentation.html  LICENSE-SAX.html  resolver.jar    
xercesSamples.jar
docs     LICENSE.DOM-software.html       NOTICE            samples         
xml-apis.jar
LICENSE  LICENSE.resolver.txt            Readme.html       xercesImpl.jar

The previuos files can be found on Xerces XML Java Parsers 2.8. A binary distribution was used.

In order to have connectivity between the servlet and the database Oracle JDBC Drivers were used. Thus the library ojdbc14_g.jar was installed in the tomcat’s common/lib subdirectory as shown:

[cgamboa@gridui01 lib]$ pwd
/data/frontier/src/apache-tomcat-5.5.17/common/lib

[cgamboa@gridui01 lib]$ ls

commons-el.jar           jasper-runtime.jar       naming-factory.jar    
servlet-api.jar
jasper-compiler.jar      jsp-api.jar              naming-resources.jar
jasper-compiler-jdt.jar  naming-factory-dbcp.jar  ojdbc14.jar

After Tomcat is installed and the frontier servlet is deployed as described here. Some modifications to the Frontier.xml servlet have to be done in order to have connectivity with the BNL data base.

The files

 FrontierBNL.xml 

For the frontier servlet:

[cgamboa@gridui01 localhost]$ pwd
/data/frontier/src/apache-tomcat-5.5.17/conf/Catalina/localhost

[cgamboa@gridui01 localhost]$ cat FrontierBNL.xml

<?xml version='1.0' encoding='utf-8'?>
<Context debug="99" displayName="froNtier BNL Database Web Application" 
docBase="FrontierBNL" path="/FrontierBNL" reloadable="true">
<Resource auth="Container" name="jdbc/frontier" type="javax.sql.DataSource"
url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=1521)
(HOST=oracle01.usatlas.bnl.gov))(CONNECT_DATA=(SID=bnlsc3)))"
d driverClassName="oracle.jdbc.driver.OracleDriver" validationQuery="select 
* from dual" maxIdle="1"
  maxActive="10" maxWait="-1" username="frontier" password="xxxx" 
logAbandoned="true"/>
</Context>

For the file conf.properties

[cgamboa@gridui01 classes]$ pwd
/data/frontier/src/apache-tomcat-5.5.17/webapps/FrontierBNL/WEB-INF/classes

[cgamboa@gridui01 classes]$ cat config.properties

ServerName=FrontierBNL
DataSourceName=jdbc/frontier
XsdTableName=frontier_descriptors
#MonitorNode=MonAlisa_server_node_name
#MonitorMillisDelay=300000
UseFdoCache=no

And for the web.xml file the part that has to be modified:

[cgamboa@gridui01 WEB-INF]$ pwd
/data/frontier/src/apache-tomcat-5.5.17/webapps/FrontierBNL/WEB-INF

[cgamboa@gridui01 WEB-INF]$ cat web.xml

    <!DOCTYPE web-app
    PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
    "http://java.sun.com/dtd/web-app_2_3.dtd">

<web-app>
    <display-name>Frontier 3</display-name>
    <description>Frontier 3 - XSD v2, writing, finders, etc.</description>
    <session-config>
     <session-timeout>300</session-timeout>    <!-- 300 minutes -->
    </session-config>

    <servlet>
      <servlet-name>FrontierBNL</servlet-name>
      <servlet-class>gov.fnal.frontier.FrontierServlet</servlet-class>
      <load-on-startup>1</load-on-startup>
    </servlet>

    <servlet-mapping>
      <servlet-name>FrontierBNL</servlet-name>
      <url-pattern>/Frontier</url-pattern>
    </servlet-mapping>

    <resource-ref>
        <description>
            This is the refererence to the Oracle data source 
            used to talk to the database configured in Frontier.xml. 
        </description>
        <res-ref-name>jdbc/frontier</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
    </resource-ref>
</web-app>