Rational Quality Manager: CRJAZ0808I The driver "com.microsoft.sqlserver.jdbc.SQLServerDriver" could not be loaded and registered
This technote explains how to resolve an CRJAZ0808I error, that can occur when logging in to IBM Rational Quality Manager.
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.
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:
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:
;-DSQLSERVER_JDBC=C:\Progra~1\IBM\RQM201\server\sqlserver" --StartMode jvm --StopMode jvm
"%EXECUTABLE%" //US//%SERVICE_NAME% --JvmOptions "-Dcatalina.base=%CATALINA_BASE%;-Dcatalina.home=%CATALINA_HOME%;-Djava.endorsed.dirs=%CATALINA_HOME%\common\endorsed
3. Run rqm.service.bat install 2.0.1 to install the service again with the new JVM option.
More support for:
Rational Quality Manager
Software version: 2.0.1
Operating system(s): Windows
Software edition: Express Edition, Standard Edition
Reference #: 1430707
Modified date: 14 May 2010