IBM Support

" Cannot create JDBC driver of class '' for connect URL 'null'" error in Tomcat log file

Troubleshooting


Problem

This technote explains The connection to the IBM Rational Portfolio Manager server fails. In this case the Portfolio Manager server uses Tomcat 5.5 as the application server., might occur when using IBM Rational Portfolio Manager

Symptom

The Tomcat log file contains the following error.


SEVERE: Unable to process external action(s).
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null', cause:
java.sql.SQLException: No suitable driver

Cause

The configuration of datasource jdbc/RPMDATASOURCE is incorrect in the IBMRPM.xml file.

Resolving The Problem

Verify that the configuration of the datasource in IBMRPM.xml is in agreement with the Installation and Upgrade Guide. You use the guide in the 7.1.1.2 package. The relevant chapter is

"Installing middleware: Tomcat 5.5 application server" .

An example of valid datasource is constructed as follows:




<Resource
name="jdbc/RPMDATASOURCE"
type="javax.sql.DataSource"
driverClassName="INSERT_HERE_YOUR_DB_DRIVER"
maxActive="4"
maxIdle="2"
maxWait="5000"
username="INSERT_HERE_RPM_ DB_USERNAME"
password="INSERT_HERE_RPM_DB_PASSWORD"
url="INSERT_HERE_YOUR_ DB_URL>"/>


Note:
For DB2, the driverClassName is "com.ibm.db2.jcc.DB2Driver″ and the format of the URL is jdbc:db2://host:port/dbname.
[{"Product":{"code":"SSRR2G","label":"Rational Portfolio Manager"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Installation and Configuration: Middleware","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.1;7.1.0.1;7.1.1.1;7.1.1.2","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

More support for:
Rational Portfolio Manager

Software version:
7.1, 7.1.0.1, 7.1.1.1, 7.1.1.2

Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows

Document number:
99435

Modified date:
16 June 2018

UID

swg21305899

Page Feedback