Re: getting JDBC connection working

Hi Kris,

Thanks for your help.

> The --with-java option is only if you want to build the driver yourself.
> If you've downloaded a prebuilt binary there is no need for this.

OK, that makes sense.

> > My little test program is currently failing with a
ClassNotFoundException
> > during the call:
> >
> > Class.forName("org.postgresql.Driver");
>
> You have apparently not set the classpath correctly.

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.

If you have any more ideas, please let me know,
regards
Iain
>
> Kris Jurka
>