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
typethat every time you log in. 

Let me know if that works for you.

thanks!

~ Troy Campano ~

-----Original Message-----
From: Jason S. Friedman [mailto:[email protected]]
Sent: Thursday, January 16, 2003 6:01 PM
To: Campano, Troy
Subject: Re: [JDBC] jdbc/redhat8.0/postgresql upgrade


powerpull@abigail ~ $ echo $CLASSPATH .:/usr/java:/usr/java/j2sdk1.4.1_01

powerpull@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@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:[email protected]]
> Sent: Thursday, January 16, 2003 2:42 PM
> To: [email protected]
> 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.