QUICK LINKS
Support
Issue Tracker
[Services]
Questions
[uAchieve 4.5 Applications]
[uAchieve 5.0 Application]
[uAchieve 5.1 Application]
Transferology
TES
[Training & Conferences]
Accessibility
Information for installing the Transferology Connector 4.4.x on Tomcat
You must have a JDBC driver in the server's classpath in order for the Transferology Connector to connect to the database.
No Longer Necessary
This is no longer necessary because the necessary log4j files are now included in the ceg44-xx.war, the Connector distribution specifically for Tomcat.
You must configure a JNDI Data Source for your CollegeSource database. The data source specifies a database and user that the Transferology Connector will use to access the database. For the specific CollegeSource tables that will be accessed by the Transferology Connector, see Required DARS Tables or Required uAchieve Tables, depending upon your CollegeSource Degree Audit product.
Keep the following points in mind when defining a data source in Tomcat:
Choose the correct web context xml file based on your Tomcat version, database type and jdbc driver.
Keep in mind, you must always supply the correct values for your database in the following attributes: password, username, url, and driverclassname
The following shows an example Tomcat 5.5.x, 6.0.x or 7.0.x web context xml file with 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, 6.0.x or 7.0.x web context xml file with data source definition for a 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, 6.0.x or 7.0.x web context xml file with 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>
Choose one of the above Tomcat web context xml files based on your database type and add the following xml above the <WatchedResource> elements.
<JarScanner> <JarScanFilter tldScan="displaytag-1.1.jar,freemarker-2.3.15.jar,jawr-3.3.3.jar,jtidyservlet-r8.jar,sitemesh-2.4.2.jar,spring-modules-validation-0.8a.jar,spring-webmvc-3.0.6.RELEASE.jar,standard-1.1.2.jar,unstandard-1.0.jar"/> </JarScanner>
The following shows an example Tomcat 8.0.x, 8.5.x or 9.0.x web context xml file with data source definition for an Oracle database:
<Context reloadable="true"> <JarScanner> <JarScanFilter tldScan="displaytag-1.1.jar,freemarker-2.3.15.jar,jawr-3.3.3.jar,jtidyservlet-r8.jar,sitemesh-2.4.2.jar,spring-modules-validation-0.8a.jar,spring-webmvc-3.0.6.RELEASE.jar,standard-1.1.2.jar,unstandard-1.0.jar"/> </JarScanner> <!-- 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>
cas4.properties
Deploy Errors on Tomcat 7
We have seen several schools encounter deployment errors on Tomcat 7. Follow these steps if you encounter deployment errors on Tomcat 7:
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