hsqldb v.1.61 Client/Server Demo / Server

For this mode, both the server and the client must run as applications. They can be on the same computer, or on separate computers, but they must have access to each other over TCP/IP. Normally, this can be done only in a LAN (local area network) or WAN (wide area network), but not over the internet, because of security restrictions (for example firewalls).

To test this mode, you need to start one server and one (or many) clients, and then connect with the client(s) to the server.

How to start the server

There is a batch file provided in the demo directory. To start the application on Windows type:

runServer

The server will consume this command window. To display the command line options of the Server, type:

runServer -?

After you have started the server, you can connect to it by starting a client application (in a separate command window):

run DatabaseManager

Select 'Hypersonic SQL Server' and connect to the server.

How to stop the server

The server closes the database and stops automatically when the command 'SHUTDOWN' is executed. To abort the server, press [Ctrl]+[C] (on Windows).

How to clean the database

The database will write to the files 'test.*'. If it is closed and started again, it will automatically reload the data. To get a a clean database, all 'test.*' files must be deleted.