This documentation is for WSO2 Enterprise Integrator version 6.4.0 . View documentation for the latest release in the 6.x.x family and the latest release in the 7.x.x family.

All docs This doc
Skip to end of metadata
Go to start of metadata

Note that the following functionality is only applicable to data integration in WSO2 Enterprise Integrator.

By default, a timestamp is always converted to the UTC time zone before inserting the timestamp data to the database. When retrieving the data, the server will convert the timestamp back to the server's time zone. This can sometimes lead to inconsistencies where the time zones applicable to timestamps (for inserting data and retrieving data) are different. Therefore, you can disable UTC conversion for RDBMSs as follows:

  1. Open the server startup script, which is stored in the <EI_HOME>/bin directory.
    • For Linux:
    • For Windows: integrator.bat 
  2. Set the following property to true: -Ddss.legacy.timezone.mode=true

This configuration ensures that data is entered into RDBMSs using the server time zone without converting to UTC.

  • No labels