[Solved] Split HSQL Database Issue (using Split_HSQLDB_2.3.2

[jconnin]

Hello,

I'm trying to work through a problem that I'm having when I try to open my new split HSQL database on a different computer. A few background items: 1) I'm not very familiar with the technical details behind HSQL - I used this template because my last database was corrupted and I wanted something safer. 2)The computer that I created the database on is my home computer, and I'm trying to open the file on my school computer, which has a network drive where user files are stored. 3) I keep multiple computers synced using Dropbox.

I'm guessing that I'm having a problem that is related to the path where the file is stored, however I thought that this was a portable database. I kept the files in their original locations, and the database as well as the data and other files created by the wizard are all in the same folder. When I open the database on my school computer I receive an error message (see the attached Macro Code Error),

Macro Error (First error)

macro_error1.PNG (9.04 KiB) Viewed 3126 times

and then I receive another error message (attached - connection to data source could not be established) when I try to select the database tables.

Connection error

Can you help me? I am hoping to be able to work from both school and home on this database and it'd be nice to figure things out soon. Thanks!

[jconnin]

I'm guessing that I'm having a problem that is related to the path where the file is stored, however I thought that this was a portable database. I kept the files in their original locations, and the database as well as the data and other files created by the wizard are all in the same folder.

I thought about it, and I did change the name of the folder containing the database (template) and all of the corresponding files after the database was created. So I tried to create a new database using the wizard/template and I get almost the same error messages. Here they are:

First_error (same as original message)

macro_error1.PNG (9.04 KiB) Viewed 3119 times

Next error (slightly different)

errorMessage3.PNG (11.33 KiB) Viewed 3119 times

The first error is identical to the original, and the second error is very similar, but a different path is listed. I should also note that this computer is Windows XP, but I'm guessing that the OS is not related to the issue I'm having.

[jconnin]

I created a new database on the C Drive (not network drive) and everything worked fine. I created a table, saved the database then closed, and tried re-opening the database and everything still worked fine. This is almost definitely related to the network drive. Any suggestions for making this work on the network drive?

[Villeroy]

You forgot to tell us which macro you are using.

[jconnin]

I am using the one mentioned in the post title - should have mentioned it in the post too: viewtopic.php?f=83&t=61183 The split database wizard.

[Villeroy]

Try viewtopic.php?f=21&t=77543 instead. It offers dialogs to select the hsqldb.jar and the script file of your database.

[jconnin]

Try viewtopic.php?f=21&t=77543 instead. It offers dialogs to select the hsqldb.jar and the script file of your database.

Hi Villeroy,

Thank you for your help on this topic. Can I use your extension to work with my existing "split database?" If so, how? I have installed the extension, but I don't know how to use it. I tried running a macro from both the existing database and a new one. The first image below is just showing your Macro from the Macro selector. The second one is the error I get when I try to run a macro (In this case I was trying the "ConnectHSQLBackend" helper macro. I'm confused as to how this works. I also recognize this might be a problem that isn't related to Base and Macros so much as how my school's network is set up.

script_error.PNG (9.07 KiB) Viewed 3056 times

[Villeroy]

The macro to call is
Container: My Macros
Library: FreeHSQLDB
Module: FreeHSQLDB
Routine: Main

[jconnin]

The macro to call is
Container: My Macros
Library: FreeHSQLDB
Module: FreeHSQLDB
Routine: Main

Thank you, this worked! Please correct me if I'm wrong - I start with a fresh database, use this macro to connect to the existing data, and then save. I appreciate the help!

Jeremy