Using Column Alias in MySQL and MariaDB
Article ID: KB0077542
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | 5.x |
Description
Column alias is not working with MySQL and MariaDB
Issue/Introduction
Column alias is not working with MySQL and MariaDB
Resolution
Just append "?useOldAliasMetadataBehavior=true" this property to the JDBC URL e.g.:
For MySQL-
jdbc:mysql://host:3306/mysql?useOldAliasMetadataBehavior=true
For MariaDB-
jdbc:mariadb://host:3306/test?useOldAliasMetadataBehavior=true
For MySQL-
jdbc:mysql://host:3306/mysql?useOldAliasMetadataBehavior=true
For MariaDB-
jdbc:mariadb://host:3306/test?useOldAliasMetadataBehavior=true
Feedback
Yes
No
Powered by
