How to: Migrate Base Projects to Multi-User

[zazu]

I have a shortcut on the computer which links to the database on the server. Clicking the shortcut opens the database. The bottom of the screen shows JDBC and hsqldb:hsql://localhost/;default_shema=true

When I click to open a form or move to say Tables thats when I get the error message

I have checked the server startup and these are some of the lines in the window

Loaded properties from [E:\Network Data Folder\ManurewaDatabase\server.properties]
Initiating startup sequence...
Server socket opened successfully in 110ms
Database [index=0, id=0, db=file:Manurewa, alias=] opened successfully in 3078ns
Startup sequence completed in 3219 ns
2010-03-16 11:05:11.781 HSQLB server 1.8.0 is online

EDIT
I note early in this thread there is discussion and cross reference to How To: Replace HSQLDB with H2 embedded multi-user

So, do I need to do this first in order to make base truly multi user? All the techie talk is somewhat daunting and I wonder if someone could prepare a summary of what we need to do to have a multi user environment -then I could read up on the specific things I need to do and hopefully implement them

Thanx in advance

[dacm]

[zazu]

Thanks, i'll keep working and learning

[zazu]

I ran an embedded base on the server and I noticed that when a user closed the base the obd.lck file did not close. Also the "quickstart"(?) icon was in the system tray. As soon as I exited the quickstart icon the odb.lck file closed. Therefore is it possible that this quickstart function keeping the odb.lck file open, also prevents multi user access when a multi user database is being used?

[dacm]

I don't think so. That's an external mechanism that is used to alert other users/applications that they don't have exclusive access.

I think your issue is a network issue like file sharing. So can you see the database files or folder acroos the network using Windows Explorer or My Network Places? That's a good place to start troubleshooting this issue.

[zazu]

I still seem to be stuck. I have checked my Kaspersky Security parameters and everything is ok there. I can open up Base on my pc, click on open existing database and there to behold is a database with JDC and hsqldb....=true in the info line. The Customer Form is listed in the forms window, but clicking to open results in the cannot load driver error.

On my local pc I then proceed with the process of setting up a connection to the database and again at Step 3c get the cannot load driver error again (I had substituted localhost with the server ip address)

Is there something we need to do on the networked pcs or the local copy of base to make this happen. I should mention that we have copied and pasted tables/queries/macros/forms from an embedded database that is saved on the server

[zazu]

I think I've fixed the problem. I needed to set up the Java environment in the Database>Tools>Options>Java for each PC that needs access to the database

Now, when PCs open the database the main form autexecs as required, but a new problem has been encountered. I have another form (which is a help file) and a report that should open from a new menu we've created or a button on the main form.

They used to open now sometimes they open and sometimes I get the dialog message that no connection could be made to the database

Edit Is this likely because the form and report have been created in another database and copied/paste into the multi-user database?

[dacm]

[zazu]

I was able to copy/paste the tables ok and overcame the autovalue problem by amending the script file as mentioned earlier in this thread by glj (4 March 2010)

[dacm]

That was just a hunch. Otherwise, the only time I've seen intermittent table access issues is when OpenOffice has crashed in another instance/window requiring task or computer restart. Just another hunch.

[zazu]

How do you get the data to update?

I have a main form "Customer" and a number of sub forms - one called "Matter" (this is for a law firm)

The Matter subform has two column (table layout) MatterNo and Description. It might look likr this:

1 House sale
2 Employment Contract
3 Car accident

Another subform relates to the billing and I have a drop down box that is based on the Matter subform/table. Example I might write a letter to the employer about the employment contract and need to identify this in the billing subform. The billing detail is fine and then I use a drop down box which gives me a list of matters for this customer - in this case 1, 2 and 3 and I choose 2.

However the problem is that if I am working in this form and have just entered say 3 Car accident in the matter subform and then move my cursor to the billing subform and click on the drop down box 3 is not there. Even if i move to another customer and come back it is still not there. I have to close/open the form for the data to be refreshed.

[Solved] I read in a different post on the forum (http://www.oooforum.org/forum/viewtopic.phtml?t=97086&highlight=refresh) about the Refresh button on the form

[zazu]

If I want to open a second database in multi user mode do I create a second batch file like:

@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:Database1
exit

replacing Database1 with Database2

or do I add an extra line like

@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:Database1
"%javapath%" -cp "%jarpath%" org.hsqldb.Server -database.0 file:Database2
exit

[dacm]

We could look it up in the documentation...but I think it's a single line:

[zazu]

What happened to my tables ??

Successfully created a multi user database for a law firm. (thanks to everybody who helped)

Client has been using it for a while, but all of a sudden there are no tables.

I know that in the front end you cannot see tables, but I would expect to see them and perhaps edit them in the back end - but they are not there.

Alledit functions in the back end seem greyed out.

There is no back up copy, but there is a script file

[dacm]