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@xxxxxxxxxxxxxx
Programmer/Analyst                       phone: 414.908.1809
Weyco Group, Inc.                          fax: 414.908.1601




---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html