Skip site navigation (1) Skip section navigation (2)

"No Suitable Driver"

From: Guy McArthur <guym(at)guymcarthur(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: "No Suitable Driver"
Date: 2001-10-24 23:13:13
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
Hi, I'm trying to get a small test program going. I have built PostgreSQL
7.1.3 on RedHat 6.2 with --java, installed and created databases, verified
with psql. The postgresql.jar is on my classpath.

My pg_hba.conf has:
local        all                                           password
host         all     password

Here is my code:

import java.sql.*;

public class PostgresTest {
   public static void main(String[] args) {
     try {
      Connection db =
// I've also tried all the permutations of getConnection() and urls.
// db, user, and password names have been changed to protect the innocent
// I've also tried Class.forName("org.postgresql.Driver") and
// Class.forName("org.postgresql.Driver").newInstance() instead of the arg.
     } catch(Throwable t) {

Running it with:

java -Djdbc.drivers=org.postgresql.Driver PostgresTest
where the db has been started by user postgres with:
/usr/local/pgsql/bin/postmaster -i -D /data/pgsql >/data/pgsql/pgsql.log 2>&1 &

And the error is:

java.sql.SQLException: No suitable driver
        at java.sql.DriverManager.getConnection(
        at java.sql.DriverManager.getConnection(
        at PostgresTest.main(

What is wrong?

Guy McArthur * email{guym(at)arizona(dot)edu} http{}


pgsql-jdbc by date

Next:From: PaulDate: 2001-10-25 00:46:59
Subject: Code Fixes
Previous:From: Tom LaneDate: 2001-10-24 18:02:55
Subject: Re: [PATCHES] DatabaseMetadata patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group