Page History

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

...

8

...

2. Add Log4j Framework to classpath

3. Configure Data Source

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:

• Tomcat data sources are defined in a Tomcat web context xml file located in the /TOMCAT_HOME/conf/Catalina/localhost directory.
• The Tomcat web context xml 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

...

Please use one of the download Tomcat web context links below. Don't copy the HTML page, since it contains hidden characters or spacing which are incompatible with the xml file.

...

.

...

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

Rename the downloaded Tomcat web context file to match the basename of the Transferology Connector war file.

...

0.x,

...

Download the Tomcat-context-oracle-older.xml for an Oracle database.

...

...

8

...

.

...

<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>

Download the Tomcat-context-db2-older.xml for a DB2 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> 

...

5.x, 9.0.x

Choose one of the above below Tomcat web context xml files based on your database type and add the following xml above the <WatchedResource> elements.

...