Re: java.sql.SQLException: No suitable driver

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.(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.