Re: java.sql.SQLException: No suitable driver

Hi Dave,

My Classpath is:

hostname:~$ echo $CLASSPATH

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

And the file exists:

hostname:~$ ls -la /usr/share/java/pg74.216.jdbc3.jar

-rwxr-xr-x 1 root root 210371 2006-04-27 09:52 /usr/share/java/pg74.216.jdbc3.jar

Dave Cramer wrote:
> 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.
>>>
>>
>