Apache OpenOffice (AOO) Bugzilla – Issue 117280
Read only tables and forms in OO Database connected with Postgresql
Last modified: 2013-01-29 21:46:57 UTC
Using SDBC driver 0.7.6b (released 2010-08-12) to use OpenOffice to view and modify data in Postgresql database. In OpenOffice 3.3 connection works, but all tables and forms are read only. Data modification is not possible. I notice also that Edit→Databas→Advanced Settings option are grey, and I couldn't access it. The earlier version 3.2.1 worked without problems, I could add and modify data in tables and forms.
What postgresql server version you try to connect?
I could confirm it using OOo 3.3 under ubuntu 10.10 with postgresql 8.4 server the tables read-only with sdbc 0.7.6b driver. I tested with DEV300m101, same problem under ubuntu, but works under win7. Workaround, use JDBC driver, I could edit table with it.
(In reply to comment #2) > What postgresql server version you try to connect? The Postgresql version is 8.4.2.
I made false claim that it works under win7 with OOo 3.3 and DEV300m101. It is broken on win7, with both version, too. changed platform.
(In reply to comment #3) > I could confirm it using OOo 3.3 under ubuntu 10.10 with postgresql 8.4 server > the tables read-only with sdbc 0.7.6b driver. > > I tested with DEV300m101, same problem under ubuntu, but works under win7. > > Workaround, use JDBC driver, I could edit table with it. Yes JDBC driver are working, but it is ~2 times slower than SDBC driver.
*** Issue 117979 has been marked as a duplicate of this issue. ***
*** Issue 117984 has been marked as a duplicate of this issue. ***
We are using postgresql-8.3.9. With OO 3.3.0 and the sdbc extension 0.7.6b we can not add records. I also note that under <Edit><Database> the <advanced settings> option is greyed out. Also you can not modify existing tables in the database. Using the jdbc driver is not an option (at least it wasn't the last time I tried): - is is slow - it doesn't handle dates and booleans well in ALL cases including in (auto and form) filters in tables and forms (yeaah that are 8 different cases that I all tried). Side note: LibreOffice Base is broken even further in Ubuntu as it does not even allow to modify existing forms (does not depend on the database backend). Base is an important application for us a we use it for time registration and billing in combination with Calc pivot tables. I guess for any company using Base the value of the underlying data is higher then that of Writer/Impress documents. This hurts. I will need to revert back to 3.2.1 until this is fixed. Ferry
Just tested with Oo3.4 beta 1. The behavior is the same: you can not add records NOR change records in a postgres database. I think this should be a blocker for the 3.4 release. Ferry
I inadvertently created a duplicate of this bug which was assigned number 119797. I agree that this error should be a blocker for the 3.4 release. The error has been duplicated with the following configurations. Windows XP Pro running OOo 3.3, SDBC 0.7.6a and Postgresql 8.4.8 Windows XP Pro running OOo 3.3, SDBC 0.7.6b and Postgresql 8.4.8 Windows 7 running OOo 3.3, SDBC 0.7.6a and Postgresql 9.0.4 Windows 7 running OOo 3.3, SDBC 0.7.6b and Postgresql 9.0.4 Uninstalling OOo 3.3 and reinstalling OOo 3.2 restores full functionality.
sdbc driver 0.76.a designed for OOo 3.2.x and older versions. sdbc driver 0.76b is for OOo 3.3 and newer versions of OOo, as you can read from messages on driver page.
r4zoli: yes I know - and I'm sure Darren knows too. I want to confirm: Works well: sdbc driver 0.76.a designed for OOo 3.2.x and older versions. Does not work 1): sdbc driver 0.76b is for OOo 3.3 and newer versions of OOo 1) retrieves records well, but does not create records in Tables or Forms. Ferry
I changed the 3.4_release_blocker flag to mark it as no stopper issue. But if somebody can provide a fix in time we will include it in 3.4.
The bug has been resolved in LO 3.5. See: http://wiki.documentfoundation.org/PostgreSQL-SDBC Ferry
getting rid of value "enhancement" for field "severity". For enhancement the field "issue type" shall be used.