Re: JDBC Connection Problem

Quoting v j <jvs_a(at)yahoo(dot)com>:

redirected to the jdbc list:

> Dear Sir,
> I try to run the Java Program by using JDBC
> PostgreSql. It can run under
> only
> /usr/local/pgsql/src/src/interfaces/jdbc but it can't
> run under other directories ...

Yes it can, as long as you put it into your CLASSPATH.

ie, when built, you should find a file called postgresql.jar (named differently
if you download from the websites).

Say you copy it into say, /usr/local/lib. Then add the jar file to the
classpath, ie:

CLASSPATH=/usr/local/lib/postgresql.jar:$CLASSPATH

Then when your application loads the driver, it will get it from that location.

Peter

--
Peter Mount peter(at)retep(dot)org(dot)uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/