Copy of Connector on JBoss

1. Add JDBC Driver to classpath

You must have a JDBC driver in the server's classpath in order for the u.select 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 redLantern database. The data source specifies a database and user the u.select Connector will use to access the redLantern database. For the specific redLantern tables that will be accessed by the u.select Connector, see Required DARS Tables or Required u.achieve Tables depending on your redLantern Degree Audit product.

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

• JBoss data sources are defined in xml configuration files llocated in the /JBOSS_HOME/server/default/deploy directory.
• The xml configuration file name must match this file spec: *-ds.xml
  • As an 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 u.select 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