Functional restrictions specific to MySQL adapter

The MySQL adapter for HULFT IoT EdgeStreaming has the following functional restrictions.

For details on the functional restrictions for HULFT IoT EdgeStreaming, refer to First Step Guide.

 

(1) Writing of the current date/time

In MySQL Ver.8.0.18 or lower, the data resulting from the Current date/time logic cannot be written directly to the following data types during the insert operation by the MySQL adapter:

  • DATE

  • DATETIME

  • TIMESTAMP

  • TIME

When writing the data resulting from the Current date/time logic to the above data types, use the Date/Time formatting logic.

The setting method is as follows:

  1. From the Mapper editor tool palette, select the String > Date > Date/Time formatting logic, and drag and drop onto the mapping canvas.

  2. Double-click the component icon of the Date/Time formatting logic that you placed on the mapping canvas to display the property settings dialog box.

  3. In the property settings dialog box, enter "2006-01-02 15:04:05.999999" for Format and click Finish.

  4. Draw mapping link from the Current date/time logic to the Date/Time formatting logic.

  5. Draw mapping link from the Date/Time formatting logic to "the column to which you want to write that is shown in the output schema."