Re: Posgresql - openoffice-JDBC

On 20 Jun 2002 10:18:07 +0530
Parul Agarwal <parul(at)netcore(dot)co(dot)in> wrote:

> Hi,
>
> I would like to know as to how can I make a JDBC connection to connect
> openoffice and Postgresql. I have already installed postgresql
> (./configure --with-java). But I am not able to make a connection to
> openoffice.
>

I had this same problem, and finally resolved it. What you need to do is
go to the file

../OpenOffice.org1.0/user/config/javarc

(where the '..' is where ever you installed it) and find the line:

SystemClasspath=...

and add the path to the jar file. On my system it is at:

/usr/share/pgsql/jdbc7.1-1.2.jar

Once I added that to the class path, all works well! I also use unixODBC
with PostgreSQL & OpenOffice.