Re: JDBC connection issue - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: JDBC connection issue
Date
Msg-id Pine.BSO.4.56.0407131130440.27820@leary.csoft.net
Whole thread Raw
In response to JDBC connection issue  ("Young Nam" <Ynam@sharedmarketing.com>)
List pgsql-jdbc

On Tue, 13 Jul 2004, Young Nam wrote:

> The default directory for the postgresql.jar is
> /usr/local/pgsql/share/java/postgresql.jar I've run >jar -tf
> /usr/local/pgsql/share/java/postgresql.jar and the class files seem to
> be in the right order.
>
> I've added the following line to the pg_hba.conf to test local
> connections via jdbc driver.
> local    all    all    127.0.0.1    trust

You need to use "host" not "local" here.  Local is only for unix sockets
which cannot be used with Java.

> Added CLASSPATH to bashrc file
> export CLASSPATH=/usr/local/pgsql/share/java/postgresql.jar:${CLASSPATH}
>
> java.lang.ClassNotFoundException: org.postgresql.Driver
>

When you check the classpath with something like echo $CLASSPATH is it set
as you specified?

Kris Jurka


pgsql-jdbc by date:

Previous
From: Bill Chandler
Date:
Subject: Re: [PERFORM] Cursors performance
Next
From: Kris Jurka
Date:
Subject: Re: Retrieving User information