Error 08001: No suitable driver when connecting to Derby or Cloudscape database

Troubleshooting

Problem

While trying to connect to the Cloudscape database with WebSphere Application Server, you receive an "Error 08001:no suitable driver" error.

Cause

This error is usually due to an incorrect classpath for the driver or an incorrect database URL. It can also occur if you don't use a ";" as a separator between the database URL and any options on the command.

For example, if you use the following ij.sh command to create and populate the database:

ij> connect 'jdbc:db2j:$CLOUDSCAPE_HOME/databases/PRODIGIODB:create=true';

this will cause an Error 08001:no suitable driver

Resolving The Problem

The correct command is as follows:

ij> connect 'jdbc:db2j:$CLOUDSCAPE_HOME/databases/PRODIGIODB;create=true';

Replace the colon with a semicolon behind the database name PRODIGIODB.

[{"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"DB Connections\/Connection Pooling","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF012","label":"IBM i"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.0;8.5.5;8.0;7.0","Edition":"Base;Network Deployment","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSNVBF","label":"Runtimes for Java Technology"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Java SDK","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Historical Number

69533;1LD;000

Was this topic helpful?

Document Information

Modified date:
15 June 2018

UID

swg21213287

Tips