The second field is truncated when using the MySQL database
Article ID: KB0070863
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Database | 7.x, 8.x |
Description
When working with the MySQL database using the MySQL native driver, if a column has a datetime data type and the second field's value is 0 (e.g., 12:30:00 or 12:00:00), the second field may be truncated when retrieving the record from the database using the plugin (e.g., 12:30 or 12:00).
Issue/Introduction
The second field is truncated when using the MySQL database
Environment
Product: TIBCO ActiveMatrix BusinessWorks Plug-in for Database
Version: 7.x and 8.x
OS: All Supported Operating Systems
Resolution
To address the aforementioned issue, the user needs to add the property "treatMysqlDatetimeAsTimestamp=true" to the JDBC URL. For more details about this property, please refer to the following MySQL documentation:
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-datetime-types-processing.html
Note: The treatMysqlDatetimeAsTimestamp property requires the MySQL driver 8.2.0 or higher.
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-datetime-types-processing.html
Note: The treatMysqlDatetimeAsTimestamp property requires the MySQL driver 8.2.0 or higher.
Feedback
Yes
No
Powered by
