Apache OpenOffice (AOO) Bugzilla – Issue 66373
Saved OpenOffice Base Tables are no more changeable
Last modified: 2013-08-07 15:45:17 UTC
When I create an odb file (OpenOffice Base document) I can create a new table, but when I save the table, then the columns are no more changeable. All the columns declared before saving the table become protected and no more changeable. Only creating new columns is possible, or deleting existing columns is possible too, but changing existing columns is not possible. The steps to reproduce the defect are: 1) create a new OpenOffice Base document (*.odb) based on the internal HSQL engine 2) Create a new table with some columns and save the new table 3) Try to change one of the columns just created ==> is no more possible 4) All the just created columns are protected and no more changeable. 5) I am able only to add new columns, or to delete existent columns 6) Save the table again and the just added columns are protected too. Every time I add new columns, and I save the table, all the columns became protected.
Created attachment 37097 [details] Base document with one table declared with all columns protected from changing
What do you want to "change"? I can alter field-name and field-type without problems. (OOo2.0.3rc5 on WinXP)
Hi regina, I'm on Linux Ubuntu Dapper and I can't alter nothing at all. I can alter everything before save the table, but after no more. For instance I create a table, and only after a while i will insert comments to the columns. For me is not possible. I don't know why, I don't know if this is a bug of the Dapper package, or is a bug present only on Linux, but for me is so. If you need, I can create a little wink tutorial to prove the problem with a screenshot series.
Created attachment 37099 [details] Screenshot of the table structure grayed and not changeable
question for step 2) Did you save the whole database too? Base uses the JRE. Some odd errors occure, if OOo cannot find a proper installed JRE. Please examine that too. Otherwise someone with Ubuntu should look at this issue. Do you asked in the Ubuntu forums yet?
This sounds a little bit as if you're running the wrong hsqldb.jar. Please try to find files with this name on your system, and ensure that the first version in your CLASSPATH is the one in <installation>/program/classes. (If none is in your CLASSPATH that's okay, too). Alternatively, try upgrading your system's hsqldb.jar, if present, to the latest 1.8.0.4.
where do you get your OOo-version from which version do you ese exactly
Created attachment 37127 [details] For Regina: OpenOffice Java setting (menu Tools/Options)
Oh, how many answers! Thank you all. My answers to Regina =================== Did you save the whole database too? ===> yes Base uses the JRE. Some odd errors occure, if OOo cannot find a proper installed JRE. Please examine that too. ===> on my PC are installed three JRE. I have attached a screenshot for you that show you my OpenOffice Java setting. I have tried to activate each of the three JRE, but the problem remain. Otherwise someone with Ubuntu should look at this issue. Do you asked in the Ubuntu forums yet? ===> only in the Italian Ubuntu Forum for now, because this problem is a little bit complicate to explain in english for me. For now no answer received. My answers to fs =================== This sounds a little bit as if you're running the wrong hsqldb.jar. Please try to find files with this name on your system, and ensure that the first version in your CLASSPATH is the one in <installation>/program/classes. (If none is in your CLASSPATH that's okay, too). ===> I have not all understand in your suggestion, but I can say you that Ubuntu Dapper Distro have installed the "libhsqldb-java" package with the version 1.8.0.2-1ubuntu1. More info on this package you can find at this address: http://packages.ubuntu.com/cgi-bin/search_packages.pl?keywords=libhsqldb-java&searchon=names&subword=1&version=dapper&release=all Alternatively, try upgrading your system's hsqldb.jar, if present, to the latest 1.8.0.4. ===> I have not tried yet. My answers to mechtilde ======================= where do you get your OOo-version from ===> It's the Ubuntu Dapper Distro that include automatically the OpenOffice packages. I have only installed the Ubuntu Dapper Distro, and I have OpenOffice too. which version do you ese exactly ===> from the OpenOffice Info About dialog I can read these informations: OpenOffice.org 2.0.2 openoffice.org 2.0.2-2ubuntu12 you can find more information on OpenOffice packages here: http://packages.ubuntu.com/cgi-bin/search_packages.pl?keywords=openoffice.org&searchon=names&subword=1&version=dapper&release=all
> I have not all understand in your suggestion, but I can say you that Ubuntu > Dapper Distro have installed the "libhsqldb-java" package with the version > 1.8.0.2-1ubuntu1. Hmm, 1.8.0.2 should be new enough. (There were older version of HSQL which did not support changing table fields, thus I supposed you might run such an older version.) Nonetheless, you might try to remove this package, to see if it is what causes trouble. If then you can edit table fields, this is still a bug in OOo :), but at least we then know what's going on.
Hi fs, I have made these steps: 1) stopped all OpenOffice tools (quickstart included) 2) downloaded the last HSQLDB version 1.8.0.4 from hsqldb.org 3) renamed the currently installed "hsqldb-1.8.0.2.jar" to "hsqldb-1.8.0.2_old.jar" 4) started OpenOffice Base, opened my database, and tried to access the tables. ===> OpenOffice Base return an error saying that no hsqldb driver is present; that's good: openoffice search really for this binary! 5) copied the new "hsqldb-1.8.0.4.jar" to the right folder and renamed to "hsqldb-1.8.0.2.jar", so my OpenOffice installation will find the driver with the older name, but the version is newer. 6) restarted OpenOffice, tried to access the tables, but the problem is still present. No way for me to alter existent tables. Have you any other suggestion?
Excellent triaging, thank you! Unfortunately, not with the desired result ... No, sorry, no other idea from my side then :(
Do you use OOo on a 64-bit machine? there is no official 64-bit version of OOo. What a Java-Version do you use? Maybe you should use the 32-bit version of JRE Mechtilde
Hi Mechtilde, absolutely no, I don't use a 64-bit version. I use a Dapper i386 Distro on my Laptop that is a 3 years old Dell Inspiron 5150. All is 32-bit only on my system. You can see the JRE versions installed on my system in the "OpenOffice.org-Java.png" attachment to this issue. NJ
Hi to all, finally I have tried the last chance: uninstall completely the module OpenOffice Base, and the install it again. This time I have success!! I don't know why, but now I can alter my tables! So my problem is resolved and this issue can be closed. Thank you to all for the help NJ
close