![]() (3) download two files (fundamentalbasis.ini and mydb.odb) and install them manually using the step-by-step tutorial on the same post as the 'quick fix' downloads. (2b) download 'hsqldb2_mydb' if you want the file/server mode (.odb) files pre-configured for HSQLDB 2.0.1. There's no need to run the 'quick fix' (mydb.jar) if you're starting from scratch without legacy databases to migrate/upgrade. (2a) download 'hsqldb2_OOo.jar' and run it to upgrade to HSQLDB 2.0.1. The main tutorial includes a link for step-by-step migration if this is necessary. This is useful for users who need to migrate legacy databases to the multi-mode/file format for reliability. This 'quick fix' option simply adds multi-mode support for HSQLDB allowing legacy "embedded databases" to function normally. This automatically adds multi-mode support and installs the pre-configured file/server mode (.odb) files. Or click on 'START.vbs' (Windows only) to start Base in server mode. Just click on '' to start Base in file: mode. As a Windows user, you'll have seamless database access in either mode. The installer sets-up Base automatically and installs pre-configured file/server mode (.odb) files for immediate use. However, at the end of the same post is a large underlined link that takes you to the 'Quick FIx' tutorial page with several options including a downloadable installer. That link mostly serves as an explanation of the problem. I haven't tried that, so definitely don't do it the first time with a database that contains important data.Įvwool wrote.but I can't figure out from the link how run Base in 'file:mode'.It tells you what to do but not how to do it. I think you could edit that to refer to whatever file path currently refers to the Base file. If you open the Base file and select Edit → Database → Properties, you will see the URL. If you can't use the same file structure on every computer, it might be feasible to edit the database properties at the time of use. Hsqldb:file:D:/databases/DB/TestPortableDB default_schema=true shutdown=true fault_table_type=cached get_column_name=false ![]() I tried storing a database in the folder D:\Databases\DB and I named the Base file TestPortableDB. If you can't use the C:\users\public\databases folder structure, you can use any other, you just need to change the URL in step 2b to refer to the correct file path. You should be able to copy the entire mydb folder to another system as long as the same C:\users\public\databases folder structure is used on the new system. This group of files must all be moved together to port the database, because the tables are no longer within the Base file. You can change either one of these to a name you prefer, just keep the URL, the folder name and the file name consistent in steps 0b, 2b and 2f.Īfter saving the Base file (and perhaps adding a table), if you look in the folder C:\users\public\databases\mydb you will see the Base file and several other files created by the HSQL data base. ![]() In the long URL string in step 2b the first occurrence of mydb refers to the folder name and the second mydb refers to the file name. (2f) Save the file in the \users\public\databases\mydb folder giving it the name mydb. (2e) Allow OOo to register the database if you want to Just copy and paste the above text into the URL box Hsqldb:file:/users/public/databases/mydb/mydb default_schema=true shutdown=true fault_table_type=cached get_column_name=false Select Connect to an existing database > JDBC (Next.) (2a) Start and choose to create a new Base file. (1c) Shutdown and Restart OpenOffice (and Quick-Starter) to save the settings. Click Open or OK to get out of all the dialogs On my XP system this file is at C:\Program Files\ 3\Basis\program\classes. (1b) While still in the same Tools>Options>Java dialog, click on the button Class Path on the right.Ĭlick on the Add Archive button, browse to the location of the hsqldb.jar file used by and select it If you have been using Base, I think this must be already set. ![]() Select 'Use a Java runtime environment' and a recent-version Java installation (1a) Start OpenOffice and go to the menu Tools>Options>Java Setting up the HSQLDB Java code as a program independent of Judging from DACM's post the C:\users\public folder should be available on XP, Vista, and Win 7 systems. (0b) in the new databases folder create a folder named mydb. (0a) in the folder C:\users\public create a folder named databases Remember that I don't really understand what I'm doing! Here is an edited version of DACM's instructions for manually setting up a file:mode database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |