pm-c wrote:When I try to use the files "Ny database" (New database) and "Ny database1" I get the message:
"No connection to source Ny database - file input/output error java.lang.NullPointer.Exception.proporties
C:\Users\Documents\Ny database."
What do I do wrong?
You're not doing anything wrong, but you may be getting ahead of yourself.
Edit: It is now possible to run all versions of HSQLDB simultaneously, complete with legacy 'embedded database' support, using a single installation of Base. Simply adopt macro-enhanced templates to support your split-databases. You can drag-&-drop your existing Queries, Forms and Reports to the template, while copy-&-pasting your existing Macros. |
The "New Database" wizard in Base is effectively disabled when you upgrade to HSQLDB 2.x. And any legacy "embedded databases" (that you previously created with the "New Database" wizard in Base) are also inaccessible while Base is configured with HSQLDB 2.x support.
To re-gain legacy "embedded database" support, you can temporarily override HSQLDB 2.x support by following the instructions for:
Manual "split-database" setup. But you'll have to undo this override to re-gain HSQLDB 2.x support in the future. It's actually easier to simply downgrade to the built-in version (HSQLDB 1.8.0.10) by running
mydb.exe, perhaps only for migration purposes to the "multi-mode" configuration -- which can then be upgraded to HSQLDB 2.x by re-running the dedicated installer (
hsqldb_OOo.exe). Or some find it easier to simply install
LibreOffice Portable in addition to OOo to supply legacy "embedded database" support.
But as for creating a new HSQLDB 2.x database, if you opted to install the Base front-end files with the HSQLDB 2.x installation, then you should be running C:\Users\<current user>\Databases\mydb\
mydb.file.odb without moving or renaming anything (at this point). Or you can run
START.vbs or
server.start.bat (also found in the mydb folder; START.vbs simply runs server.start.bat silently) to run the HSQLDB engine in server-mode.
These methods create a new database as necessary when you click on the Tables icon in Base. To run in server-mode, you may need to edit the folder/paths in
server.start.bat in order to reflect a non-default installation of OOo.