Re: Posgresql - openoffice-JDBC

Timothy Reaves wrote:
>     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 can't get that to work.  I added (in our case)

/java/postgresql/pgjdbc2.jar

to the end of the SystemClasspath line, then started OpenOffice and
entered a data source of (again, for our case)

jdbc:postgresql://miranda:5432/catalog

with a driver class of org.postgresql.Driver.  He could see the
table name in the database, but when I try to construct any SQL
with either the "New Query Design" or "New SQL Command" buttons,
I get a dialog saying "Error while connecting to the data source"
and "ERROR: parse: parse error at or near "("".  Any ideas?

OpenOffice 1.0, Linux 2.4.18.

--
____________________________________________________________
Glenn Holmer                          gholmer@weycogroup.com
Programmer/Analyst                       phone: 414.908.1809
Weyco Group, Inc.                          fax: 414.908.1601