IBM Support

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

Question & Answer


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.

[{"Product":{"code":"SSUVV6","label":"IBM Engineering Test Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Database","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"3.0.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Product Synonym

Rational Quality Manager

Document Information

Modified date:
16 June 2018

UID

swg21578736