"No suitable driver"

Hints and tips
Abstract
The no suitable driver error occurs when the jdbc driver can not be loaded. This can be caused by using an unsupported jdbc driver, an invalid driver prefix, or an invalid url.
Content
Oracle:

The Oracle 8.1.6 and 8.1.6.01 thin 100% java jdbc driver is supported. These
drivers can be downloaded from http://technet.oracle.com/software/download.htm.
If you use 8.1.6.01, you will need to rename it to classes111.zip or change the
classpath in admin.config to point to classes111_01.zip. This driver works with
8.0.5 and 8i (8.1.5 and 8.1.6).
The database driver class is : oracle.jdbc.driver.OracleDriver
The database url is : jdbc:oracle:thin:@<hostname or IP address>:1521:<SID>

Note: In the jdbc driver setup the Oracle SID should not be appended to the
database URL. Instead it should be entered into "database name" field of the
DataSource object.

In other words:
"URL prefix" field of "JDBC Driver" object shoud be "jdbc:oracle:thin:@<hostname or IP
address>:1521"
"Database name" field of "Data Source" object shoud have only the "<SID>"

Oracle Technical Support: http://technet.oracle.com/
From Getting Started: "Oracle8i 8.1.6 JDBC Drivers for use with JDK 1.1.x "
Current Driver: JDBC-Thin, 100% Java (classes111.zip, 1.4 MB)


DB2:

DB2 5.2 with fixpack 10 and up, and DB2 6.1 with fixpack 2 and up. Only the
application driver is supported at this time. The driver is located in the db2java.zip
file.
The database driver class is: COM.ibm.db2.jdbc.app.DB2Driver
The database url is : jdbc:db2:<database name>
This also applies when CAE has been installed locally instead of a full DB2
configuration. CAE configures an instance and minimal environment for accessing
databases remotely.











Document Information

Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server, Servlet Engine/Web Container
Operating system(s): AIX, Windows NT, Solaris
Software version: 3.02.x, 3.5.x
Software edition: Standard, Advanced
Reference #: 1000114
IBM Group: Software Group
Modified date: 2003-05-30