Re: getting JDBC connection working

On Tue, 13 Jan 2004, Iain wrote:

> typing "env" from the postgres user account, gives the following:
>
> CLASSPATH=/usr/local/pgsql/share/java/pg74jdbc3.jar:.
>
> I double checked and the file is in that directory. I stopped and resterted
> the DB too.
>
> This is my first time to use Java, so I may be missing something obvious.
> All I have done so far is put in the JDBC driver as I described, and
> download the windows version of the Java IDE and test a small program to
> connect. As far as I know there is no JVM on the server at he moment. TCP/IP
> connections are enabled, and working OK for ODBC apps.
>

You've got things all backwards.  The jar file is unnecessary on the
database server (unless you want to establish a connection from the
server machine).  It is a client access library and in this case should be
on your windows machine.  That's step one.  Step two is that often IDEs
override the CLASSPATH environment variable and you will probably need to
figure out how to add the jar file to your IDE.

Kris Jurka