Обсуждение: Connecting Openoffice Postgres
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
-----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-----
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
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