Re: Open Office - Mailing list pgsql-jdbc

Scott,

I faced a similar problem several weeks ago (PostgreSQL 7.2 and
OpenOffice1.0.1).

There were three step i had to arrange to access the back end.

Your situation might be different because  i use a network.
PostgreSQL and OpenOffice instances run on different hosts and i use
password authentication

1., I put the postgresql.jar in the $JAVA_HOME/jre/lib/ext directory on all
'OpenOffice' hosts
2., I installed the OpenOffice again because java support hadn't been
installed
(click 'more' on the error message.A new panel will appear. Click on the
'Error' branch.
If you see a 'No javainstalled' message in the description then your
OpenOffice is unable to use java)
I suppose that you can modify your current installation by using the setup
of the OpenOffice.
3., I added the following line to the $PGDATA/pg_hba.conf:
host    NAME_OF_THE_DATABASE    IPADDRESS_OF_THE_OPENOFFICE_HOSTS
NETMASK_OF_THE_IP    password    NAME_OF_THE_PG_PASSWORD_FILE

the password for the username i use to connect to the backend is stored in
the $PGDATA/NAME_OF_THE_PG_PASSWORD_FILE

After re-starting the OpenOffice I was able to connect to the PostgreSQL.


Regards
Istvan Nagy

----- Original Message -----
From: Scott Taylor <scott.taylor@4i-dotcom.com>
To: <pgsql-jdbc@postgresql.org>
Sent: Tuesday, January 21, 2003 2:48 PM
Subject: [JDBC] Open Office


> I wonder whether anyone could either point me to some decent documentation
> on connecting to Open Office, or correct the information below from the
> Datsources box in OO.
>
> Name: PostgreSQL
> Database Type: JDBC
> URL: jdbc:postgresql://localhost:5432/recruitment
>
> Driver Class: org.postgresql.Driver
> Username: Scott
> Password: check
> Character: system
>
> I have version 7.3.1 (Cygwin on 98) and the driver pg73jdbc3.jar is in my
> classpath as follows:
>
> SET
>
CLASSPATH=C:\j2sdk1.4.1_01\lib\tools.jar;C:\cygwin\usr\share\postgresql\java
> \pg73jdbc3.jar
>
> I have also set TCP/IP sockets =true and have trust for authentication
>
> I am getting the following errors in OO:
>
> 1. No connection could be established for the URL
> jdbc:postgresql://localhost:5432/recruitment.
>
> 2. Connection refused. Check that the hostname and port are correct and
that
> the postmaster is accepting TCP/IP connections.
>
> 3. Please check the current settings, e.g. user name and password.
>
> Thanks
>
> Scott
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>