Re: java.sql.SQLException: No suitable driver

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