Rational Quality Manager: CRJAZ0808I The driver "com.microsoft.sqlserver.jdbc.SQLServerDriver" could not be loaded and registered

Technote (troubleshooting)


Problem(Abstract)

This technote explains how to resolve an CRJAZ0808I error, that can occur when logging in to IBM Rational Quality Manager.

Symptom

The following symptom is observed only if Rational Quality Manager is started as a service. After entering User ID and Password to log in to Rational Quality Manager, It will stay in the "Loading" state and never complete.

The following error can be found in the jazz.log:


    CRJAZ0808I The driver "com.microsoft.sqlserver.jdbc.SQLServerDriver" could not be loaded and registered. Support for some database vendors requires that the JDBC driver JAR be provided in a path configured by the server scripts. If you are experiencing problems changing the database vendor, refer to the product setup instructions for more information.

Cause

When Rational Quality Manager server is started as a service, the server.startup.bat is not executed. The command "set SQLSERVER_JDBC=%START_DIR%\sqlserver" in the server.startup.bat is not executed to set the location of the SQL JDBC driver.

Resolving the problem

To resolve this issue:
1. Remove the existing IBM Rational Quality Manager service by running the following command:

rqm.service.bat remove
Note: By default, the above bat file is in (C:\Program Files\IBM\RQM201\server)

2. Modify the rqm.service.bat to add the location of the SQL JDBC driver as one of the JvmOptions. For example, if the SQL JDBC driver (sqljdbc.jar) is in the default directory "C:\Program Files\IBM\RQM201\server\sqlserver", you must modify the rqm.service.bat file similar to the following:
"%EXECUTABLE%" //US//%SERVICE_NAME% --JvmOptions "-Dcatalina.base=%CATALINA_BASE%;-Dcatalina.home=%CATALINA_HOME%;-Djava.endorsed.dirs=%CATALINA_HOME%\common\endorsed
;-DSQLSERVER_JDBC=C:\Progra~1\IBM\RQM201\server\sqlserver" --StartMode jvm --StopMode jvm

3. Run rqm.service.bat install 2.0.1 to install the service again with the new JVM option.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Rational Quality Manager
Database

Software version:

2.0.1

Operating system(s):

Windows

Software edition:

Express Edition, Standard Edition

Reference #:

1430707

Modified date:

2010-05-14

Translate my page

Machine Translation

Content navigation