Base crashes randomly

[arfgh]

HI

since i am using OpenOffice during the last years, i am having the same problem related to BASE.
The fact is when i am using BASE, eventually and randonly crash. Some times the crash dont throw problems, but others may results the database lose something. Usually i cant access some form, and i have to delete and rebuilt. And other times all the tables gone from the list.

It is the only one problem that i keep with my OO usage during the years and i want to know if i can do something to prevent, fix, etc.

PD for some reason i suspects that the source of the problem could be the compression that BASE performs in the DB...

please help !

[Villeroy]

Leave behind the embedded HSQLDB
0) Make a backup of your database.
1) Close the office.
2) Open your .odb with a zip tool and extract the database directory.
3) Rename the extracted files script, properties, data to db.script, db.properties, db.data (db is just an arbitrary name prefix for the extracted files).
4) Download the latest hsqldb from http://www.hsqldb.org/ (version 2.3. at the time of writing). This requires no installation. Just extract it somewhere. Basically, all you need is the contained lib/hsqldb.jar and the documentation.
5) Download and install this extension of mine: http://forum.openoffice.org/en/forum/do ... p?id=17008 (don't extract that zip, call menu:Tools>ExtensionManager...)
6) Open your .odb with OpenOffice, call Tools>Macros>Run... MyMacros>FreeHsqldb>FreeHsqldb>Main
7) Click the first button and point the file picker to the .script file you extracted and renamed at steps 2) and 3)
8) Click the second button and point the file picker to the hsqldb.jar you extracted at 4)

Close the tool, save the document and give a try. Now you have the full featured database backend separated from your Base document. You may move the backend on a server for multi-user access (requires more tweaking).

Now you may want to free your forms as well.
[Tutorial] Standalone Forms / Switchboard

[arfgh]

ok...

so i guess that the problem is the embedded HSQLDB usded in OO ?
Exist a way to replace the embedded HSQLDB for the most recent one ?

[arfgh]

more info is required, please. Why BASE crash ramdonly ? which is the real cause ?

[RPG]

Hello

There you write macro without understanding the macros it is possible your problem is in your macros.

Romke

[arfgh]

no, it isnt a macro problem. It is a problem that happends randomly.

[RoryOF]

If they are truely random crashes then they cannot be systematically reproduced for faultfinding. The cause may be a configuration problem on your computer. Start Windows in Safe Mode (F8 while "starting Windows" message) and then run OpenOffice. If the crashes reduce or vanish the cause of the crashes is some crosstalk from an installed program or driver.

[Villeroy]

Could be a hardware problem as well. However, a split database backend reduces the risk of data loss.

[arfgh]

it isnt a problem about hardware because happends on all the computers where i tried OO.
The problem dont happends all the days but appears suddenly without warning.

Sometime i can hear the warning sound when close the database, and other appears a warning that show some text. The final state is a corrupted database. So the problem must be from OO internally and i am sure that exist more ppl with this kind of problems because i have read tons of topics here on this forum.

we need to know what exactly happends because the base isnt trustable by this way.

[Villeroy]

This f***ng container format works like an extension. Every time when you think you open a database document it installs a database backend and connects the office frontend to it. Every time when you think you close a database document it actually shuts down the connection and re-packages the whole extension. When any of the involved software modules crashes during extraction or compression, your data surely will be lost. Things are really complex when more than one office component keeps a connection to the same database (mail merge, spreadsheet, input forms, reports, macros,...).
Stop using this shit and use the real thing which is a stable, mature and up-to-date database engine together with some ordinary office documents and a "database document" that serves as a configuration file only. It is fairly easy to do and you won't go back to the odb container. Finally you may find that OpenOffice is not the only program which is able to deal with a true stand-alone database.

[arfgh]

aham Villeroy , and which is this wonderful program that you are suggesting ?

Yes, for some reasson i always thought that is the compression who cause these problems in base. Of course it is a thought...
We need more info related to this !

[Villeroy]

Follow the steps suggested in my first answer and you will see. You will have a stable HSQL database of version 2.3 completely independent from OpenOffice. The maximum loss of data will be the currently edited record.