[dba-issues] [Issue 113970] OO Base 3.2.1 cannot conn ect with embedded DB it created -- says was cr eated by newer version
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113970 User r4zoli changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from r4z...@openoffice.org Fri Aug 20 07:40:24 + 2010 --- invalid-closing - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 113970] OO Base 3.2.1 cannot conn ect with embedded DB it created -- says was cr eated by newer version
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113970 User r4zoli changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |INVALID --- Additional comments from r4z...@openoffice.org Thu Aug 19 06:21:31 + 2010 --- Maybe you opened this file on Arch linux, which updated HSQLDB 1.8.1.2 for a short period of time in June this year, later they set back to 1.8.0.10. See: http://bugs.archlinux.org/task/19765 http://user.services.openoffice.org/en/forum/viewtopic.php?f=13t=31454 Rename odb to zip, open /database/properties file in text editor and set back version=1.8.1 to version=1.8.0 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 113970] OO Base 3.2.1 cannot conn ect with embedded DB it created -- says was cr eated by newer version
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113970 User r4zoli changed the following: What|Old value |New value CC|''|'r4zoli' --- Additional comments from r4z...@openoffice.org Thu Aug 19 06:23:30 + 2010 --- add cc - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 113970] OO Base 3.2.1 cannot conn ect with embedded DB it created -- says was cr eated by newer version
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113970 --- Additional comments from amel...@openoffice.org Thu Aug 19 18:21:27 + 2010 --- Created an attachment (id=71204) Contents/_CodeSignature/CodeResources file from possibly corrupted version of OO - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 113970] OO Base 3.2.1 cannot conn ect with embedded DB it created -- says was cr eated by newer version
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113970 --- Additional comments from amel...@openoffice.org Thu Aug 19 18:20:03 + 2010 --- @r4zoli I'm afraid it can't be anything to do with Arch Linux -- I have not accessed these files on anything but this one MacBook running 3.2.1! Also, the properties file is already set to 1.8.0: #HSQL Database Engine 1.8.0.10 #Tue Aug 17 15:29:52 PDT 2010 hsqldb.script_format=0 runtime.gc_interval=0 sql.enforce_strict_size=true hsqldb.cache_size_scale=8 readonly=false hsqldb.nio_data_file=false hsqldb.cache_scale=13 version=1.8.0 hsqldb.default_table_type=cached hsqldb.cache_file_scale=1 hsqldb.lock_file=true hsqldb.log_size=10 modified=no hsqldb.cache_version=1.7.0 hsqldb.original_version=1.8.0 hsqldb.compatible_version=1.8.0 I was experimenting with a stand-alone HSQLDB system, version 1.8.1.3, and created a copy of one of my databases on it. But I don't see how that would have affected the files with the embedded databases -- the copy was one-way from embedded to stand-alone, and I used OO to copy the individual tables over. Regardless, I seem to have determined that the problem was a corrupted OpenOffice program file, because (a) any file that got resaved yesterday (while I was opening files to see if they were corrupted), is now corrupted (b) that behaviour stopped once I completely removed my old OO program files and reinstalled a fresh version. I still can't access the databases in the corrupted files (get the same newer version message as above), but new files I open and save don't get corrupted. (Note: When I said yesterday that I had re-installed OO, what I had done was copy the original app package overtop of my existing app, same as I would do when updating OO. But then I remembered that updates are supposed to preserve custom settings files, so this wouldn't completely wipe clean changes to the program.) I used the Mac Terminal to do a diff comparison of the contents of the old and new OpenOffice.org.app packages, and got the following differences: The old (corrupted) version had the extra folder Contents/_CodeSignature containing file CodeResources. The file Contents/MacOS/soffice was different between the two versions. In addition, there was an extra alias file in the Contents folder, which just referenced the CodeResources file, and the difference in the soffice file also showed up in the Contents/program folder, which is just an alias for the MacOS folder. I don't know enough about the inner workings of OO to know if either of those differences might be significant, but just in case I'll attach copies of the two files from the (apparently) corrupted version. In the meantime, I'm just making sure I backup any file before I open it, and being glad that I had duplicate backups from two days ago! - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 113970] OO Base 3.2.1 cannot conn ect with embedded DB it created -- says was cr eated by newer version
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113970 --- Additional comments from amel...@openoffice.org Thu Aug 19 18:22:35 + 2010 --- Created an attachment (id=71205) Contents/MacOS/soffice file from possibly corrupted version of OO - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 113970] OO Base 3.2.1 cannot conn ect with embedded DB it created -- says was cr eated by newer version
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113970 --- Additional comments from r4z...@openoffice.org Thu Aug 19 18:39:08 + 2010 --- What hsqldb.jar file used for connection to external hsqldb 1.8.1.3 server. If you added 1.8.1.3 version to classpath then this can be source of your problems. Remove it. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 113970] OO Base 3.2.1 cannot conn ect with embedded DB it created -- says was cr eated by newer version
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113970 --- Additional comments from amel...@openoffice.org Thu Aug 19 18:59:39 + 2010 --- That might be it -- I added the link to the hsqldb.jar file in the downloaded hsqldb package. This would then override the jar file from the embedded database, is that the problem? If that makes sense then you can close the issue. Wonder why the properties file still says 1.8.0, though? These questions are more for a support forum than an issues tracker, but if you know the answers quickly: *If OO has its own hsqldb.jar file that it uses for the embedded database, do I need to add a class path to it in the java settings at all? I had been following instructions on a tutorial in one of the forums about how to set up a stand-alone HSQL DB. *Any ideas of how to regain access to the files that were saved while OO was using the wrong jar file? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 113970] OO Base 3.2.1 cannot conn ect with embedded DB it created -- says was cr eated by newer version
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113970 --- Additional comments from r4z...@openoffice.org Thu Aug 19 19:15:52 + 2010 --- I found version=1.8.1 in your uploaded file properties. This would then override the jar file from the embedded database, is that the problem? This can be a problem. *If OO has its own hsqldb.jar file that it uses for the embedded database, do I need to add a class path to it in the java settings at all? I had been following instructions on a tutorial in one of the forums about how to set up a stand-alone HSQL DB. Yes, own hsqldb.jar needs to add classpath, or if you add new one for external connection, after usage needs to be removed from classpath, before opens another file. Any ideas of how to regain access to the files that were saved while OO was using the wrong jar file? If the original post warning happens, then need to set back, properties in file. no other measures needs. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 113970] OO Base 3.2.1 cannot conn ect with embedded DB it created -- says was cr eated by newer version
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113970 --- Additional comments from amel...@openoffice.org Thu Aug 19 19:36:30 + 2010 --- Yes, you were right -- the properties file I copied above was from a version I had unzipped earlier (from trying to recover data after a crash). Thanks very much for all your help! --AB - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 113970] OO Base 3.2.1 cannot conn ect with embedded DB it created -- says was cr eated by newer version
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113970 Issue #|113970 Summary|OO Base 3.2.1 cannot connect with embedded DB it creat |ed -- says was created by newer version Component|Database access Version|OOo 3.2.1 Platform|Macintosh URL| OS/Version|Mac OS X, 10.5 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ameliab --- Additional comments from amel...@openoffice.org Wed Aug 18 23:41:50 + 2010 --- Working with Base on files with an embedded database, I suddenly cannot access the data on files I was using this morning. The odb file opens correctly, but when I try to view tables, open a form, or use SQL, I get the error: The connection to the data source [filename] could not be established. The database was created by a newer version of OpenOffice.org. However, these files were both created on the exact same OO version on the exact same computer, and were last accessed without problem earlier today. OpenOffice was closed normally at lunch; there was no crash that could explain corrupted files today, although I did have a crash yesterday (unexplained, not sure what happened -- copying data [text] into a form and OO hung as if it got stuck in a loop until it eventually crashed). Neither restarting the computer, nor reinstalling OpenOffice from the original disk image, fix the problem. Access to other database files (including my backup file from yesterday's crash) don't have problems. I've copied the odb files and unzipped them to look at the database scripts and cannot find any obvious discrepancies. I'll attach the smaller database file ... and then start re-doing my work from this morning, which in turn was a re-do of work that I'd lost yesterday! And then will remind myself not to design any projects around OO Base until it is up to the reliability standards of the rest of the program. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 113970] OO Base 3.2.1 cannot conn ect with embedded DB it created -- says was cr eated by newer version
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113970 --- Additional comments from amel...@openoffice.org Wed Aug 18 23:44:16 + 2010 --- Created an attachment (id=71174) One of the two files that became inaccessible - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 113970] OO Base 3.2.1 cannot conn ect with embedded DB it created -- says was cr eated by newer version
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113970 --- Additional comments from amel...@openoffice.org Thu Aug 19 00:17:45 + 2010 --- I remembered one more thing that connects these two databases: I had created a saved SQL query in each that queried the system table information (SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLES) (That was the only reason I had opened up the attached Test database: I was looking at the cached versus memory properties of tables, and wanted to see if it was possible to create a memory table in an embedded database -- and I didn't want to play around with anything like that on my main database, for fear of messing up my data!) However, I've used this query before without problem. And nothing else I did while working with the test database was duplicated on the main database, except for the fact that both files were open at the same time. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org