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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jesper Thorhauge | 2005-06-28 08:15:31 | getBinaryStream and OutOfMemoryException |
Previous Message | Csaba Nagy | 2005-06-27 12:06:18 | [PATCH]Re: Which version of driver to use ? |