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

Re: java.sql.SQLException: No suitable driver

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Mads N(dot) Vestergaard <mnv(at)timmy(dot)dk>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: java.sql.SQLException: No suitable driver
Date: 2006-04-27 13:43:04
Message-ID: B82B73E6-A7EC-462B-AE49-F934661CE9DF@fastcrypt.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Mads,

What is your classpath.

inevitably this is the problem.

Dave
On 27-Apr-06, at 9:31 AM, Mads N. Vestergaard wrote:

> Well, it gives me:
>
> java.lang.ClassNotFoundException: org.postgresql.Driver
>         at java.net.URLClassLoader$1.run(Unknown Source)
>         at java.security.AccessController.doPrivileged(Native Method)
>         at java.net.URLClassLoader.findClass(Unknown Source)
>         at java.lang.ClassLoader.loadClass(Unknown Source)
>         at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
>         at java.lang.ClassLoader.loadClass(Unknown Source)
>         at java.lang.ClassLoader.loadClassInternal(Unknown Source)
>         at java.lang.Class.forName0(Native Method)
>         at java.lang.Class.forName(Unknown Source)
>         at Database.<init>(Database.java:16)
>         at Gateway.main(Gateway.java:19)
>
> But I think you're right... But my problem is, that if I try to run  
> it with the classpath flag, and also the classpath environment  
> vartiable, it fails.
> The path is correct.
>
> I believe that I have overseen something, but I have looked over  
> the setup a dusin of times now, and I can't spot it.
>
>
> Dave Cramer wrote:
>> 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.(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.
>>
>

In response to

Responses

pgsql-jdbc by date

Next:From: Mads N. VestergaardDate: 2006-04-27 13:46:33
Subject: Re: java.sql.SQLException: No suitable driver
Previous:From: Mads N. VestergaardDate: 2006-04-27 13:31:48
Subject: Re: java.sql.SQLException: No suitable driver

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