Connector on JBoss

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.

Copy their desired JDBC driver into the /JBOSS_HOME/server/default/lib directory.

2. Add Log4j Framework to classpath

3. Configure Data Source

You must configure a JNDI Data Source for your DARwin or u.achieve database. The data source specifies a database and user the Connector will use to access the database. For the specific tables that will be accessed by the Connector, see Required DARS Tables or Required uAchieve Tables depending on your CollegeSource degree audit product.

Keep these points in mind when defining a data source in JBoss:

• JBoss data sources are defined in xml configuration files located in the /JBOSS_HOME/server/default/deploy directory.
• The xml configuration file name must match this file spec: *-ds.xml
  
  • For example, you could use a file named: ceg4-ds.xml

Example Oracle Data Source

The following shows an example JBoss data source definition for an Oracle database. (NOTE: The jndi-name must be "EDAG_DARS"):

<datasources>
<local-tx-datasource>
   <jndi-name>EDAG_DARS</jndi-name>
   <connection-url>jdbc:oracle:thin:@localhost:1521:XE</connection-url>
   <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
   <user-name>thepassword</user-name>
   <password>theuser</password>
</local-tx-datasource>
</datasources>

Example SQL Server Data Source

The following shows an example JBoss data source definition for a SQL Server database using the JTDS driver. (note the jndi-name must be "EDAG_DARS"):

<datasources>
<local-tx-datasource>
   <jndi-name>EDAG_DARS</jndi-name>
   <connection-url>jdbc:jtds:sqlserver://localhost/dars35</connection-url>
   <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
   <user-name>thepassword</user-name>
   <password>theuser</password>
</local-tx-datasource>
</datasources>

Example DB2 Data Source

The following shows an example JBoss data source definition for a DB2 database. (note the jndi-name must be "EDAG_DARS"):

<datasources>
<local-tx-datasource>
   <jndi-name>EDAG_DARS</jndi-name>
   <connection-url>jdbc:db2:yourdatabase</connection-url>
   <driver-class>COM.ibm.db2.jdbc.app.DB2Driver</driver-class>
   <user-name>thepassword</user-name>
   <password>theuser</password>
</local-tx-datasource>
</datasources>

4. Deploy Transferology Connector

• Copy cas4.properties to /JBOSS_HOME/server/default/conf/ directory
• Copy ceg4-ds.xml to /JBOSS_HOME/server/default/deploy/ directory
• Copy ceg4.war to /JBOSS_HOME/server/default/deploy/ directory
• Start JBoss if it isn't already started.
• JBoss will automatically create the /JBOSS_HOME/server/default/deploy/ceg4/ directory structure