View Source

Information for installing the Transferology Connector 4.4.x 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

JBoss sites do not have to do anything because since Log4j is automatically provided.

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>

Remember: You must always supply the correct values for your database in these elements: <password>, <user-name>, <connection-url> and <driver-class>

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