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

Re: Problems loading the driver

From: Enrique Ibarra <enrique(dot)ibarra(at)mac(dot)com>
To: Oliver Jowett <oliver(at)opencloud(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Problems loading the driver
Date: 2005-06-27 18:22:11
Message-ID: AE773D32-54F1-4C58-9016-5352FE9419B9@mac.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Oliver, thank you very much for your quick response. It seems that I  
will have to check this problem with Apple support. The jar driver is  
in fact in the CLASSPATH variable but somehow its value is not being  
correctly read by java. I was originally working with Xcode (Apple's  
IDE). I tried specifying both the CLASSPATH environment variable and  
java's -cp switch in the IDE but it did not work. Then I switched to  
old-fashioned emacs and a command terminal and I was able to make the  
program run, but only when I specify the -cp option in the java  
command line. If I do not specify the -cp switch then the program  
does not run (even though the jar driver is in the CLASSPATH). I have  
not been able to make this program run from the Xcode IDE. Here is  
the output of the command terminal to illustrate this problem. Thanks  
again.

{~/Ixe/Proyectos/tarme}% javac actgastos.java
{~/Ixe/Proyectos/tarme}% echo $CLASSPATH
/usr/local/lib/postgresql.jar:.:
{~/Ixe/Proyectos/tarme}% java actgastos gastos.csv
org.postgresql.Driver
java.lang.ClassNotFoundException: org.postgresql.Driver
         at java.net.URLClassLoader$1.run(URLClassLoader.java:199)
         at java.security.AccessController.doPrivileged(Native Method)
         at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
         at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
         at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java: 
274)
         at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
         at java.lang.ClassLoader.loadClassInternal(ClassLoader.java: 
302)
         at java.lang.Class.forName0(Native Method)
         at java.lang.Class.forName(Class.java:141)
         at actgastos.main(actgastos.java:8)
No suitable driver
java.sql.SQLException: No suitable driver
         at java.sql.DriverManager.getConnection(DriverManager.java:532)
         at java.sql.DriverManager.getConnection(DriverManager.java:171)
         at actgastos.main(actgastos.java:15)
{~/Ixe/Proyectos/tarme}% java -cp /usr/local/lib/postgresql.jar:.:  
actgastos gastos.csv
{~/Ixe/Proyectos/tarme}%


On Jun 25, 2005, at 12:22 AM, Oliver Jowett wrote:

> enrique(dot)ibarra(at)mac(dot)com wrote:
>
>
>> The JDBC jar file IS in the CLASSPATH environment variable. The  
>> code of
>> the program is the following:
>>
>
>
>> org.postgresql.Driver
>> java.lang.ClassNotFoundException: org.postgresql.Driver
>>
>
> This means that the driver jar *isn't* in your classpath.
>
> What is the exact value of your CLASSPATH, have you exported the
> CLASSPATH environment variable, where have you placed the driver jar,
> and what is the Java command line you are trying?
>
> -O
>


In response to

pgsql-jdbc by date

Next:From: Jesper ThorhaugeDate: 2005-06-28 08:15:31
Subject: getBinaryStream and OutOfMemoryException
Previous:From: Csaba NagyDate: 2005-06-27 12:06:18
Subject: [PATCH]Re: Which version of driver to use ?

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