Re: Problems loading the driver

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.ibarra@mac.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
>