This site contains the documentation that is relevant to older WSO2 product versions and offerings.
For the latest WSO2 documentation, visit https://wso2.com/documentation/.

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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: integrator.sh
    • For Windows: integrator.bat 
  2. Set the following property to false: -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