Persisting Global Parameters in the Database

For additional information on plugins, refer to:

How to configure the SQL Parameter Storage plugin

In the <server_directory>/configurations folder, create the following file: sql_globalparameter_storage_config.xml.

Insert the following content.

XML

<?xml version="1.0"?>
<Configuration>
	<DatabaseConfiguration>
		<ConnectionString></ConnectionString>
		<UserName></UserName>
		<Password></Password>
	</DatabaseConfiguration>
	<UseLegacyDatabase>false</UseLegacyDatabase>
</Configuration>

Enter the required values in the sql_globalparameter_storage_config.xml file.

Database Configuration

Element	Description	Possible values
`ConnectionString`	JDBC connection string for the connection to the database For more information, see the official JDBC database documentation.	Connection URL for the JDBC database
`UserName`	User name for the login to the database	Any string
`Password`	Password for the login to the database	Any string
`UseLegacyDatabase`	Determines whether: a new database should be created (recommended) or the connection to an existing database should be established	`false`: A new database is created. `true`: A connection to an existing database is established.

How to install the plugin

Note:

If you enable the SQL Parameter Storage plugin, the default properties folder with subfolders in memory will no longer be used:

<server_directory>\wildfly\modules\de\softproject\x4\plugins \globalparameter\properties

Before installing the plugin, delete the properties with contents.

Unzip the downloaded .zip file with the plugin.
Copy the <file_directory>\de folder to the <server_directory>\wildfly\modules\de\softproject\x4\plugins folder.
Open the module.xml file in the <server_directory>\wildfly\modules\de\softproject\plugins\main folder.
Delete the following line from the module.xml file:

<module name="de.softproject.x4.plugins.globalparameter.properties" export="true"/>
Copy the plugin name into the <dependencies> tag:

<module name="de.softproject.x4.plugins.globalparameter.sql" export="true"/>

The content of the file should be structured in this way:
Restart the X4 Server.
The plugin is available after the server restart.