HSQL Data Connection

This document describes how to connect to the HyperSQL (HSQL) database.

Note: 

Avoid naming HSQL database tables starting with numbers, which may cause connection errors.

Prerequisite 

For details, see Overview of Data Connection.

Version and Driver 

Connection Information Collection 

Collect the following information before connecting FineDataLink to the database.   

• Database name

• Database storage path

1. Log in to FineDataLink as the admin, choose System Management > Data Connection > Data Connection Management, select a folder, and create a data connection, as shown in the following figure. 

2. Set the data connection name. You can also modify the directory of the data connection. 

3. Find the data source by searching the data source name or filtering the data source by Data Source Type, Supported Form, and Compatible Module, as shown in the following figure. 

4. Enter the username and password, and replace PATH_TO_DB_FILES in the data connection URL with the database path.

For example, if the built-in database is stored in the \FineDataLink\webapps\webroot\WEB-INF\embed\nedb\db path, the data connection URL should be jdbc:hsqldb:file:D:\FineDataLink\webapps\webroot\WEB-INF\embed\finedb\db.

You cannot set Schema unless the database is connected. Click Click to Connect Database and then select the schema, as shown in the following figure.

4. Click Test Connection. If the connection is successful, click Save, as shown in the following figure.