AliasSubDbMariaDb
This page provides generated reference documentation for the AliasSubDbMariaDb data model.
Implementierung für MariaDB.
Overview
| Property | Summary |
|---|---|
| autoOrderByID | If yes/true, each frame is automatically sorted by the ID column of the respective database table. If no/false, no automatic sorting will be executed. |
| collation | Specifies the sorting strategy for indexes, and so on. |
| database | The name of the database to which this alias is to be connected. |
| host | The host under which the MariaDB database server is reachable. |
| password | The password of the user to be used to log on to the MariaDB database server. |
| port | The port under which the MariaDB database server is reachable. |
| timezone | The timezone of the alias definition. |
| user | The user to be used to log on to the MariaDB database server. |
autoOrderByID
Type: Boolean
Default: true
If yes/true, each frame is automatically sorted by the ID column of the respective database table. If no/false, no automatic sorting will be executed.
collation
Type: String
Specifies the sorting strategy for indexes, and so on.
Collations can be set on MySQL and MariaDB using the JDBC URL with the parameters collation_connection or character_set_connection.
Example:
jdbc:mysql://localhost:3305?sessionVariables=collation_connection=latin1_swedish_ci
database
Type: String
The name of the database to which this alias is to be connected.
host
Type: String
The host under which the MariaDB database server is reachable.
password
Type: String
The password of the user to be used to log on to the MariaDB database server.
port
Type: Integer
Default: 3306
Constraints: Minimum: 0, Maximum: 65536
The port under which the MariaDB database server is reachable.
timezone
Type: String
The timezone of the alias definition.
user
Type: String
The user to be used to log on to the MariaDB database server.