When using MySQL

(1) Target database

The database that can be used as a repository database is as follows:

  • MySQL

(2) Necessary information for a repository database

When you use the database described in the target database as a repository database, the following information is necessary:

  • Host name or IP address for the environment in which the target database is installed

  • Number of the port providing the service (default value: 3306)

  • Database name

  • Path to the supported JDBC driver

    For details on supported JDBC drivers, refer to HULFT Script system requirements on our website at the following URL:

    URL: http://www.hulft.com/

(3) User settings

Follow the procedure below to configure the settings for the database, and confirm that external connections can be made.

1. Add new users to the database.

2. Set the DBA role to the user you added in step 1. .

3. Set the following values to the database.

Field Name

Setting Value

lower_case_table_names

1

character-set-server

utf8

Use the user you added in step 1. to perform the procedure in (4) Repository database settings.

Note

  • You must set the transaction isolation level of database as READ-COMMITTED.

  • When HULFT Script communicates large data with the repository database (*), you must set a large number to max_allowed_packed of the database.

    * The following shows examples.

    • Creation of a project with many icons

    • Uploading large files

(4) Repository database settings

After installing HULFT Script, configure the settings for the repository database in Control Panel - Repository DB Management in HULFT Script Studio.

The details of the settings for repository database management are shown below.

Table B.2 Settings for repository database management (MySQL)

Field Name

Setting Description

DBMS

MySQL

JDBC Driver Path

Path to the supported JDBC driver confirmed in (2) Necessary information for a repository database

URL

URL of the repository database

Example: jdbc:mysql://<host_name>:<port_number>/<database_name>

User

User added to the database in (3) User settings

Password

Password used in the settings for the user