View Source

Information for installing the Transferology Connector 4.3.x on Tomcat

1. Add JDBC Driver to classpath

You must have a JDBC driver in the server's classpath in order for the Transferology Connector to connect to the database.

Tomcat 6.0 sites should copy their desired JDBC driver into the /TOMCAT_HOME/lib directory.
Tomcat 5.5 sites should copy their desired JDBC driver into the /TOMCAT_HOME/shared/lib directory.

2. Add Log4j Framework to classpath

This is no longer necessary because the necessary log4j files are now included in the ceg43-xx.war, the u.select Connector distribution specifically for Tomcat.

3. Configure Data Source

You must configure a JNDI Data Source for your redLantern database. The data source specifies a database and user that the Transferology Connector will use to access the redLantern database. For the specific redLantern tables that will be accessed by the Transferology Connector, see Required DARS Tables or Required u.achieve Tables, depending upon your redLantern Degree Audit product.

Keep the following points in mind when defining a data source in Tomcat:

Tomcat data sources are defined in xml configuration files located in the /TOMCAT_HOME/conf/Catalina/localhost directory.
The xml configuration file name must match the base name of the application. For example, if you plan to deploy the Transferology Connector as ceg4.war, then you must define the data source in a file named ceg4.xml

The following shows an example Tomcat 5.5.x or 6.0.x data source definition for an Oracle database:

<Context reloadable="true">

 <!-- Default set of monitored resources --> 
 <WatchedResource>WEB-INF/web.xml</WatchedResource> 
 <WatchedResource>WEB-INF/*</WatchedResource> 

   <Resource
      auth="Container"
      type="javax.sql.DataSource"
      driverClassName="oracle.jdbc.driver.OracleDriver"
      name="jdbc/DARS"
      password="thepassword"
      username="theuser"
      url="jdbc:oracle:thin:@localhost:1521:XE"
      validationQuery="select 1 from dual"
      maxIdle="4"
      maxActive="8"
      autoCommit="false" />
</Context>

The following shows an example Tomcat 5.5.x or 6.0.x data source definition for an SQL Server database:

<Context reloadable="true">

 <!-- Default set of monitored resources --> 
 <WatchedResource>WEB-INF/web.xml</WatchedResource> 
 <WatchedResource>WEB-INF/*</WatchedResource> 

   <Resource
      auth="Container"
      type="javax.sql.DataSource"
      driverClassName="net.sourceforge.jtds.jdbc.Driver" 
      name="jdbc/DARS"
      password="thepassword"
      username="theuser"
      url="jdbc:jtds:sqlserver://localhost/dars35"
      validationQuery="select 1"
      maxIdle="4"
      maxActive="8"
      autoCommit="false" />
</Context>

The following shows an example Tomcat 5.5.x or 6.0.x data source definition for a DB2 database:

<Context reloadable="true">

 <!-- Default set of monitored resources --> 
 <WatchedResource>WEB-INF/web.xml</WatchedResource> 
 <WatchedResource>WEB-INF/*</WatchedResource> 

   <Resource
      auth="Container"
      type="javax.sql.DataSource"
      driverClassName="COM.ibm.db2.jdbc.app.DB2Driver"
      name="jdbc/DARS"
      password="thepassword"
      username="theuser"
      url="jdbc:db2:yourdatabase"
      validationQuery="SELECT 1 FROM sysibm.sysdummy1"
      maxIdle="4"
      maxActive="8"
      autoCommit="false" />
</Context>

The following shows an example Tomcat 5.0.x data source definition for an SQL Server database:

<Context path="/ceg4" docBase="${catalina.home}/webapps/ceg4" 
        debug="0" privileged="true" reloadable="true"> 

 <!-- Default set of monitored resources --> 
 <WatchedResource>WEB-INF/web.xml</WatchedResource> 
 <WatchedResource>WEB-INF/*</WatchedResource>     
            
<Resource name="jdbc/DARS" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/DARS">
	<parameter>
		<name>driverClassName</name>
		<value>net.sourceforge.jtds.jdbc.Driver</value>
	</parameter>
	<parameter>
		<name>url</name>
		<value>jdbc:jtds:sqlserver://192.168.24.29:1433/dars35</value>
	</parameter>
	<parameter>
		<name>validationQuery</name>
		<value>select 1</value>
	</parameter>
	<parameter>
		<name>username</name>
		<value>dars35user</value>
	</parameter>
	<parameter>
		<name>password</name>
		<value>dars35userpass</value>
	</parameter>
	<parameter>
		<name>maxActive</name>
		<value>8</value>
	</parameter>
	<parameter>
		<name>maxIdle</name>
		<value>4</value>
	</parameter>
</ResourceParams>
     
</Context>

Keep in mind, you must always supply the correct values for your database in the following attributes: password, username, url, and driverclassname

4. Deploy Transferology Connector

Copy ceg4.xml to /TOMCAT_HOME/conf/Catalina/localhost/ directory
Copy ceg4.war to /TOMCAT_HOME/webapps/ directory
Start Tomcat if it is not already started
Tomcat will automatically create the /TOMCAT_HOME/webapps/ceg4/ directory structure
You must copy the files you initially created/edited while following instructions on the main Install and Configure page. Copy the following files into the /TOMCAT_HOME/webapps/ceg4/WEB-INF/classes/ directory:

cas4.properties

We have seen several schools encounter deployment errors on Tomcat 7. Follow these steps if you encounter deployment errors on Tomcat 7:

Remove the catalina-5.5.23.jar and catalina-ant-5.5.23.jar files from the TOMCAT webapps/ceg4/WEB-INF/lib directory.
Delete all lines in the TOMCAT webapps/ceg4/WEB-INF/jsp/req.jsp file and save the file. After saving, the file should have a size of 0 bytes.
Stop and start Tomcat

5. Specify Path and File for Logging

Locate the log4j.properties file in this direcory /TOMCAT_HOME/webapps/ceg4/WEB-INF/classes/

Follow the short steps on this page: Configure Connector logging to a file