Postgres Pro
Downloads
Home   >   mailing lists

Thread: Connecting Openoffice Postgres

Connecting Openoffice Postgres

From
semmelhaacknospam@gmx.de (tim)
Date:
I have problems to connect my postgres db in Openoffice 1.1 via jdbc.

I can open the tables and run queries. But when try to create or alter
tables OpenOffice crashes.

My Settings

ClassPath /usr/share/pgsql/pg73b1jdbc2.jar:/usr/share/pgsql/pg73b1jdbc3.jar

JDBC Driver Class org.postgresql.Driver

Tim

Re: Connecting Openoffice Postgres

From
"Uwe C. Schroeder"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Is there a reason you're using the jdbc driver ? ODBC works perfectly fine.
Also the platform would be interesting.

On Saturday 22 November 2003 08:14 am, tim wrote:
> I have problems to connect my postgres db in Openoffice 1.1 via jdbc.
>
> I can open the tables and run queries. But when try to create or alter
> tables OpenOffice crashes.
>
> My Settings
>
> ClassPath /usr/share/pgsql/pg73b1jdbc2.jar:/usr/share/pgsql/pg73b1jdbc3.jar
>
> JDBC Driver Class org.postgresql.Driver
>
> Tim
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


- --
Open Source Solutions 4U, LLC    2570 Fleetwood Drive
Phone:  +1 650 872 2425        San Bruno, CA 94066
Cell:   +1 650 302 2405        United States
Fax:    +1 650 872 2417
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE/w0shjqGXBvRToM4RAhpYAKDMsCwomkwo+d+vbCDkW+ONdo0wUQCgk+Nm
wbxmN6dzFnRRF1Fco3agWHY=
=keka
-----END PGP SIGNATURE-----

Re: Connecting Openoffice Postgres

From
"Tim Semmelhaack"
Date:
Hello,
thank you for your reply.

I had the same problems with ODBC. I could only run query, but I couldn't
create or alter tables. If I tried, Openoffice failed without a precise
Error
message, so the same as if I used JDBC. So I think it's more a problem of a
Postgres setting?

I workl with Suse Linux 9.0 (newest version) and Postgres 7.3.4

Tim

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> Is there a reason you're using the jdbc driver ? ODBC works perfectly
> fine.
> Also the platform would be interesting.
>
> On Saturday 22 November 2003 08:14 am, tim wrote:
> > I have problems to connect my postgres db in Openoffice 1.1 via jdbc.
> >
> > I can open the tables and run queries. But when try to create or alter
> > tables OpenOffice crashes.
> >
> > My Settings
> >
> > ClassPath
> /usr/share/pgsql/pg73b1jdbc2.jar:/usr/share/pgsql/pg73b1jdbc3.j
> ar
> >
> > JDBC Driver Class org.postgresql.Driver
> >
> > Tim
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
> - --
> Open Source Solutions 4U, LLC    2570 Fleetwood Drive
> Phone:  +1 650 872 2425        San Bruno, CA 94066
> Cell:   +1 650 302 2405        United States
> Fax:    +1 650 872 2417
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.1 (GNU/Linux)
>
> iD8DBQE/w0shjqGXBvRToM4RAhpYAKDMsCwomkwo+d+vbCDkW+ONdo0wUQCgk+Nm
> wbxmN6dzFnRRF1Fco3agWHY=
> =keka
> -----END PGP SIGNATURE-----
>



--
--------------------
Tim Semmelhaack
Rendsburger Str. 7
20359 Hamburg
040/315241

Dienstlich:
Hamburg-Consult GmbH
040/27166-546

Re: Connecting Openoffice Postgres

From
Adrian Klaver
Date:
On Wednesday 26 November 2003 11:49 am, Tim Semmelhaack wrote:
> Hello,
> thank you for your reply.
>
> I had the same problems with ODBC. I could only run query, but I couldn't
> create or alter tables. If I tried, Openoffice failed without a precise
> Error
> message, so the same as if I used JDBC. So I think it's more a problem of a
> Postgres setting?
>
> I workl with Suse Linux 9.0 (newest version) and Postgres 7.3.4
>
> Tim
>
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> >
> > Is there a reason you're using the jdbc driver ? ODBC works perfectly
> > fine.
> > Also the platform would be interesting.
> >
> > On Saturday 22 November 2003 08:14 am, tim wrote:
> > > I have problems to connect my postgres db in Openoffice 1.1 via jdbc.
> > >
> > > I can open the tables and run queries. But when try to create or alter
> > > tables OpenOffice crashes.
> > >
> > > My Settings
> > >
> > > ClassPath
> >
> > /usr/share/pgsql/pg73b1jdbc2.jar:/usr/share/pgsql/pg73b1jdbc3.j
> > ar
> >
> > > JDBC Driver Class org.postgresql.Driver
> > >
> > > Tim
> > >
> > > ---------------------------(end of
> > > broadcast)--------------------------- TIP 1: subscribe and unsubscribe
> > > commands go to majordomo@postgresql.org
> >
> > - --
> > Open Source Solutions 4U, LLC    2570 Fleetwood Drive
> > Phone:  +1 650 872 2425        San Bruno, CA 94066
> > Cell:   +1 650 302 2405        United States
> > Fax:    +1 650 872 2417
> > -----BEGIN PGP SIGNATURE-----
> > Version: GnuPG v1.2.1 (GNU/Linux)
> >
> > iD8DBQE/w0shjqGXBvRToM4RAhpYAKDMsCwomkwo+d+vbCDkW+ONdo0wUQCgk+Nm
> > wbxmN6dzFnRRF1Fco3agWHY=
> > =keka
> > -----END PGP SIGNATURE-----

The problem is that OpenOffice will not update tables without an identified
primary key. The Catch-22 is the that it cannot see primary keys in Postgres
when they are of the serial type. See the following for all the gory details-

http://www.openoffice.org/issues/show_bug.cgi?id=3872
--
Adrian Klaver
aklaver@comcast.net