How to setup the database environment variable for RQM in a UNIX environment

Technote (FAQ)


Question

How do you set the database environment variable for IBM Rational Quality Manager (RQM) in a UNIX environment?

Cause

In the documentation, there are multiple instances where you will be asked to set the environment variable.

This could be ORACLE_JDBC_DRIVER_FILE or SQLSERVER_JDBC_DRIVER_FILE.

One example is step 5d of Setting up an Oracle database.


Answer

When using Tomcat as your application server, you will follow these instructions:

  1. Stop the Tomcat server

  2. Navigate to {RQM_Install_Directory}/server

  3. Open the ./server_startup.sh file in a text editor

  4. On the second line (directly below "#!/bin/sh"), add a blank line

  5. For Oracle connections add the following line
    export ORACLE_JDBC_DRIVER_FILE=<Absolute path to the JDBC driver>/ojdbc5.jar

  6. For SQLServer connections add the following line
    export SQLSERVER_JDBC_DRIVER_FILE=<Absolute path to the JDBC driver>/sqljdbc4..jar

  7. Save the changes to the file

When using WebSphere Application Server, please follow the instructions outlined in Setting up a WebSphere Application Server.


Rate this page:

(0 users)Average rating

Document information


More support for:

Rational Quality Manager
Database

Software version:

3.0.1

Operating system(s):

AIX, Linux, Solaris

Reference #:

1578736

Modified date:

2012-03-29

Translate my page

Machine Translation

Content navigation