Sun Java System Application Server Enterprise Edition 8.1 2005Q2 Troubleshooting Guide

- Previous: Invalid user name or password
- Next: hadbm Command Hangs

### SQLException: No suitable driver

The `create-session-store` produces the error: `SessionStoreException: java.sql.SQLException: No suitable driver`.

#### Solution 1

This error can occur when `asadmin` is not able to find `hadbjdbc4.jar` from the `AS_HADB` path defined in `asenv.conf` in the Application Server `config` directory.

The solution is to change `AS_HADB` to point to the location of the HADB installation.

Here is a sample `AS_HADB` entry from an `asenv.conf` file:

    AS_HADB=/export/home0/hercules/0815/SUNWhadb/4.4.0-8

#### Solution 2

This error can also occur if you provide the incorrect value for `--storeUrl`. To solve this problem, obtain the correct URL using `hadbm get jdbcURL`.

- Previous: Invalid user name or password
- Next: hadbm Command Hangs

- © 2010, Oracle Corporation and/or its affiliates