Uploaded image for project: 'ZZZ-WSO2 Data Services Server'
  1. ZZZ-WSO2 Data Services Server
  2. DS-1161

Different dates with DSS-3.0.1 and DSS-3.5.0

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: 3.5.0
    • Fix Version/s: 3.5.1
    • Component/s: core
    • Labels:
    • Severity:
      Major
    • Estimated Complexity:
      Moderate

      Description

      Hello,

      We are currently using WSO2 DSS 3.0.1, and we are going to migrate all our data services to WSO2 DSS 3.5.0.

      I tested the same service on both, and I don't have the same results :

      V3.0.1

      <swapExposure>
      <reportDate>2015-10-01T00:00:00.000+02:00</reportDate>
      <tradeDate>2015-09-22T00:00:00.000+02:00</tradeDate>
      <maturityDate>2015-12-22T00:00:00.000+01:00</maturityDate>
      <ia>0</ia>
      </swapExposure>

      V3.5.0

      <swapExposure>
      <reportDate>2015-10-01T02:00:00.000+02:00</reportDate>
      <tradeDate>2015-09-22T02:00:00.000+02:00</tradeDate>
      <maturityDate>2015-12-22T01:00:00.000+01:00</maturityDate>
      <ia xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
      </swapExposure>

      As you can see, 2 things have changed :

      1) WSO2 returns null if an integer field is null in the database. Before, it returned 0
      2) The timezone seems to be added to the actual time in this new version. If I run the SQL query (Sybase), the dateTime correspond to version 3.0.1. The values returned by version 3.5.0 seems to be wrong

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                rajithv@wso2.com Rajith Vitharana
                Reporter:
                t.tirtia@satisco.be Thibaut Tirtia
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 1 day
                  1d
                  Remaining:
                  Remaining Estimate - 1 day
                  1d
                  Logged:
                  Time Spent - Not Specified
                  Not Specified