Re: Posgresql - openoffice-JDBC

On 20 Jun 2002 10:18:07 +0530
Parul Agarwal <parul@xxxxxxxxxxxxx> 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.



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly