Re: jdbc/redhat8.0/postgresql upgrade

Jason,
The jar file needs to be added to your classpath.
Once you log in try:
export CLASSPATH=$CLASSPATH:/usr/share/pgsql/jdbc7.2dev-1.2.jar
or
export CLASSPATH=$CLASSPATH:/usr/java/postgresql.jar

If that works you can add that export statement to your .bash_profile in your home directory so that you don't need to type that every time you log in.

Let me know if that works for you.

thanks!

~ Troy Campano ~

-----Original Message-----
From: Jason S. Friedman [mailto:jason(at)powerpull(dot)net]
Sent: Thursday, January 16, 2003 6:01 PM
To: Campano, Troy
Subject: Re: [JDBC] jdbc/redhat8.0/postgresql upgrade

powerpull(at)abigail ~ $ echo $CLASSPATH .:/usr/java:/usr/java/j2sdk1.4.1_01

powerpull(at)abigail ~ $ ll /usr/java
total 12
drwxr-xr-x 7 root root 4096 Dec 24 04:44 j2re1.4.1_01
drwxr-xr-x 9 root root 4096 Dec 24 04:44 j2sdk1.4.1_01
drwxr-x--- 3 powerpull users 4096 Jan 4 22:47 net
lrwxrwxrwx 1 root root 35 Jan 16 18:44 postgresql.jar -> /usr/share/pgsql/jdbc7.2dev-1.2.jar

powerpull(at)abigail ~ $ ll /usr/share/pgsql/jdbc7.2dev-1.2.jar
-rwxr-xr-x 1 root root 116198 Dec 20 17:57 /usr/share/pgsql/jdbc7.2dev-1.2.jar

On Thu, Jan 16, 2003 at 03:19:42PM -0500, Campano, Troy wrote:
> What do you get when you echo your classpath?
>
> echo $CLASSPATH
>
>
> ~ Troy Campano ~
>
> -----Original Message-----
> From: Jason S. Friedman [mailto:jason(at)powerpull(dot)net]
> Sent: Thursday, January 16, 2003 2:42 PM
> To: pgsql-jdbc(at)postgresql(dot)org
> Subject: [JDBC] jdbc/redhat8.0/postgresql upgrade
>
>
> I just recently upgraded my postgresql to version 7.2.2-1 on my RedHat
> box.
>
> JDBC was working before the upgrade. Now, I get this error message:
> ClassNotFoundException: org.postgresql.Driver
>
> Under the old setup I had the /usr/java directory in my CLASSPATH and in that directory I had a link to /usr/share/pgsql/pgjdbc2.jar
> lrwxrwxrwx 1 root root 28 Jan 6 03:38 postgresql.jar -> /usr/share/pgsql/pgjdbc2.jar
>
> I removed that link and replaced it with a link to
> /usr/share/pgsql/jdbc7.2dev-1.2.jar, but that did not help.