java.sql.SQLException: No suitable driver

From: "Mads N(dot) Vestergaard" <mnv(at)timmy(dot)dk>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: java.sql.SQLException: No suitable driver
Date: 2006-04-27 12:19:46
Message-ID: 4450B6E2.3020503@timmy.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi Everybody, when I try to run my program, I get the following error message:

java.sql.SQLException: No suitable driver

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at Database.<init>(Database.java:20)

at Gateway.main(Gateway.java:19)

Exception in thread "main" java.lang.NullPointerException

at Database.SQLget(Database.java:71)

at Gateway.main(Gateway.java:33)

My connect code is:

try {

Class.forName("org.postgresql.Driver");

}catch (ClassNotFoundException e){

}

try {

db = DriverManager.getConnection("jdbc:postgresql://hostname/" + dbName,"bruger","kode");

} catch (SQLException e) {

e.printStackTrace();

}

On my system I have putted the jdbc driver for postgres into the classpath:

hostname:~$ echo $CLASSPATH

/usr/share/java/pg74.216.jdbc3.jar

Java version:

hostname:~$ java -version

java version "1.5.0_06"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_06-b05)

Java HotSpot(TM) Client VM (build 1.5.0_06-b05, mixed mode, sharing)

As far as I know it should work since, it is correct in the classpath. I have also tried with other postgres jdbc drivers. In my IDE(Eclipse), it works fine, but on my production server it gives the error.

I've also tried to run the program with the -classpath flag, with the same result.

Have I simply forgotten something, or is there something seriously wrong?

Thanks in advance.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2006-04-27 12:26:05 un-named prepared statement wierdness
Previous Message Oliver Jowett 2006-04-27 11:34:41 Re: Error 08S01 (COMMUNICATION_ERROR)