Re: setting CLASSPATH of the jdbc jar file

Mamoon Rashid wrote:
>
> i am a newbie using jdbc interface to postgresql.

You are a newbie to UNIX :^)

> Please tell me that at which prompt(either as a root or
> postgres user) i can set CLASSPATH. my jdbc jar file is in
> /usr/share/java/pg74.215.jdbc3.jar. i tried as root as well
> as postgres user and applied following command:

> export CLASSPATH=/usr/share/java/pg74.215.jdbc3.jar:${CLASSPATH}
> After that i looked it with "env" command.it looked well.

> but when i exit and reenturned into root as well as postgres
> user and typed "env" i couldnt see
> "CLASSPATH=/usr/share/java/pg74.215.jdbc3.jar".

The environment variables you set in your shell are lost when
the shell exits, i.e. when you log out.

In order to make your change persistent, you must write it into a
configuration file that is read by your shell at startup.
Assuming that you use bash, that would be .bash_profile in the home
directory of your user (if you want to set the CLASSPATH only for
this user) or /etc/profile if you want the change for all login users.

Yours,
Laurenz Albe