This is a problem that has existed since HSQLDB v. 1.8 was no longer the latest stable version.
Base has not updated the HSQLDB database engine because the .odb file contains an embedded database. Remove the embedded database files placing them in their separate folder, and Base can connect to them using the latest version of HSQLDB.
Steps to reproduce:
An .odb file contains files in the database folder for embedded databases. It does not contain this folder when it is used to connect to an external database.
When Base creates a new database, a folder should be selected in which to place the database files and the files should be created in this folder. Create the .odb file as you would when connecting to an external database. So, the only new required is selecting a folder for the files and writing them to it.
When I use Tools > Options > Libreoffice > Java > Class Path to at HSQLDB 2.x, I can connect to a folder containing the database files. So, this can be done with HSQLDB as well.
The Database Wizard would need to be modified to do two things: select a folder in which to place the database files creating the folder if necessary, write the necessary files in this folder.
Platform (if different from the browser):
Browser: Mozilla/5.0 (X11; Linux x86_64; rv:13.0) Gecko/20120604 Firefox/13.0 SeaMonkey/2.10
Please have a look at this bugerport. What is your opinion?
I already have taken existing embedded databases and connected them using Base and HSQLDB 2.2.8 using the steps below using health.odb as an example.
1) Extract the database folder from health.odb to ~/.database-hsql/
2) Change the name of the folder to health.
3) Add health as a prefix to the files in the health folder.(health.data,health.properties,
4) Tools -> Options -> LibreOffice -> Java -> Class Path:
add the location of hsqldb.jar.
(In my case this is /usr/local/hsqldb-2.2.8/hsqldb/lib/hsqldb.jar)
5) Close LO and reopen.
6) Datasource URL: hsqldb:file:/home/danlewis/.database-hsql/health
7) Test Class: org.hsqldb.jdbcDriver
this bugreport is possibly associated with other bugreports.
Which procedure would you suggest? E.g. "depends on" or "duplicate"?
I have added some links to other bugs. There are many ideas to change the internal database, the behaviour of the internal database and so on.
Creating external HSQLDB-databases works already. There are some problems (when external HSQLDB has another version of HSQLDB could be, the you could not open internal databases; Autoincrement-Values are not created right in the GUI ...), but you can create databases in this way now.
The intention of other people is, to make Firebird to the next internal database. This could be a good idea, when we will solve many problems that appear, when using Java and C/C++ parallel.
I don't miss functions in the old HSQLDB. There are more other problems, which could be solved, before a normal user will hit the wall of the old HSQLDB.
And, what we must also know, the changing of the structure with the internal database will complicate the communication between users, who use OOo/AOO and LO. Databases, created in a newer version of LO would not be readable in OOo/AOO and older LO. So I wouldn't use such a newer version of LO for work, because I have to communicate with many installed Office-Versions, which only work with the old internal HSQLDB.
(In reply to comment #4)
> And, what we must also know, the changing of the structure with the internal
> database will complicate the communication between users, who use OOo/AOO and
> LO. Databases, created in a newer version of LO would not be readable in
> OOo/AOO and older LO. So I wouldn't use such a newer version of LO for work,
> because I have to communicate with many installed Office-Versions, which only
> work with the old internal HSQLDB.
This statement "disappears" in this bugreport. But your statement is IMHO important.
Proposal: create a new bugreport with your statement (and perhaps a thread on the QA-mailinglist). I can do this also after you have created a special bugreport.
Dear Bug Submitter,
This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information.
For more information about our NEEDINFO policy please read the wiki located here:
If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed.
Thank you for helping us make LibreOffice even better for everyone!
Close this bug since nothing will be done with it anyway. Besides, the trend in Base is to replace HSQLDB with Firebird.
On 05/28/2013 11:37 AM, email@example.com wrote:
> Joel Madero <mailto:firstname.lastname@example.org> changed bug 51338
> What Removed Added
> QA Contact email@example.com
> *Comment # 6 <https://bugs.freedesktop.org/show_bug.cgi?id=51338#c6>
> on bug 51338 <https://bugs.freedesktop.org/show_bug.cgi?id=51338> from
> Joel Madero <mailto:firstname.lastname@example.org> *
> Dear Bug Submitter,
> This bug has been in NEEDINFO status with no change for at least 6 months.
> Please provide the requested information as soon as possible and mark the bug
> as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in
> NEEDINFO status with no change in 30 days the QA team will close the bug as
> INVALID due to lack of needed information.
> For more information about our NEEDINFO policy please read the wiki located
> If you have already provided the requested information, please mark the bug as
> UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed.
> Thank you for helping us make LibreOffice even better for everyone!
> Warm Regards,
> QA Team
> You are receiving this mail because:
> * You reported the bug.
I have requested this bug be closed. (No one was willing to do
anything about it, and firefox is going to be replacing HSQLDB anyway.)
Meanwhile I am using Base as a front end for HSQLDB 2.2.9 so I know it
can be done without much difficulty other than with the dialog used to
copy tables from embedded databases to external database files.
Thanks Dan, apologies for the delay and thanks for taking the time to update it.
Per request - marking as INVALID to close the bug