Skip to main content
CollegeSource Support

Migrating the Student Interfaces

 


If you are currently performing an upgrade from 4.3 or earlier version to 4.4 or later and are using the student interfaces or student lookup feature, a few things in the student interfaces may need to be changed in order to migrate the old student interfaces over. Due to the change in location of property files and the migration of some properties to the database, the following files may need updated:

  • student-ctx.xml
  • customClassContext.xml
  • Collegesource.properties
  • server.properties

Some information may be necessary before beginning this process

  1. Determine if your uAchieve database and SIS database are in the same location or in different locations
  2. Open the old student-ctx.xml and customClassContext.xml, as well as the old server.properties and selfservice-database.properties files. 

NOTE:
Do not copy over old files. The new files provided will need to be configured instead.

Your uAchieve Database and SIS Database are in the SAME Location

student-ctx.xml

In the student-ctx.xml file, the values for some of the properties will need to be updated to allow the system to look for the correct information in the property files.

<bean id="uachieveDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
      <property name="driverClassName" value="${uachieve.selfservice.jdbc.driver}"/>
      <property name="url" value="${uachieve.selfservice.jdbc.url}"/>
      <property name="username" value="${uachieve.selfservice.jdbc.username}"/>
      <property name="password" value="${uachieve.selfservice.jdbc.password}"/>
</bean>

 

The values for the properties of the bean need to be changed here; update the values to point to the location of your uAchieve database information.

Before
      <property name="driverClassName" value="${uachieve.selfservice.jdbc.driver}"/>
      <property name="url" value="${uachieve.selfservice.jdbc.url}"/>
      <property name="username" value="${uachieve.selfservice.jdbc.username}"/>
      <property name="password" value="${uachieve.selfservice.jdbc.password}"/>
After
      <property name="driverClassName" value="${Collegesource.jdbc.driver}"/>
      <property name="url" value="${Collegesource.jdbc.url}"/>
      <property name="username" value="${Collegesource.jdbc.username}"/>
      <property name="password" value="${Collegesource.jdbc.password}"/>

SISDataSource

<bean id="sisDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
      <property name="driverClassName" value="${uachieve.selfservice.jdbc.driver}"/>
       <property name="url" value="${uachieve.selfservice.jdbc.url}"/>
       <property name="username" value="${uachieve.selfservice.jdbc.username}"/>
       <property name="password" value="${uachieve.selfservice.jdbc.password}"/>
</bean>

 

The values for the properties of the bean need to be changed here; update the values to point to the location of the uAchieve database information.

Before
      <property name="driverClassName" value="${uachieve.selfservice.jdbc.driver}"/>
      <property name="url" value="${uachieve.selfservice.jdbc.url}"/>
      <property name="username" value="${uachieve.selfservice.jdbc.username}"/>
      <property name="password" value="${uachieve.selfservice.jdbc.password}"/>
 After
      <property name="driverClassName" value="${Collegesource.jdbc.driver}"/>
      <property name="url" value="${Collegesource.jdbc.url}"/>
      <property name="username" value="${Collegesource.jdbc.username}"/>
      <property name="password" value="${Collegesource.jdbc.password}"/>

customClassContext.xml

In the new customClassContext.xml file, the values for some of the properties need to be updated to allow the system to look for the correct information in the property files.

<bean id="sisDataSource"
class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
          <property name="driverClassName" value="${sis.jdbc.driver}"/>
          <property name="url" value="${sis.jdbc.url}"/>
          <property name="username" value="${sis.jdbc.username}"/>
          <property name="password" value="${sis.jdbc.password}"/>
 </bean>

 

The values for the properties of the bean need to be changed here; update the values to point to the location of the uAchieve database information.

Before
      <property name="driverClassName" value="${sis.jdbc.driver}"/>
      <property name="url" value="${sis.jdbc.url}"/>
      <property name="username" value="${sis.jdbc.username}"/>
      <property name="password" value="${sis.jdbc.password}"/>
After
      <property name="driverClassName" value="${uachieveapi.jdbc.driver}"/>
      <property name="url" value="${uachieveapi.jdbc.url}"/>
      <property name="username" value="${uachieveapi.jdbc.username}"/>
      <property name="password" value="${uachieveapi.jdbc.password}"/>


server.properties

