Re: java.sql.SQLException: No suitable driver

5 will get you 10 that your class path isn't setup correctly. Try
adding ex.printStackTrace() to the catch handler for Class.forName

Dave
On 27-Apr-06, at 8:19 AM, Mads N. Vestergaard wrote:

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