How to: Migrate Base Projects to Multi-User

[zazu]

What I am saying is that when I open the database file - in this case Essential.odb - the autoexec macro runs, the main form opens as it should, but the underlying tables with all the data are not there. Therefore I cannot enter new data, run reports reports etc.

I minimise the form, click on tables in database objects view and this view is devoid of any tables

Click on query in database objects view, run a query - but get error message because the underlying data is not there.

Re backup - In tools > options there is a selection to create a backup and another to specify the path. With both of these selected however there is no backup created.

The script file resides in the same folder as the Start_HSQLDB_Server file as does the Essentia.properties file


[Edit]
I have four files in the folder - script, properties, one with the open office base icon (is this data?) and the fourth is a text file with no content. All of these files have the name "Essential" which is the database name. In summary:

Essential.txt Date Modified 30 March
Essential.OpenDocumentDatabase Date Modified 22 March
Essential.script file Date Modified 30 March
Essential.properties Date Modified 30 March

Also in the folder is the batch file that starts the server which I shut down with CTR+C

This is the content of the batch file

@echo off
set javapath=C:\Program Files\Java\jre6\bin\java.exe
set jarpath=C:\Program Files\OpenOffice.org 3\Basis\program\classes\hsqldb.jar
"%javapath%" -cp "%jarpath%" org.hsqldb.Server -database.0 file:Essential
exit

I have never seen a log file in the folder when the database was open, nor have I seen a file called backup

[Second Edit]
Now this is peculiar - I hit CTRL+C to shut the HSQLD server down. Then ran the batch file again and lo and behold when I opened the database everything was perfect

EXCEPT in the folder all the files are as per above still no log or backup files

[dacm]

Okay, now I remember you used drag&drop of your (backend) tables as well as your front-end (.odb) components (forms, reports, queries and macros) during migration. That means you're using "memory tables" so the .data and associated .backup files will not exist because they are a function of "cached tables." Memory tables are just as persistent as cached tables, and always as fast or faster than cached tables, so I would recommend them anytime your database will fit into RAM on the computer running the HSQLDB server application. Just remember to make regular backups of your .script and .log files.

I've rewritten the note in the tutorial to reflect this clarification:

Note: The .script, .data, and .log files are critical to HSQLDB database backup and recovery because they make-up your database and should be backed-up regularly. The .data and associated .backup files will not exist if you use "memory tables" which is the default for HSQLDB. However, since OpenOffice creates "cached tables" by default, these files (.data and .backup) will exist when migrating to client-server using the zip-extration technique in step (2) above (and since "cached tables" are specified in the extracted .properties file). And finally, the .log file will not exist after a "proper" shutdown or "checkpoint" of the database (HSQLDB back-end components) which is accomplished by issuing (use: Tools > SQL... ) the SQL command: CHECKPOINT DEFRAG <or> SHUTDOWN COMPACT.

[zazu]

Thanks

I also resolved why the tables and data were not showing. Not sure hat caused the change, but the batch file starting the HSQLDB was starting up from the wrong folder. The batch file was in the start up folder whereas a shortcut pointing to the batch file should have been in the start up folder

[hwoehrle]

Thanks for this great thread. But maybe ther are some important issues that should be mentioned in the first post:

H2:
- no subforms supported in newer versions (up to latest develompent releases) - or i'm too stupid to get it working...


MqSQL:
- no relations supported. All relations have to be entered manually with sql commands.
edit: Maybe i was to quick on this. Trying http://www.oooforum.org/forum/viewtopic.phtml?t=61027


So after more than 2 days of testing im back to zero

[dacm]

[liherb]

[dacm]

[liherb]

[johnnysimmons]

HSQL running on the server, and the completion of Step 2, I re-start the base. In the Database Wizard Step 1, I think I should choose the third option "Connect to an existing database" and leave it in the JDBC settings. In the next window "to establish a JDBC database connection" (wizard step 2) there are two empty boxes, I had to fill before I can continue, "data source URL JDBC:" and "JDBC driver class." These should be empty (remember, I did not pass 2E step 2a)? I should be in the "Data Source" box, type a DOS path of the file, the batch file to create? I have nothing, I should be in "JDBC driver class' box idea.



Moderation probe1: disabled signatur with SPAM link

[dacm]