4 Replies Latest reply: Sep 13, 2013 1:01 AM by S.Ananth RSS

    Database adapter - timezone value not being picked up

    961903

      We are using Oracle SOA suite v 11.1.1.6, along with database adapter to connect to different Oracle database - D1 and D2. All 3 system - SOA suite, D1 and D2 are set to different timezones. Within the SOA composite, we are using Database adapter to

      1. query data from Oracle database
      2. execute pl/sql stored procedure in Oracle database.

       

      In all cases we noticed that the date time data seen in the SOA EM console is same as in the respective database system, but surprisingly the timezone value in the data field is constant and it does matches with that of SOA suite.

       

       

      <D1_DATE>2013-08-15T01:10:00.000-06:00</D1_DATE>
      <D2_DATE>2013-08-15T02:10:00.000-06:00</D2_DATE>
      Ideally the timezone value should match with that of respective database, from where the date value is being picked up. Did we miss any set up or this a known issue ?
      Thanks.