You will need to edit the new server.properties file located in the <%uachieve server home%>/config directory. These properties will need to be filled in with your school's uAchieve database information–the same values that you previously had in the old server.properties file.

uachieveapi.jdbc.driver=
uachieveapi.jdbc.url=
uachieveapi.jdbc.username=
uachieveapi.jdbc.password=

Collegesource.properties

You will need to edit the new Collegesource.properties file located in the <%tomcat home%>/CSIHome directory, or wherever you placed the CSIHome directory when installing the webapps. These properties will need to be filled in with your school's uAchieve database information–the same values that you previously put in the server.properties file.

Collegesource.jdbc.driver=
Collegesource.jdbc.url=
Collegesource.jdbc.username=
Collegesource.jdbc.password=

 

Your uAchieve Database and SIS Database are in DIFFERENT Locations

student-ctx.xml

In the new student-ctx.xml file, the values for some of the properties will need to be updated to allow the system to look for the correct information in the property files.

<bean id="uachieveDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
      <property name="driverClassName" value="${uachieve.selfservice.jdbc.driver}"/>
      <property name="url" value="${uachieve.selfservice.jdbc.url}"/>
      <property name="username" value="${uachieve.selfservice.jdbc.username}"/>
      <property name="password" value="${uachieve.selfservice.jdbc.password}"/>
 </bean>


The values for the properties of the bean needs to be changed here; update the values to point to the location of the uAchieve database information.

Before
      <property name="driverClassName" value="${uachieve.selfservice.jdbc.driver}"/>
      <property name="url" value="${uachieve.selfservice.jdbc.url}"/>
      <property name="username" value="${uachieve.selfservice.jdbc.username}"/>
      <property name="password" value="${uachieve.selfservice.jdbc.password}"/>
After
      <property name="driverClassName" value="${Collegesource.jdbc.driver}"/>
      <property name="url" value="${Collegesource.jdbc.url}"/>
      <property name="username" value="${Collegesource.jdbc.username}"/>
      <property name="password" value="${Collegesource.jdbc.password}"/>


SISDataSource

<bean id="sisDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
      <property name="driverClassName" value="${uachieve.selfservice.jdbc.driver}"/>
      <property name="url" value="${uachieve.selfservice.jdbc.url}"/>
      <property name="username" value="${uachieve.selfservice.jdbc.username}"/>
      <property name="password" value="${uachieve.selfservice.jdbc.password}"/>
</bean>

 

The values for the properties of the beans need to be changed here; update the values to point to the location of the SIS database information.

Before
      <property name="driverClassName" value="${uachieve.selfservice.jdbc.driver}"/>
      <property name="url" value="${uachieve.selfservice.jdbc.url}"/>
      <property name="username" value="${uachieve.selfservice.jdbc.username}"/>
      <property name="password" value="${uachieve.selfservice.jdbc.password}"/>
After
      <property name="driverClassName" value="${sis.jdbc.driver}"/>
      <property name="url" value="${sis.jdbc.url}"/>
      <property name="username" value="${sis.jdbc.username}"/>
      <property name="password" value="${sis.jdbc.password}"/>

server.properties

You will need to edit the new server.properties file located in the <%uachieve server home%>/config directory. These properties will need to be filled in with your school's uAchieve datasource information–the same values that you previously had in the old server.properties file.

uachieveapi.jdbc.driver=
uachieveapi.jdbc.url=
uachieveapi.jdbc.username=
uachieveapi.jdbc.password=

 

You may also have to add a few properties to this file, assuming that they are not already there. If the properties below are not in the file, then add them to the bottom of the file and fill them in with your school’s SIS database information.

sis.jdbc.driver=
sis.jdbc.url=
sis.jdbc.username=
sis.jdbc.password=

Collegesource.properties

You will need to edit the Collegesource.properties file located in the <%tomcat home%>/CSIHome directory, or wherever you placed the CSIHome directory when installing the webapps. These properties will need to be filled in with your school's uAchieve database information–the same values that you previously had in the old server.properties file.

CollegeSource.jdbc.driver=
CollegeSource.jdbc.url=
CollegeSource.jdbc.username=
CollegeSource.jdbc.password=

 

These properties will need to be filled in with your school's SIS information.

sis.jdbc.driver=
sis.jdbc.url=
sis.jdbc.username=
sis.jdbc.password=

 

  • Was this article helpful?