Java Memory and Socket Timeout Parameters

We recommend the following Sun Java Memory and Socket Timeout Parameters to override the default values:

-Xms256m -Xmx512m -XX:MaxPermSize=128m -Dsun.net.client.defaultReadTimeout=30000 -Dsun.net.client.defaultConnectTimeout=8000

Download the Transferology Connector

You can acquire the 4.3.x release from the u.select Connector Downloads page.

Logging Framework and Necessary Files

The Connector relies on the log4j framework for logging. This framework depends on the log4j.properties file for its configuration. Each application server requires different instructions to enable logging for the Connector.

Identify CollegeSource Audit Daemon

If you are not using the Degree Audit functionality, you can proceed to the next section: Create cas4.properties

The Transferology Connector uses the CollegeSource job_queue_list table to exchange audit requests and results with a degree audit daemon. For this to work successfully, the Transferology Connector must be configured with the correct value from the daemon's server_name property.

Be sure to follow the correct instructions based on your degree audit implementation: DARwin or u.achieve

DARwin daemon.cfg

For example, assume your DARwin daemon.cfg has the following daemon entry:

[connector]

### Database Connection Parameters
jdbc_driver = oracle.jdbc.driver.OracleDriver
jdbc_url = jdbc:oracle:thin:@prod.osu.edu:1525:DARSDB
server_user = darsdbuser
server_pass = darsdbpassword
reconn_tries = 20
reconn_wait = 60

### Database Environment Parameters
# server_name must match u.select server name for audits to be processed by DARS engine
server_name = osu_prod
delete_jobq = N
db_multi_wc = %
db_single_wc = _

### Daemon Environment Parameters
working_dir = D:\DARS\DARNT358\DARNT358_connector\DARwin\bin
darsql_dir = D:\DARS\DARNT358\DARNT358_connector\DARwin\bin
data_dir = D:\DARS\DARNT358\DARNT358_connector\DARwin\bin\data
env_file = daemon.env
end_script =
debug_mode = N
### socket_port = -1

### Daemon Performance Parameters
max_jobs 	= 5
wait_time 	= 5
auto_batch 	= N
auto_batch_lim = 1

server_name = osu_prod

u.achieve daemonContext.xml

The minimum u.achieve version is 4.0.14. The default configuration for u.achieve will not produce audits for u.select. You need to add a uachieve.daemon.RequestHandler for the u.select audits. See daemonContext.xml for complete information on the u.achieve RequestHandler. The key points for the new RequestHandler are as follows:

1. Specify a unique serverName property
2. Enable text report audit output
3. Disable loading local student data
4. Disable loading SIS student data

The following is an example RequestHandler that you can add into the u.achieve daemonContext.xml:

<bean id="uselectHandler" class="uachieve.daemon.RequestHandler" scope="prototype">

  <property name="comKey">
    <value>ONL</value>
  </property>
  
  <property name="serverName">
    <value>USEL</value>
  </property>
  
  <property name="sleepTime">
    <value>3</value>
  </property> 
  
  <property name="enabledReports">
    <util:map>
      <entry key="TXT" value="TRUE" />
    </util:map>
  </property>
  
  <!-- true/false -->
  <property name="deleteRequest">
    <value>false</value>
  </property>
  
  <!-- name of file in the ../config directory -->
  <property name="fileNameIncludeTextTop">
    <value></value>
  </property>
  
  <!-- name of file in the ../config directory -->
  <property name="fileNameIncludeTextBottom">
    <value></value>
  </property>

  <property name="loadLocalStudentData">
    <value>false</value>
  </property>

  <property name="loadSISStudentData">
    <value>false</value>
  </property>

  <lookup-method name="createAuditProcessor" bean="auditProcessor"/>  
    
  <property name="auditService"><ref bean="uachieve-slayer.auditService"/></property>
  <property name="supportService"><ref bean="uachieve-slayer.supportService"/></property>
  <property name="requestQueue"><ref local="jobRequestQueue"/></property>
    
</bean>

<value>USEL</value>

Create cas4.properties

The cas4.properties is required for the Transferology Connector.

Define the CollegeSource audit/equivalency product you are using with the daversion property of the cas4.properties file.

DARwin

daversion=darwin

u.achieve

 daversion=uachieve

Schools that DO NOT want to use the Degree Audit functionality of the Transferology Connector need the following line in their cas4.properties:

# disable audit polling
xservice.pollingEnabled=false

Schools that DO want to use the Degree Audit functionality of the Transferology Connector must have the xservice.darwinDaemonServerName property. It must equal the server_name value that was identified above in the Identify CollegeSource daemon section.

Schools that want to use the Equivalency functionality of the Transferology Connector must define additional information.

• Schools that want to provide equivalencies for only one school define several additional properties in the cas4.properties file
• Schools that want to provide equivalencies for more than one school must define and use a ceg-model.xml file

Connector Provides Equivalencies for a Single Target School

Equivalencies for a single school must define the following properties:

• ceg.webPrefix - The correct protocol for links to your Transferology Connector
• ceg.domainName - The correct domain for links to your Transferology Connector
• ceg.serverPort - The correct server port for links to your Transferology Connector
• ceg.cgiPath - The correct web context for links to your Transferology Connector
• ceg.uniq - The u.select UNIQ for your school
• ceg.defaultUniq - The u.select UNIQ for your school
• ceg.instFullName - The full name of your school
• ceg.instid - Your DARwin instid value
• ceg.instidq - Your DARwin instidq value
• ceg.instcd - Your DARwin instcd value
• ceg.zip - The zip code for your school's main address
• ceg.state - The state abbreviation for your school's main address

Using Ohio State University and the above DARwin daemon.cfg as an example, below is what their cas4.properties would look like:

# Required for audits
xservice.darwinDaemonServerName=osu_prod
# Required for equivalencies, single target school
ceg.webPrefix=http://
ceg.domainName=dars.osu.edu
ceg.serverPort=80
ceg.cgiPath=/ceg43
ceg.defaultUniq=OSU
ceg.uniq=OSU
ceg.instidq=72
ceg.instid=1592
ceg.instcd=
ceg.instFullName=Ohio State University
ceg.state=OH
ceg.zip=43210

Connector Provides Equivalencies for Multiple Target Schools

Equivalencies for multiple target schools must define the following property:

• xservice.model - Instructs the Connector to use the ceg-model.xml file

Assuming that Ohio State hosts a Connector with target equivalencies for all Ohio schools and the above DARwin daemon.cfg as an example, below what their cas4.properties would look like:

# Required for audits
xservice.darwinDaemonServerName=osu_prod
# Required for equivalencies, multiple target schools
xservice.model=model

Using the ceg-model.xml

The following is an example of the ceg-model.xml for more than one school. The descriptions of the cas:server and cas:institution attributes are the same as in the previous section's ceg. prefixed properties.

<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:util="http://www.springframework.org/schema/util"
       xmlns:cas="http://www.transfer.org/schema/cas"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
                           http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
                           http://www.springframework.org/schema/util
                           http://www.springframework.org/schema/util/spring-util-2.0.xsd
                           http://www.transfer.org/schema/cas
                           http://www.transfer.org/schema/cas/cas.xsd">

 <cas:server id="cegServer" webPrefix="http://" domainName="dars.osu.edu" cgiPath="/ceg43" serverPort="80" defaultUniq="OSU" >

   <cas:institution id="i1" uniq="OSU"  instidq="72" instid="1592"   instcd="   " instFullName="Ohio State University" 
           state="OH" zip="43210" defTimeout="6000" />

   <cas:institution id="i2" uniq="CSCC" instidq="73" instid="006867" instcd="   "  instFullName="Columbus State Community College"
           state="OH" zip="43216" defTimeout="6000" />

 </cas:server>

</beans>

Synching iname between MASTREF and TCA_MASTER

For the u.select Equivalencies by Course to work correctly, the TCA_MASTER iname values must be the same as the MASTREF iname values. You can synch the TCA_MASTER iname with the one of the following UPDATE statements. NOTE: The examples show an update for BGSU. You must use the correct instidq and instid values for your school.

# oracle
update tca_master t set (iname) = (select m.iname FROM mastref m 
WHERE m.instidq=t.instidq and m.instid=t.instid and m.source_id=t.source_id
and m.source_cd=t.source_cd and m.MRFYT=t.FYT) 
where t.INSTIDQ='73' and t.INSTID='003018';

# sql server
update  t set t.iname= m.iname from tca_master t inner join  mastref m on m.instidq=t.instidq 
and m.instid=t.instid and m.source_id=t.source_id and m.source_cd=t.source_cd
and m.MRFYT=t.FYT where t.INSTIDQ='73' and t.INSTID='003018'

Install on your Application Server

Follow the instructions below that are specific to your application server:

• Install Connector on Tomcat
• Install Connector on JBoss
• Install Connector on OAS
• Install Connector on Weblogic

View Home page

Use your Web browser to view the Connector's home page. Using the above OSU example, the correct URL is: http://dars.osu.edu/ceg43/cegHome.htm

If everything is configured correctly, you should see a page that shows some of the information defined by your cas4.properties file.