AliasSubDbMysql
This page provides generated reference documentation for the AliasSubDbMysql data model.
Overview
| Property | Summary |
|---|---|
| host | The host under which the the MySQL server is reachable. |
| port | The port under which the the MySQL server is reachable. |
| database | The name of the database to which this alias is to be connected. |
| schema | The database schema to which this alias is to be connected. |
| user | The user to be used to log on to the MySQL server. |
| password | The password of the user to be used to log on to the MySQL server. |
| characterset | Specifies the character set used by the database. |
| timezone | The timezone of the alias definition. |
| 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. Collations can be set on MySQL and MariaDB using the JDBC URL with the parameters collation_connection… |
host
Type: String
The host under which the the MySQL server is reachable.
port
Type: Integer
Default: 3306
Constraints: Minimum: 0, Maximum: 65536
The port under which the the MySQL server is reachable.
database
Type: String
The name of the database to which this alias is to be connected.
schema
Type: String
The database schema to which this alias is to be connected.
user
Type: String
The user to be used to log on to the MySQL server.
password
Type: String
The password of the user to be used to log on to the MySQL server.
characterset
Type: String
Specifies the character set used by the database.
timezone
Type: String
The timezone of the alias definition.
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