Created attachment 461807 [details]
HS error report on the crash
Description of problem:
OOo base crashes or is otherwise unusable when both a MySQL database and one external (not embedded) HSQLDB database are opened at the same time. I experienced there while trying to transfer information from one database to the other.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1.Create an .odb document that links to some existing MySQL database, use the com.mysql.jdbc.Driver. Save and close.
2.Create a different .odb document that links to an existing JDBC database (it will be created automatically, "existing" is misleading in this case. Use org.hsqldb.jdbcDriver as driver, in my case the used URL is "hsqldb:file:/home/julio/Personal/genealogia/hsqldb/valdepenas/valdepenas;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false". Save and close.
3.Now open the MySQL-connected document, open a table or do something that forces opening the connection (it demands password in this step). Then, open the HSQLDB-connected database. The tables list is unusable, it does not show existing tables, if any, and it is impossible to create any table there, everything is greyed-out. Close everything.
4. Now do it in the opposite order, open the HSQLDB-connected document first (tables may be edited normally) and, then, the MySQL-connected document. Force a database connection to the MySQL server and OOo crashes. Se attached reports.
Unusable combination either because of unstability or disabled features.
Be able to copy information from one database to the other.
I tried rebuilding the hsqldb RPMS on fc14 to see if it would fix it but it did not make any difference so I returned to Fedora official RPMS.
Problem with these database access bugs is the setup time to reproduce them vs other easier to get start on bugs. We'll hopefully get around to it eventually I hope :-(
I am not able to set this scenario up on Fedora 17. I'm unable to get step 2 ("Create a different .odb document that links to an existing JDBC database") working.
What I did:
A Have the relevant rpms installed:
B I noticed that LibreOffice would find neither of the jars from the mysql-connector-java and hsqldb rpms above. Is this a known problem? So I modified /usr/lib64/libreoffice/program/fundamentalrc, adding
to the end of the the URE_MORE_JAVA_CLASSPATH_URLS line.
C Create a MySQL database (having mysql-server-5.5.24-1.fc17.x86_64 installed, see also <http://docs.fedoraproject.org/en-US/Fedora/13/html/Managing_Confined_Services/chap-Managing_Confined_Services-MySQL.html>):
$ sudo service mysqld start
Redirecting to /bin/systemctl start mysqld.service
$ mysql -uroot
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.5.24 MySQL Community Server (GPL)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> CREATE DATABASE rhz655478;
Query OK, 1 row affected (0.00 sec)
mysql> use rhz655478;
mysql> CREATE TABLE foo ( num SERIAL PRIMARY KEY, data VARCHAR(50) );
Query OK, 0 rows affected (0.10 sec)
mysql> INSERT INTO foo (data) VALUES ('one'), ('two'), ('three'), ('four');
Query OK, 4 rows affected (0.04 sec)
Records: 4 Duplicates: 0 Warnings: 0
D Do step 1 ("Create an .odb document that links to some existing MySQL database"):
$ soffice --base
"Connect to an existing database - MySQL", "Next >>"
"Connect using JDBC (Java Database Connectivity", "Next >>"
"Database name": "rhz655478", "Server": "localhost", ("Port number" defaults to "3306", "MySQL JDBC driver class" defaults to "com.mysql.jdbc.Driver"), "Next >>"
"User name": "root" ("Password required" stays off), "Next >>"
"Yes, register the database for me", "Open the database for editing", "Finish", save as "test1.odb"
"File - Exit"
E "Create a different .odb document that links to an existing JDBC database (it will be created automatically, 'existing' is misleading in this case" -- what do I need to do here exactly? (I assume I need to set up some hsqld database up first nevertheless, even though you state "it will be created automatically"?)
This message is a notice that Fedora 14 is now at end of life. Fedora
has stopped maintaining and issuing updates for Fedora 14. It is
Fedora's policy to close all bug reports from releases that are no
longer maintained. At this time, all open bugs with a Fedora 'version'
of '14' have been closed as WONTFIX.
(Please note: Our normal process is to give advanced warning of this
occurring, but we forgot to do that. A thousand apologies.)
Package Maintainer: If you wish for this bug to remain open because you
plan to fix it in a currently maintained version, feel free to reopen
this bug and simply change the 'version' to a later Fedora version.
Bug Reporter: Thank you for reporting this issue and we are sorry that
we were unable to fix it before Fedora 14 reached end of life. If you
would still like to see this bug fixed and are able to reproduce it
against a later version of Fedora, you are encouraged to click on
"Clone This Bug" (top right of this page) and open it against that
version of Fedora.
Although we aim to fix as many bugs as possible during every release's
lifetime, sometimes those efforts are overtaken by events. Often a
more recent Fedora release includes newer upstream software that fixes
bugs or makes them obsolete.
The process we are following is described here: