Apache OpenOffice (AOO) Bugzilla – Issue 94433
Database is not accessible after rename tables
Last modified: 2008-10-06 10:25:11 UTC
* Open attached database. * Rename any tables. * Save and close the database. * Open the database document again. * Switch to the "Tables" container. Error message «Driver class " could not be loaded» occurs. Tested on Windows and Linux. It's a regression the Issue 64885?
Created attachment 56902 [details] testbase
How do you create your database? Please give a step-by-step description. The status bar shows me "JDBC". It must show something with HSQL. So I can't see which database backend you use.
Confirm bug. OO.o 3.0 RC1
@mechtilde > Please give a step-by-step description. Run OOo Base. In Wizard select «Create a new database» - > Finish Save the database As Base4.odb -> OK. New database opens. Switch to the «Tables» container Select «Create Table in Design View...» Enter names for first field as «text1» and second field as «text2». Types field leaves as default «Text [Varchar]». Save table. Enter name table as «Table1» -> OK To ask «Should be a primary Key?» select «Yes» Close table. Close OOo Base. Run OOo Base. In Wizard select «Open an existing database file», in «Recently used» Base4 -> Finish. Base4.odb opens (status bar shows "HSQL" yet). Switch to the «Tables» container. Look «table1». Select «table1», right mouse click select «Rename». Rename table «table1» -> «table12». OK. Save Base4.odb, Close OOo Base. Run OOo Base. In Wizard select «Open an existing database file», in «Recently used» Base4 - > Finish. Base4.odb opens (status bar shows "JDBC"). Switch to the «Tables» container. Look Error message.
> How do you create your database? OO.o Base - > Database Wizard -> Create a new database - > (Next) -> (Finish) (use OO.o database format) Save file Tables - > Create table in Design View - > ...... Close OO.o ReOpen attached database. Rename any tables. Save and close the database. Open the database document again. Switch to the "Tables" container.
I can reproduce the error as described with German OOo3.0RC3 on WinXP.
It happens also with existing database with embedded HSQL. Rename table, save, close, reopen. Typ has changes to JDBC.
The content.xml is empty. Files have wrong time.
I can reproduce it with RC3 under Debian
sigh ...
for the record: The bug is present in DEV300m20 already, but not in DEV300m15. Not sure when it was introduced, though ...
Thanks for taking this one.
fixed in CWS dba30y. Builds running.
Note: issue 94455 is the DEV300-version of this issue. We fixed the problem on the OOO300 branch with a less-than-optimal solution, but will provide a better fix for 3.1.
fs->msc: please verify in CWS dba30y
fs: Does your comment about issue 94455 mean that this CWS (dba30y) may not or even must not get cloned for DEV300 workspace? If so, please state that in an CWS comment, as per default all OOO300-childworkspaces get cloned for DEV300.
verified in CWS dba30z find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=OOO300%2Fdba30z
fs->rt: yes, you're right, the CWS is not intended for DEV300. Sorry, planned to add a note in EIS, but got distracted by some meetings ... :-\
FYI, it's reproductible on RC3 MacOSX Native.
verified in OOO300_m9 -> closed